By Russ Whitney, 10/23/2002
Challenge yourself with this new puzzle, which asks you to determine a set of like items according to their distance from the bottom of the dimension.
By Kalen Delaney, 10/23/2002
Trace flags can be helpful for troubleshooting, but make sure you know what they do before you use them.
By Rich Rollman, 10/23/2002
To organize your database, you usually normalize the data to maintain optimum performance. But XML documents aren’t normalized, they nest their elements instead. So how do you ...
By Various Authors, 10/23/2002
Readers ask about an easier way to restore to a new server, how to delete all the rows from two related tables, how to create two time dimensions in a cube, and more.
By Microsoft's SQL Server Development Team, 10/23/2002
Microsoft’s SQL Server development team describes two techniques for updating sales data from one business location to another.
By Russ Whitney, 10/23/2002
Learn about three of Analysis Services' programmatic interfaces that you can use from your analysis application.
By Microsoft's SQL Server Development Team, 10/23/2002
Microsoft’s SQL Server development team not only describes how to call one stored procedure from within another in SQL Server 2000 and 7.0 but also presents caveats for ...
By Michelle A. Poolet, 10/23/2002
In the early stages of a new career, everyone makes mistakes that prove to be costly lessons. You can shorten your adjustment period by avoiding these hidden traps.
By Microsoft's SQL Server Development Team, 10/23/2002
Creating a separate log-reader agent on a database during transactional replication is a no-no, but you can create a new Distribution Agent when you add a new publication.
By Microsoft's SQL Server Development Team, 10/23/2002
When you want to store text shorter than the 8000-character varchar data type limit, you have three options—depending on your SQL Server release. Microsoft’s SQL Server ...
By Burton Roberts, 10/23/2002
Trying to keep up with changing data in your reports? You can provide variable-width crosstab reports by using dynamic SQL. But ADO.NET's relational features provide a more ...
By Microsoft's SQL Server Development Team, 10/23/2002
Microsoft’s SQL Server development team unlocks the key to character limitation when a reader uses a system stored procedure in a script.
By Michael Otey, 10/23/2002
Web Matrix is a great way to get your feet wet using ASP.NET without shelling out the money for a full copy of Visual Studio .NET. Here are the seven best things about Web Matrix.
By Michael Otey, 10/23/2002
Already, 64-bit SQL Server running on the Itanium 2 processor with Windows 2000 Advanced Server Limited Edition 1.2 has set a new SAP SD-user benchmark score.
By William Vaughn, 10/23/2002
When you write a query, sometimes you want only a yes or no answer. In these cases, instead of using SELECT to return a rowset, you can execute an ADO.NET action command to get ...
By Itzik Ben-Gan, 10/23/2002
It's a kind of magic: Create four set-based solutions to a common SQL problem.
By Brian Moran, 10/23/2002
Reading procedure code can provide valuable tips about how SQL Server works.
By Itzik Ben-Gan, 10/23/2002
For accuracy and performance, you need to make sure that all IP addresses in your tables are valid. Here's how to write a CHECK constraint that validates character strings ...
By Microsoft's SQL Server Development Team, 10/23/2002
If two rows contain the same number, certain queries might fail. Locking in a row’s incremental counter value might be the solution.
By Microsoft's SQL Server Development Team, 10/23/2002
Here are two ways to create and load update files to a remote site.
By Carolyn Mader, 10/23/2002
Check out the latest SQL Server-related new and improved products.
By Russ Whitney, 10/23/2002
Learn how to use the FoodMart 2000 Sales cube to display 1997 quarterly Unit Sales for customers named Netz.
By Russ Whitney, 10/23/2002
From analysis to final decision, every business process requires collaboration among team members. Here’s how you can use DSO to add collaboration features to your next analytic ...
By Brian Moran, 10/23/2002
Use the HotFix and Security Bulletin Service to make sure hackers don't learn about the next SQL Server security hole before you do.
By Microsoft's SQL Server Development Team, 10/23/2002
You can effectively streamline your INSERT operation by adding records to two tables at the same time, but there’s one pitfall you should watch out for.