SQL Server Magazine April 2005
[Features]
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 betting on 64-bit SQL Server can pay off--both now and in the long run.
By Douglas McDowell
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 developers with a code library to use for many common data-access tasks.
By Rick Dobson
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 action to call the report and pass the parameters.
By Craig Utley
[SQL Server Savvy]
The estimated number of row counts is incredibly important when Query Analyzer is choosing an execution plan.
By Brian Moran
[Editorial]
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 Michael Otey
[Inside SQL Server]
When you learn what information the sysindexes table has to offer, you'll be better able to work with your indexes and tables.
By Kalen Delaney
[T-SQL Black Belt]
Tiebreakers can make the difference between generally correct results and exactly the answer you need.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server-related products.
By Dawn Cyr
[SELECT TOP(X)]
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 Server-related downloads available from Microsoft.
By Michael Otey
[Preparing for SQL Server 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 server an integral component of application architecture.
By Matt Nunn
[Ask Microsoft]
Microsoft's Patrick Conlan explains how differential backups fit into a reader's restore scenario.
By Microsoft's SQL Server Development Team
Microsoft's Gert Drapers explains why a reader might be experiencing problems trying to debug T-SQL stored procedures.
By Microsoft's SQL Server Development Team
[Hands On]
A reader highlights his favorite products: Red Gate SQL Compare and SQL Data Compare.
By Dawn Cyr
|
