August 2006
AdventureWorks sample database used to be included with SQL Server 2000, but now it's a separate download.
August 2006
SQL Server 2005 offers two options that help you optimize database performance: forced parameterization and plan guides. Find out how to use these options.
August 2006
Find out how to use SQL Server 2005's forced parameterization and plan guides to change SQL query behavior.
July 2006
When you upgrade to SQL Server 2005, remember to check to make sure the compatibility level has changed to a value of 90 during the upgrade process.
July 2006
An anomaly in SQL Server 2005 Profiler's GUI can be confusing. Here's the scoop on how SQL Server 2005 displays duration and CPU values.
July 2006
There's been a change; SQL Server Profiler running under SQL Server 2005 now captures duration values at a higher level of granularity.
July 2006
Microsoft recently released SQL Server 2005 Report Packs, which provides 65 reports that are designed to help you author and generate reports for your environment in a timely manner.
June 2006
SQL Server Configuration Manager and SQL Server Surface Area Configuration tool have a lot in common, but Microsoft MVPs provide a general rule of thumb for when to use these tools.
June 2006
: SQL Server 2005 provides a new function called NewSequentialID that is very similar to NewID(). Find out which function gives better performance and which function lists results in sequential order.
June 2006
Yes, finding information about keyboard short cuts can be a challenge, but here's how users can find some of the common DExplore shortcuts.
May 2006
Here's a tip about defining relationships between key and non-key attributes in your dimensions.
May 2006
Check for fragmentation in database files on the disk array. It could be causing some of your performance problems.
June 2006
Learn how to restore the registry and environment settings required by DTS if you're upgrading to SQL Server 2005.
June 2006
It’s a good idea to know what third-party monitoring tools are doing if you choose to run them on your server. Here’s a problem you might encounter.
April 2006
Find out how to enable the SQLCLR tool and set the appropriate permissions before running .NET applications on your server.
June 2006
Microsoft has changed the way that Books Online (BOL) works. Now, you have the added option to search Internet sources.
April 2006
There's variance in how the Enhanced Read-ahead and Scan option works on the SQL Server 2005 Standard and Enterprise Editions, which can result in performance differences.
February 2006
Find out how to troubleshoot performance problems between two servers when everything seems the same but performance differs.
December 2005
Don’t assume that using a SAN is always the best course. Find out how using DAS is often an easier and more cost-effective solution.
October 21, 2005
Setting cache to 50 percent read and 50 percent write seems reasonable, but 100 percent write is almost always more effective.
Add these Headlines to your Website
