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 running [...]
Posts from ‘December, 2009’
SQL Snippet: What SQL Server Agent Jobs were running at that time?
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 Little Words – A [...]
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 relationships are a fundamental [...]
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 Whisperer (Michael J [...]