Can You Dig It? – StmtCond Element
She can dig it!
D Sharon PruittA couple posts ago in the plan cache series I discussed the children for the...
2010-12-22
912 reads
StrateSQL
Can You Dig It? – StmtUseDb Element
She can dig it!
D Sharon PruittThe last post in the plan cache series discussed the children for the Statements element. ...
2010-12-21
682 reads
MCM Live Blog – Week December 20
Watching videos?! Su-ure!
Time for the second week of blogging about the things that I’m doing to study for the MCM...
2010-12-21
583 reads
Viewing RING_BUFFER_OOM Errors
Onion Ring Buffer?
A client asked a co-worker to take a look at a query for reviewing RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. ...
2010-12-21
828 reads
Can You Dig It? – SHOWPLAN XML Structure
She can dig it!
D Sharon PruittIn the last couple plan cache posts, I talked about a couple items that are...
2010-12-20
889 reads
SSWUG Free SSIS Expo
Stinking Feet?
Want to learn some stuff about SSIS? Want to do it from the couch and not have to get...
2010-12-20
574 reads
Can You Dig It? – Missing Indexes
She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...
2010-12-20
2,013 reads
SQL Server 2005 Service Pack 4 RTM
Service Pack 4
Just in time for Christmas, SQL Server 2005 Service Pack 4 has RTM’d. If you are using SQL...
2010-12-18
843 reads
SQLRally Session Submissions
Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of...
2010-12-16
541 reads
Generating RING_BUFFER_OOM Errors
Onion Ring Buffer?
Ever think to yourself, “hmm, I wish I could generate me some RING BUFFER_OOM errors”? This request happened...
2010-12-15
743 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
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers