New Book on Query Optimizer
Benjamin Nevarez (blog) has been working really hard on a book on the Query Optimizer. It just got finished in...
2010-10-26
597 reads
The Scary DBA
Another Must See Session
I can’t believe I missed this one in all the posts and recommendations I’ve been making about great sessions coming...
2010-10-25
440 reads
SQL Rally Voting
I received word over the weekend that my precon application had made it past committee and was now subject to...
2010-10-25
608 reads
Who You Learn From
Less than two weeks to go until the PASS Summit. I’m excited. I’ve managed to cram a ton of activities...
2010-10-25
676 reads
Kilt Day at the PASS Summit
Last year, with the infinite power at my disposal (read, zero), I declared Wednesday, Kilt Wednesday at the PASS Summit. It took...
2010-10-20
1,435 reads
Upcoming Speaking Engagements
I’ve got a couple of more sessions before the big two at the PASS Summit. Tomorrow night, October 20th, I’ll...
2010-10-19
713 reads
Powershell is Really Easy… If you know what you’re doing
Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...
2010-10-18
3,165 reads
Scary DBA Takes Over the World
Or, at least gets translated into Russian.
I realize I’m effectively a 10 year old, but, come on, HOW COOL IS...
2010-10-15
600 reads
Working the Door
You know those guys that work the door at clubs, seperating the wheat from the chaff, culling the herd, Choosing the Slain, sifting...
2010-10-14
713 reads
Speaking at SNESSUG
I’ll be presenting tonight at the Southern New England SQL Server Users Group (SNESSUG). The topic is “Using DMVs as...
2010-10-13
688 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers