By Rick Dobson, 03/22/2005
ADO.NET developers often use T-SQL strings to retrieve data for applications, but poorly written strings can lead to errors. By learning a few techniques, you can provide ...
By Brian Moran, 03/22/2005
The estimated number of row counts is incredibly important when Query Analyzer is choosing an execution plan.
By Michael Otey, 03/22/2005
The bulk of Microsoft's SQL Server downloads aren't found on the SQL Server home page, but on the less specific downloads page. Here are the five most interesting SQL ...
By Itzik Ben-Gan, 03/22/2005
Check your answer to March's logic puzzle and try the April puzzle: Find the shortest path between two points on a cube.
By Itzik Ben-Gan, 03/22/2005
Tiebreakers can make the difference between generally correct results and exactly the answer you need.
By Microsoft's SQL Server Development Team, 03/22/2005
Microsoft's Gert Drapers explains why a reader might be experiencing problems trying to debug T-SQL stored procedures.
By Michael Otey, 03/22/2005
Unlike the other enterprise database vendors, Microsoft and SQL Server aren't tied to any of the popular enterprise ERP products--and that's good news for customers.
By Dawn Cyr, 03/22/2005
A reader highlights his favorite products: Red Gate SQL Compare and SQL Data Compare.
By Dawn Cyr, 03/22/2005
Check out new and improved SQL Server-related products.
By Matt Nunn, 03/22/2005
SQL Server Senior Product Manager Matt Nunn reviews database evolution to help us understand the revolutionary nature of the new SQL Server 2005 features that make the database ...
By Michael Otey, 03/22/2005
Intel's Itanium2 chip has features that look to the future.
By Douglas McDowell, 03/22/2005
Although SQL Server 2000 (64-bit) has been available for 2 years, few organizations have been willing to put their money on it. Here are three scenarios that demonstrate that ...
By Craig Utley, 03/22/2005
Drillthrough lets you look at the individual records in a cube, but you can't modify a drillthrough query on the fly. You can create a drillthrough report, then use a cell-level ...
By Kalen Delaney, 03/22/2005
When you learn what information the sysindexes table has to offer, you'll be better able to work with your indexes and tables.
By Microsoft's SQL Server Development Team, 03/22/2005
Microsoft's Patrick Conlan explains how differential backups fit into a reader's restore scenario.