By Itzik Ben-Gan, 06/22/2005
In computer systems, you sometimes need to save space by using non-decimal values. But how do you convert those numbers back to decimals when you need them? Find out in this ...
By Microsoft's SQL Server Development Team, 06/22/2005
Microsoft's Patrick Conlan explains 3 methods for rebuilding a heap table index.
By Carl Rabeler, 06/22/2005
Learn how to deploy a SQL Server 2000 Analysis Services database from your development environment to your test, staging, QA, or production environment while keeping your ...
By Dawn Cyr, 06/22/2005
Check out new and improved SQL Server–related products.
By Carl Rabeler, 06/22/2005
Learn how to determine what hardware and software resources your SQL Server 2000 Analysis Services instance requires.
By Microsoft's SQL Server Development Team, 06/22/2005
Microsoft's Thierry D'hers describes the steps for getting a string to show up in analysis cubes.
By Itzik Ben-Gan, 06/22/2005
Discover the secret to the burning rope trick, then test your wits by calculating an arithmetic maximum.
By Matt Nunn, 06/22/2005
For Microsoft's SQL Server development team, enabling Web services for SQL Server 2005 was important enough to warrant native support for the feature. Learn how you can use Web ...
By Carl Rabeler, 06/22/2005
A typical approach to high availability in Analysis Services 2000 is to use Windows NLB to distribute user queries across multiple Analysis Services instances on disparate ...
By Dawn Cyr, 06/22/2005
A reader highlights his favorite product: SQLCentric.
By Carl Rabeler, 06/22/2005
Find out if you can delegate permission to a Window user or group to process an Analysis Services cube or dimension without also granting permissions to view the data in the cobe ...
By Kevin Kline, 06/22/2005
Many of your system's performance problems result from simple ignorance of good hardware design. Here are some tips you can use to maximize SQL Server performance before you ever ...
By Michelle A. Poolet, 06/22/2005
You can improve performance by retrofitting a database with indexes and more powerful hardware, but you can never completely compensate for a bad data model. Performance-tuning ...
By Kalen Delaney, 06/22/2005
In many cases, reusing a precompiled plan benefits your stored procedure's performance--but not always. To know when reusing a plan might not be appropriate, find out how the ...
By Michael Otey, 06/22/2005
Michael Otey discusses SQL Server's high availability options and shows you which types of failures each solution handles best.
By Carl Rabeler, 06/22/2005
ADO MD.NET and XMLA clients communicate differently with a SQL Server 2000 Analysis Services instance then with a SQL Server 2005 Analysis Services instance.
By Carl Rabeler, 06/22/2005
How can you monitor the queries your business users submit?
By Dan Sawyer, 06/22/2005
Wouldn't it be great to cut the time it takes to unit test T-SQL stored procedures? Well, now you can! You can automate your testing by using nothing more than Query Analyzer and ...
By Michael Otey, 06/22/2005
With SQL Server 2005 Workgroup edition, Microsoft takes on the low-end database market.
By Kevin Kline, 06/22/2005
Save this handy shopping list for your trip to the hardware store.
By Peter Blackburn, 06/22/2005
Here's a handy workaround to help you avoid errors that cause Microsoft IIS to lock up when when you're working with SQL Server 2000 Reporting Services on Windows XP.
By Microsoft's SQL Server Development Team, 06/22/2005
Microsoft's Patrick Conlan gives tips for making sure you correctly back up your transaction log.
By Michelle A. Poolet, 06/22/2005
If you can afford it, RAID is the easiest and best way to implement fault tolerance.