By Kalen Delaney, 01/25/2008
Column statistics—statistics on unindexed table columns—complement index statistics and give the optimizer additional information to use in determining the most efficient query ...
By Itzik Ben-Gan, 01/25/2008
Under both Read Uncommitted and Read Committed isolations, updates running during an index-order scan can result in reading the same row multiple times or skipping rows.
By Michael Otey, 01/25/2008
YouTube.com offers many SQL Server videos—some by SQL Server Magazine authors and Microsoft executives--on topics such as performance tuning, disk optimization, backup types, and ...
By Kevin Kline, 01/25/2008
This free tool can help you find SQL Server and MSDE installations that need to be secured.
By Rodney Landrum, 01/25/2008
This update to the original DBA Repository solution adds support for SQL Server 2005, support for SQL Server authenticated domains, support for server location, information for ...
By Pinalkumar Dave, 01/25/2008
Server backup doesn’t have to be complex. With these simple commands you can perform full, transaction log or incremental, differential, and file backups. Plus you’ll learn ...
By John Green, 01/25/2008
This monitoring and management product can help you diagnose database performance problems so that you can quickly resolve them.
By Editors, 01/25/2008
Check out new and improved SQL Server-related products from Acronis, Dundas, ISC, and TulaSoft.
By Michael Otey, 01/25/2008
Find out what Michael says is missing from SQL Server 2008 and what Microsoft should include in its next release.
By Craig Utley, 01/25/2008
PerformancePoint Server 2007 might be in your future, especially if your users find out about its BI features. Get the lowdown before they do about the 3 parts of PerformancePoint ...
By Michelle A. Poolet, 01/25/2008
You can manage rapidly changing monster dimensions by splitting the stable and hot attributes or by creating non-overlapping value ranges for each rapidly changing attribute.
By Itzik Ben-Gan, 01/25/2008
Get the solution to January’s puzzle “Counting Triangles,” and prepare your mind for February’s puzzle, which involves determining weights.
By Michael Otey, 01/25/2008
If you’re running virtual machines in a production environment and are experiencing performance problems, check out DXtreme for Windows Enterprise, which can enhance your virtual ...
By Bill McEvoy, 01/25/2008
Using SQL Server Management Studio (SSMS) to document job schedules involves a lot of mouse-clicking and cutting and pasting. You can avoid all that hassle by using the ...
By Paul Goldy, 01/25/2008
It's not uncommon for MDX programmers to create an elegant calculated member, only to discover that it's so slow that it can't be used in queries against a full data set. Learn ...
By Asif Sayed, 01/25/2008
Forget the complicated self-joins. Thanks to new Crystal Reports support in Visual Studio 2005, reporting on hierarchical data has never been easier.
By Kalen Delaney, 09/20/2007
Tune performance by using UPDATE STATISTICS and trace flags to improve the quality of index statistics by ensuring they’re regularly updated.