By Michael Otey, 12/23/2002
Microsoft offers a lot of functionality as free downloads, including the latest SQL Server 2000 XML functionality. If you ignore these updates, you're leaving money on the table.
By Brian Moran, 12/23/2002
Here's how Morris Lewis determined that his 14-character SQL Server password could contain 41 possible characters.
By Tom Chester, 12/23/2002
Some of these tips might sound unconventional, but they work! And who knows, one of them might just save your latest project.
By Rich Rollman, 12/23/2002
XML supports uniquely identifying entities and referencing those entities from other locations within an XML document. Find out how to reduce the size of an XML result by ...
By Brian Moran, 12/23/2002
Here's a way to use the flexible ORDER BY clause to sort data in a non-standard order.
By Russ Whitney, 12/23/2002
When you want to secure selected data, you have options other than Analysis Services. Here's a customized, flexible way to manage dimension-level security.
By Microsoft's SQL Server Development Team, 12/23/2002
Microsoft's SQL Server development team shares 3 approaches for importing an XML file into SQL Server 2000.
By Readers, 12/23/2002
If you've inherited someone else's database, you might be frustrated as you try to clean the data and create foreign keys. Here are some techniques that can make the process ...
By Michael Otey, 12/23/2002
Mike Otey shows you seven methods you can use to start SQL Server.
By Microsoft's SQL Server Development Team, 12/23/2002
Generate scripts to recreate stored procedures and triggers every time you set up replication.
By Russ Whitney, 12/23/2002
If your business uses analysis tools for monitoring purposes, you might want to use a control chart to track changes over time. Test yourself by writing a query that returns data ...
By Brian Moran, 12/23/2002
Using a long, complex password might seem like more touble than it's worth, but it does make your system more secure.
By Carolyn Mader, 12/23/2002
Check out the latest SQL Server-related new and improved products.
By Kalen Delaney, 12/23/2002
How do you decide whether to store large data objects in the table or separately? Here are some pointers.
By Ron Talmage, 12/23/2002
Lumigent Technologies' Log Explorer lets you recover transaction log data, often while the system is running—-and you can select exactly the transactions you want to restore.
By Various Authors, 12/23/2002
Readers write in about how to grant developers Restore permissions, the benefits of filegroups, and more.
By Christine Mato, 12/23/2002
A geological data-analysis project shows that whatever the size of your data set, SQL Server 2000's data mining capabilities can save you time and effort.
By Itzik Ben-Gan, 12/23/2002
When you need to perform calculations that don’t necessarily involve accessing data that's stored in tables, take the logical path to a solution.
By Microsoft's SQL Server Development Team, 12/23/2002
Wrapping your stored procedure call with state-change logic will let you determine the execution status of the procedure.
By Brian Moran, 12/23/2002
Running SQL Server Profiler lets you quickly view the commands that Enterprise Manager generates, which you can use in your own applications.
By Russ Whitney, 12/23/2002
To even out the "noise" in a trend line, you can use a rolling average. Here's a way to write an MDX query that displays the FoodMart 2000 Sales cube's monthly Store Sales values ...
By Michelle A. Poolet, 12/23/2002
Indexing can be a double-edged sword—you can improve performance or hinder it. Consider these nine important points as you develop your indexing strategies.