SQL Server Magazine October 2004
[Focus]
Microsoft has completely rewritten SQL Server 2005 DTS, making the DTS Import/Export Wizard an even more effective tool for quickly building packages for moving data. Follow along with this example to learn about the wizard’s new features.
By Kirk Haselden
[Features]
Stored procedures can save you time and simplify common tasks such as table updates. But you can make your life even easier by using SQL Server information schema views to automatically generate the procedures you use the most.
By Alex Glauberzon , et al.
Reindexing your database tables to eliminate fragmentation is important for maintaining your databases’ health, but it can be time-consuming. Here’s a utility that uses DBCC SHOWCONTIG to automate this essential task.
By Derek Wilson
Piece by piece, then all together, test your application code by following this simple plan.
By Dan Sawyer
[Departments]
Microsoft has introduced SQL Server 2005 Express Edition to replace Microsoft SQL Server Desktop Engine (MSDE). Find out what’s changed and what’s remained the same!
By William Vaughn
[SQL Server Savvy]
You can get a wrong answer if you're using Query Analyzer to analyze I/O for a query that includes a user-defined function (UDF). And wrong answers lead to poor query-tuning decisions.
By Brian Moran
Learn why you different SQL Server tools return widely varying statistics information about the same event.
By Brian Moran
You can automate the process of moving a table--not just its indexes--to a different filegroup using T-SQL. Here's how!
By Brian Moran
[Editorial]
Michael Otey dispels some myths and gives readers the real scoop about SQL Server 2005's CLR integration.
By Michael Otey
[Inside SQL Server]
If mixed extents are causing contention in your database, these solutions can smooth out the ruffled pages and get your database purring along again.
By Kalen Delaney
[T-SQL Black Belt]
If you don't know which clause to specify a logical expression in, you're not alone. Learn why logical query-processing order matters.
By Itzik Ben-Gan
[New Products]
Check out the latest SQL Server-related new and improved products.
By Dawn Cyr
[SELECT TOP(X)]
Visual Studio 2005 Team System enters enterprise development space. Here are Team System's top five new enterprise-oriented features.
By Michael Otey
[Ask Microsoft]
Microsoft's Richard Waymire says installing a hotfix from a remote desktop session works fine.
By Microsoft's SQL Server Development Team
Microsoft's Richard Waymire says your best bet for changing the size of a column in a large table is to use the ALTER TABLE command.
By Microsoft's SQL Server Development Team
Microsoft's Patrick Conlan explains how to baseline file sizes to determine when a database is auto-growing.
By Microsoft's SQL Server Development Team
|
