The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Go inside SQL Server 2005's rewritten DTS Import/Export Wizard, use information schema views to generate the stored procedures you use most, automate reindexing with a DBCC SHOWCONTIG utility, learn more about SQL Server 2005 Express Edition, and more!
By
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.
Microsoft's Patrick Conlan explains how to baseline file sizes to determine when a database is auto-growing.
By Michael Otey
Visual Studio 2005 Team System enters enterprise development space. Here are Team System's top five new enterprise-oriented features.
By Martin Wiseman
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 Itzik Ben-Gan
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 Brian Moran
Learn why you different SQL Server tools return widely varying statistics information about the same event.
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 Dan Sawyer
Piece by piece, then all together, test your application code by following this simple plan.
By Kalen Delaney
If mixed extents are causing contention in your database, these solutions can smooth out the ruffled pages and get your database purring along again.
You can automate the process of moving a table--not just its indexes--to a different filegroup using T-SQL. Here's how!
Michael Otey dispels some myths and gives readers the real scoop about SQL Server 2005's CLR integration.
By Derek Wilson
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 William Vaughn
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 Dawn Cyr
Check out the latest SQL Server-related new and improved products.
Microsoft's Richard Waymire says installing a hotfix from a remote desktop session works fine.
By Kirk Haselden
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.
advertisement