SQL Server Magazine June 2003
[Focus]
Optimum portability is one of the most important goals in creating a Data Transformation Services package that can execute properly on virtually any server.
By Shane Dovers
[Features]
Now that you’re comfortable with many-to-many (M:N) relationships, don’t get complacent. Your database performance can often benefit from taking a relationship in a new direction--for example, by implementing the underused supertype-subtype model.
By Jeffrey Bane
[SQL Server Savvy]
Looking for an installed SQL Server's CD key from the Windows registry? Here are some ways to find it...
By Brian Moran
Certain Intel processors have a new feature called Hyper-Threading. The feature essentially makes one processor look like two to the OS.
By Brian Moran
If you use the affinity mask option on a machine that uses Hyper-Threading technology, you might get unanticipated behavior.
By Brian Moran
Query Analyzer is packed with features that many people haven't experimented with. Here's an obscure capability that lets you set a variety of configuration options, save them to a configuration file, then start Query Analyzer using that file.
By Brian Moran
Looking for an alternative to Microsoft Outlook when sending mail from SQL Server? Check out XPSMTP.
By Brian Moran
[Editorial]
You might not need the new functionality a service pack provides, but prompt installation of service packs could be the very thing that beats virus writers to the punch.
By Michael Otey
[SQL Seven]
Knowing what not to do is important because violating these precautions can ruin your ADO.NET application's performance or compromise the security of your SQL Server system.
By Michael Otey
[Inside SQL Server]
Tips about testing and choosing the right recovery model for your system.
By Kalen Delaney
[Mastering Analysis]
When you're choosing between relational reporting and OLAP for data analysis, remember that the two tools are different. Relational reporting can provide solid data for decision makers, but OLAP addresses the human side of the equation.
By Russ Whitney
[T-SQL Black Belt]
You can use Set Theory to identify groups of items that have a certain relationship to other items.
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft provides answers about the capabilities of SQL Server 2000's full-text search component.
By Microsoft's SQL Server Development Team
SQL-DMO gives you a way to list jobs running on SQL Server and obtain their scripts.
By Microsoft's SQL Server Development Team
Use SQL Server Profiler to determine which indexes you need to keep on your tables.
By Microsoft's SQL Server Development Team
[Exploring XML]
Edge tables can help you find data that's hidden in XML open content.
By Rich Rollman
[Letters]
Readers write in about quickly installing service packs, frustrations over authentication modes, using 32-bit tools to migrate to 64-bit SQL Server, and much more!
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
