By Greg A. Larsen, 10/30/2008
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 ...
By Greg A. Larsen, 01/20/2004
When you create a SQL Server login that has the same permissions as an existing login, the process of researching the old login's permissions and reassigning them can be tedious. ...
By Greg A. Larsen, 11/26/2002
You know you can predict future database storage needs by evaluating past usage, but how do you collect the historical statistics? Here's a 2-step process that lets you do it ...