SQL Server Magazine January 2003
[Focus]
Some of these tips might sound unconventional, but they work! And who knows, one of them might just save your latest project.
By Tom Chester
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 Gregory B. Meyer , et al.
[Lab Reports]
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 Ron Talmage
[SQL Server Savvy]
Using a long, complex password might seem like more touble than it's worth, but it does make your system more secure.
By Brian Moran
Here's a way to use the flexible ORDER BY clause to sort data in a non-standard order.
By Brian Moran
Running SQL Server Profiler lets you quickly view the commands that Enterprise Manager generates, which you can use in your own applications.
By Brian Moran
[Editorial]
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 Michael Otey
[Reader to Reader]
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 easier.
By Readers
[SQL Seven]
Mike Otey shows you seven methods you can use to start SQL Server.
By Michael Otey
[Inside SQL Server]
How do you decide whether to store large data objects in the table or separately? Here are some pointers.
By Kalen Delaney
[Mastering Analysis]
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 Russ Whitney
[Solutions by Design]
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.
By Michelle A. Poolet
[T-SQL Black Belt]
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 Itzik Ben-Gan
[Answers from Microsoft]
Wrapping your stored procedure call with state-change logic will let you determine the execution status of the procedure.
By Microsoft's SQL Server Development Team
Microsoft's SQL Server development team shares 3 approaches for importing an XML file into SQL Server 2000.
By Microsoft's SQL Server Development Team
Generate scripts to recreate stored procedures and triggers every time you set up replication.
By Microsoft's SQL Server Development Team
[Exploring XML]
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 eliminating duplicate data when you express many-to-many relationships.
By Rich Rollman
[Letters]
Readers write in about how to grant developers Restore permissions, the benefits of filegroups, and more.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
