SQL Server Magazine invites you to participate in a live chat with SQL Server Magazine authors Itzik Ben-Gan, Andrew Kelly, and Michael Otey on Friday, November 7th, at 7:00pm EST/6:00pm CST.
Need to parse server-side trace information so that you can aggregate the data to find your worst-performing and most-called queries? The user-defined SQL_Signature function should do the trick.
Need to change the word "Bikes" to "Trucks" without modifying "SuperBikes" to "SuperTrucks" or perform another word-replacement operation? This user-defined function (UDF) will do the trick.
Here's a stored procedure that lets you quickly and easily produce customized reports showing the poorest-performing T-SQL statements that were run against your SQL Server 2008 and SQL Server 2005 databases.
MaintenanceSolution.sql lets you easily back up databases, check their integrity, and optimize indexes. This script is set up so that you can perform each task independently on the databases you specify.
The SpaceUsedAnalyzer stored procedure provides detailed information on how much space is being used by tables and their indexes so that you can manage disk space more efficiently.
A recent project has forced me (which is a good thing) to learn both the internals of SSAS 2005 as well as various performance tuning techniques to get maximum performance out of the OLAP server.
