By Kalen Delaney, 08/21/2002
Don't let your transactions get locked out. Use the best indexes for multiuser queries to help SQL Server avoid blocking problems.
By Brian Moran, 08/21/2002
With the release of SQL Server 2000 Service Pack 1, the behavior of SQL:StmtCompleted changed. Learn what to expect when you try to capture events within a procedure.
By Kimberly L. Tripp, 08/21/2002
Frequent backups of msdb will ensure that you have the information you need to restore your database after a disaster.
By Kimberly L. Tripp, 08/21/2002
Decisions about where to place data within filegroups can sink or save your restore, so plan carefully.
By Microsoft's SQL Server Development Team, 08/21/2002
What’s your algebra quotient? Microsoft’s SQL Server development team explains how relational algebra comes into play when you update specified columns from a second table.
By Itzik Ben-Gan, 08/21/2002
This set-based T-SQL query might not solve all your financial problems, but it can help you compute balances and track index growth.
By Carolyn Mader, 08/21/2002
Check out the latest SQL Server-related new and improved products.
By Michael Otey, 08/21/2002
A shake-up in the database market has yielded a new database champ in terms of new license revenue: IBM. But on the fast-growing Windows platform, SQL Server claims the number-one ...
By Michelle A. Poolet, 08/21/2002
Use domains in lieu of regular data types when you want to maintain consistency of data types throughout a database.
By Microsoft's SQL Server Development Team, 08/21/2002
Microsoft’s SQL Server development team tells a reader how to propagate primary and foreign keys in both SQL Server 2000 and 7.0.
By Michelle A. Poolet, 08/21/2002
Learn how to take advantage of pre-existing forms of identification such as Social Security numbers, define and use domains, and pick an appropriate primary key in this ...
By Russ Whitney, 08/21/2002
Challenge yourself to write an MDX query that displays each product category and its average month-to-month store sales growth.
By Kimberly L. Tripp, 08/21/2002
Using the file and filegroup backup strategy can help you quickly and easily recover from isolated failures.
By Brian Moran, 08/21/2002
Got some free time? Take a look at the information schema views in the master database to learn undocumented tips and cool T-SQL tricks.
By Brian Moran, 08/21/2002
Learn what you can do to recover a database when you don't have the log file.
By Kimberly L. Tripp, 08/21/2002
Don't wait until a disaster hits your company. Make a solid backup plan and test it now to make sure that your data will survive a crash.
By Rich Rollman, 08/21/2002
If you use SQLXML in your development environment and need to transfer projects between computers, here’s a handy script that quickly duplicates your virtual directories.
By Russ Whitney, 08/21/2002
Learn how to write an MDX query to determine whether the top 10 FoodMart customers are consolidating.
By Various Authors, 08/21/2002
Readers write in about speedier solutions for missing number queries and more Query Analyzer shortcuts.
By Russ Whitney, 08/21/2002
Developers who are using Visual Studio .NET to develop production applications are discovering .NET and COM interoperability isn’t simple. Here’s how to avoid a couple of common ...
By Michael Otey, 08/21/2002
Many free tools are available on the Web to help DBAs and database developers. Here are my seven favorite free SQL Server utilities.
By Kalen Delaney, 08/21/2002
Before you move your database to a new server, be sure you know how to solve one of the most common restore problems: mismatched usernames and logins.
By Brian Moran, 08/21/2002
Why does SQL Server Profiler seem to miss some events when you're processing a heavy load?
By Brian Moran, 08/21/2002
Solutions that assume positioning of particular rows within a result set aren't easy for T-SQL, but learning how to handle such solutions is important.