sys.dm_tran_session_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188739.aspx
Returns correlation information for associated transactions and sessions.
This DMV helps...
2013-08-06
1,174 reads
I recently modified an SSRS report to display average run times for various SQL Agent jobs over the past 30,...
2013-08-09 (first published: 2013-08-05)
3,369 reads
I can’t believe it’s already August. I had planned to get to the lake more this year, spend more time...
2013-08-05
589 reads
It’s Monday, it’s time for weekly round-up #44. As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the...
2013-08-05
1,007 reads
I will be presenting a brand new session entitled “Best Practices to Deliver BI Solutions” tomorrow, August 6th, at 11am...
2013-08-05
836 reads
I found out last week that I will be presenting three sessions at the PASS Summit 2013 in Charlotte, NC....
2013-08-05
719 reads
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup?...
2013-08-05
1,446 reads
As many of you know, I created a facebook group named 'Living For SQL Server' couple of months back.
SQL Server...
2013-08-05
1,402 reads
Guidance is hard.
Seriously, you’d think it would be easy. You’d think you say things like, don’t shrink your database, most...
2013-08-05
2,338 reads
I recently needed to figure out how to embed Flash streaming video in a blog post. LiveWriter does Youtube ok...
2013-08-05
583 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hi, I have a trigger, that works fine elsewhere but is not working at...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers