You Can’t Disable the CLR in SQL Server – MCM Prep
At least not completely. There are some functions in SQL Server that are built on the SQL CLR, and even...
2011-02-23
931 reads
Blog Posts
5 Things Every DBA Should NOT Do
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
2011-02-22
3,601 reads
A Plug for Wirefly
Wirefly is a website devoted to purchasing cell phones and plans. I found it when I was researching my Droid...
2011-02-22
854 reads
And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-22
1,576 reads
February 2010 S3OLV Recap
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you may know, I have moved from Vegas back to...
2011-02-22
2 reads
February 2010 S3OLV Recap
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you...
2011-02-22
446 reads
How To Write Better Queries WebCast
One character. That’s all it takes; just one character in a Transact-SQL query can make the difference between an index seek and an index scan. Transact-SQL is easy to learn....
2011-02-22
6 reads
How To Write Better Queries WebCast
One character. That’s all it takes; just one character in a Transact-SQL query can make the difference between an index seek...
2011-02-22
810 reads
Shameless Self-Promotion - Introduction to SQL Server [Book]
My introductory text to SQL Server, appropriately titled Introduction to SQL Server, is now in print and available for sale. The...
2011-02-22
953 reads
SQL Saturday 67 Chicago Pre-con
We have big news for SQL Saturday #67 Chicago. There is going be a pre-con on Friday 3/25 at the Hampton Inn right around the corner from the SQL...
2011-02-22
19 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers