SQL Server Magazine June 2005
[Focus]
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 William Sheldon
[Features]
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 Mosha Pasumansky , et al.
To minimize the time you spend handling database emergencies, use this system of performance baselining, benchmarking, and continuous monitoring.
By Kevin Kline
Sometimes, you want more than the destination; you need to see the road itself. CTEs can show you the way.
By Itzik Ben-Gan , et al.
[SQL Server Savvy]
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 Brian Moran
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.
By Brian Moran
You might expect a greater cost when selecting the entire view, but you might be surprised to see the actual difference.
By Brian Moran
You can double-click on the end of the column marker and the column will auto-expand to show the full data.
By Brian Moran
You can force informational messages to come back immediately by using a RAISERROR statement and choosing the optional WITH NOWAIT keywords.
By Brian Moran
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.
By Brian Moran
[Editorial]
Do you want your code done right, or do you want it done right now? It pays to be skeptical of extreme expectations.
By Michael Otey
[Inside SQL Server]
Reusing stored procedures can be a good idea, but first you need to learn how to keep track of compilation.
By Kalen Delaney
[T-SQL Black Belt]
Flex your T-SQL muscles by learning to write a program that converts a value in a given base to a decimal value.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server-related products.
By Dawn Cyr
[SELECT TOP(X)]
Five tips to maximize SQL Server performance in a VM.
By Michael Otey
[Preparing for SQL Server 2005]
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 Matt Nunn
[Ask Microsoft]
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.
By Microsoft's SQL Server Development Team
|
