SQL University–Recommendations for a Clustered Index
Welcome, SQL University Students to another extension class here at Miskatonic University, home to the Fighting Cephalopods (GO PODS!). Never...
2011-04-04
1,225 reads
The Scary DBA
SQL Saturday #67 Wrap-up
Just… Wow. What an event. What a great group of people. I’m just so lucky to be involved with fantastic...
2011-03-28
916 reads
Communication
It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become...
2011-03-21
2,613 reads
Where does slow performance come from?
I have my opinions and experience, and I’ve no doubt you have yours. Paul Randal (blog|twitter) has put up another...
2011-03-17
742 reads
ANSI Connection Settings
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
2011-03-14
1,706 reads
Execution Plan Stability
I’ve talked before about one of the primary things that the Query Optimizer team at Microsoft tries to avoid, regressions....
2011-03-07
782 reads
What Should PASS Be?
Andy Warren posted a question the other day (well, issued a challenge actually), “What Should PASS Be?” I’ll let you...
2011-02-22
712 reads
SQL Rally
I believe I’ve been far too quiet about this event.
In May, in Orlando Florida, there will be a two...
2011-02-17
648 reads
UN-SQL Friday #003–Vendor Love
The love that dare not speak it’s name… Yes, love for vendors. <shudder> Oh, I mean I love my new...
2011-02-15
587 reads
SQL Saturday #60, Cleveland Speaker Evals
I just received 35 speaker evaluations from SQL Saturday #60 in Cleveland. It was a great event (although I had...
2011-02-15
1,008 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