(Scott Hayes) The secret to successful database performance tuning and optimization requires an intimate understanding of workload costs. You can become a Performance Hero in your organization by determining current workload costs, and then making physical design and configuration changes to lower t
Other News
Rolling Sums in SQL – A Practical Example
(Jay Pipes) Today, Lenz was putting together some stats on PlanetMySQL feeds added since January this year, and asked in an email whether he should include totals in the stats. I responded yes, and offered a quick SQL solution to get those numbers out of the database. I thought it might be useful fo
SQL Server Versions: Faster! Slower! Wait! Go!
Watch the Latest SelectViews SQL Server Weekly Show We posted the show to the site on Friday – watch it online here. SQL Server Versions I’ve had a number of you mention that you’re concerned about the versioning with SQL Server. Specifically, with the shorter version cycles, new updates, service packs and such coming at a faster rate, how will […]
More on Triggers and Styles and Control Templates
(Chris Sells and Ian Griffiths) Completing this four-part series, we continue our discussion of triggers and deepen our knowledge of templates.
Partner TechTip: Creating SQL Materialized Queries
(Kevin Forsythe) Despite our best efforts to achieve excellent database normalization, sometimes it’s necessary or simply more efficient to create a temporary table containing some data as of a certain time. SQL satisfies this need with Materialized Query Tables (MQT). These specialized SQL objects
One more Xquery posting
(Andrej Koelewijn) I started my xquery blog posts because i wanted to illustrate how you can use xquery to query xml documents in a java program. Most of Oracle’s examples are using Oracle’s XMLDB to demo how you can query xml in an Oracle database.
WPF For The WinForms Developer: Part 3
(Ged Mead) If you recall, the Button that we have placed in the top left of the Grid (Column 0, Row 0) is configured to automatically resize itself as the Window is resized. Once you get past the first flush of pleasure at this handy and easy to implement facility, you’ll probably come to realise th
Creating Databases and Tables In SQL
(Mike Chapple) Are you ready to begin creating databases and tables with the Structured Query Language? In this article, we explore the process of creating tables manually with the CREATE DATABASE and CREATE TABLE commands. If you’re new to SQL, you may wish to review our SQL Basics article first.
Using Boolean Operators for Full Text and Boolean Searches with MySQL
(Alejandro Gervasio) Implementing full text searches with MySQL can improve the execution of queries against specific database tables. If you want to put this useful feature to work for you, start reading this article now! Welcome to the final tutorial of the series that began with “Performing Full
RSS Newsfeed Workbench
(Robyn Page and Phil Factor) Have you ever fancied being able to put Simple-Talk’s content into a database? We haven’t either, but we’ll do it just for practice. The objective of this workbench is to show just how easy it is to implement an RSS-based datafeed in SQL Server 2005. The purpose is to tr