The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
SQL Server 2005 and Visual Studio 2005 are designed to work together. Learn how to take advantage of the teamwork of these new products, how to manage your SQL Server instances proactively, how CTEs can show you the way to transitive closure, and more!
By Kevin Kline
To minimize the time you spend handling database emergencies, use this system of performance baselining, benchmarking, and continuous monitoring.
By Brian Moran
You might expect a greater cost when selecting the entire view, but you might be surprised to see the actual difference.
You can force informational messages to come back immediately by using a RAISERROR statement and choosing the optional WITH NOWAIT keywords.
By Itzik Ben-Gan
Check your answer to May's logic puzzle and try the June puzzle, Measuring Time by Burning Ropes.
Flex your T-SQL muscles by learning to write a program that converts a value in a given base to a decimal value.
By Michael Otey
Five tips to maximize SQL Server performance in a VM.
By William Sheldon
SQL Server 2005 and Visual Studio 2005 are designed to work together. Learn how you can start developing applications now that will take advantage of the teamwork of these new products.
By Robert Zare
Even if you're not an expert, Analysis Services 2005 can help you provide automatic, intelligent solutions to common business problems. For example, the time intelligence enhancement lets you easily create time-based calculations.
By Matt Nunn
XML has become the standard format for transporting data. SQL Server 2005 offers native XML support--along with a new XML data type--that offers flexible data storage and gives you new ways to think about application and database design.
By
Microsoft's Gert Drapers gives a stored procedure that tells you whether SQL Server is using the domain account or the local account as its Windows user account.
MOM uses the same sql counters that Performance Monitor uses to gather information about your servers. Be sure to stop the MOM service on any server you need to stop SQL Server on.
By Dawn Cyr
Check out new and improved SQL Server-related products.
By Lubor Kollar
Sometimes, you want more than the destination; you need to see the road itself. CTEs can show you the way.
Find out whether it's better to use a fixed size or a percentage growth when setting the autogrow properties for a SQL Server data file.
Do you want your code done right, or do you want it done right now? It pays to be skeptical of extreme expectations.
You can double-click on the end of the column marker and the column will auto-expand to show the full data.
By Kalen Delaney
Reusing stored procedures can be a good idea, but first you need to learn how to keep track of compilation.
SQL Server has always had nifty undocumented functions that are tempting to use. Starting with SP4, we'll have to change our way of thinking and stop using undocumented and unsupported features in our production code.
advertisement