SQL Server Magazine April 2002
[Focus]
ADO.NET is very different from the ADO data-access model. But you don't need to give up your existing applications when you switch to .NET. Learn how you can use your ADO code from within ADO.NET to extend the life of your applications.
By Dino Esposito
Knowing the progression of database-technology advances--from ODBC to ADO.NET--can help you better understand the rationale behind the design of your current technology, how to most effectively use it, and what your other options are.
By Wei-Meng Lee
[Features]
With multiserver task capability, you can set up a backup or database-maintenance task on one server and run it on multiple servers. Here's how to set up multiserver tasks and reap the rewards of convenience and centralized reports.
By Michael D. Reilly
[SQL Server Savvy]
When you run certain queries in SQL Server 2000 and 7.0, you might get different results than you expect.
By Brian Moran
Should I use DISTINCT or GROUP BY to eliminate duplicates in a result set?
By Brian Moran
What performance differences exist between inline and multistatement table-valued UDFs?
By Brian Moran
Do I need to add data-file defragmentation to my regular database maintenance, or does SQL Server avoid file fragmentation by reserving contiguous data space?
By Brian Moran
Here's an undocumented way to generate a list of columns in a large table.
By Brian Moran
[Editorial]
Although scaling big is important for many companies, scaling small can open the door to new enterprise opportunities. And with SQL Server CE, SQL Server scales to small databases in a big way.
By Michael Otey
[SQL Seven]
Learn some of the most important new keywords in the SQL Server .NET Data Provider's SqlConnection object.
By Michael Otey
[Inside SQL Server]
By organizing your data, hashing helps SQL Server process JOIN queries more efficiently without resorting to sorting.
By Kalen Delaney
[Mastering Analysis]
Learn how to provide analysts with the summarized information they need while hiding confidential details.
By Russ Whitney , et al.
[T-SQL Black Belt]
Who says T-SQL can't be fun? Working through this example script is guaranteed to bring a smile.
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft’s SQL Server development team explains why recent data is missing in the error log.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team tells a reader how to evaluate the value for the Page Splits/sec counter (high or low) in the Windows Performance Monitor.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team describes two ways to perform a unified search.
By Microsoft's SQL Server Development Team
[Exploring XML]
What are the best technologies for obtaining XML query results and updating SQL Server? Rich Rollman describes nine cutting-edge alternatives.
By Rich Rollman
[Letters]
Readers write in about primary keys and Microsoft's product documentation.
By Various Authors
[New Products]
Check out these new and improved products for database administration, development, business intelligence, and more.
By Carolyn Mader , et al.
|
