Here is a SQL Snippet that can be used to identify the SQL Server Agent Jobs that were running on a server at a particular point in time. This can come in very handy if you need to troubleshoot a performance issue after the fact and want to find out if there were any jobs [...]
Posts from ‘December, 2009’
SQL Snippet: SQL Server Wait Types
Here is a handy little SQL Snippet that will return information about those all important SQL Server Wait Types for your server. It uses the SQL Server Dynamic Management View (DMV) sys.dm_os_wait_stats in order to extrapolate the desired information. A column has also been added to provide details of the percentage of total wait time [...]
Something for the weekend: SQL Server Links (Xmas Edition)
I hope you’ve had a great week. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links Delimited String Tennis Anyone? – An interesting look at the performance implications of using XML to process delimited string data resulting from a derived column cast. Brad Schulz discusses. Those Four [...]
Something for the weekend – SQL Server Links 11/12/09
I hope you’ve had a great week. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links How Quest is Bringing DBAs Online – Discover how Quest are harnessing the expert knowledge of DBA’s globally in this post by Brent Ozar. Finding your Missing Keys – Well defined [...]
Something for the weekend: SQL Server Links 04/12/09
I hope you’ve had a great week. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links Comparison: Switching Tables vs. sp_rename – An interesting walk-through that evaluates the differences between using the sp_rename system stored procedure and the partitioning support SWITCH statement, courtesy of the The Database [...]
