By Itzik Ben-Gan, 02/28/2008
Get the solution to February’s puzzle “Counterfeit Coins,” and prepare your mind for March’s puzzle.
By Andrew J. Kelly, 02/28/2008
SQL Server 2005 offers a relatively easy way to determine which SQL Server statements are causing you the most pain. A built-in DMV does the trick.
By Bill McEvoy, 02/28/2008
Whether you are new to T-SQL or you just want to brush up on the basics, you'll want to read and save this guide that walks you through how to write SELECT statements. Learn how ...
By Jeff James, 02/28/2008
Check out new and improved SQL Server-related products from OmBelt Solutions, Red Gate Software, ScriptLogic, Future IT Software, and Stimulsoft.
By Pinalkumar Dave, 02/28/2008
More answers to DBAs' questions. What’s the difference between dividing an integer with NULL or zero, or between a unique constraint and a primary key constraint, or between ...
By Michael Otey, 02/28/2008
Choose which server consolidation method is right for you. Mike Otey walks you through factors to consider for your organization.
By Anne Grubb, 02/28/2008
A reader asks Douglas McDowell a question about his PerformancePoint Server Eye on BI article, forum members debate SQL Server trace methods, and Rodney Landrum updates his ...
By Kevin Kline, 02/28/2008
You can use this tool to quickly and easily test how a query will affect your system performance.
By William Vaughn, 02/28/2008
Build a sample application in Visual Studio that can be used to manage hierarchical rowsets populated by stored procedures.
By Itzik Ben-Gan, 02/28/2008
SQL Server 2008’s MERGE statement simplifies the task of merging source data into a target table.
By Orin Thomas, 02/28/2008
Get the facts about the new data compression feature in SQL Server 2008 and the stored procedure that can help you estimate how much space you might save by compressing your data.
By Michael Otey, 02/28/2008
VS 2008 adds support for new technologies such as AJAX, Windows Presentation Foundation (WPF), and Language-Integrated Query (LINQ), and more.
By Randy Dyess, 02/28/2008
The new Extensible Key Management feature makes SQL Server’s built-in database encryption more secure by supporting third-party encryption providers, so that you can store keys ...