http://www.sqlmag.com/authors/author/author/5777736/rss/5777736en-USFri, 25 May 2012 09:08:47 GMTFri, 25 May 2012 09:08:47 GMThttp://www.sqlmag.com/article/tsql3/quickly-find-your-worst-performing-t-sql-statementsHere’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.]]>Greg A. LarsenThu, 30 Oct 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/quickly-find-your-worst-performing-t-sql-statementshttp://www.sqlmag.com/article/permissions/generating-new-sql-server-loginsWhen 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. Here’s a way to automate permissions analysis-- and save your sanity.]]>Greg A. LarsenTue, 20 Jan 2004 00:00:00 GMThttp://www.sqlmag.com/article/permissions/generating-new-sql-server-loginshttp://www.sqlmag.com/article/tsql3/avoiding-the-red-zoneYou 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 yourself.]]>Greg A. LarsenTue, 26 Nov 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/avoiding-the-red-zone