Increasing deadlocks with NoLock
One of my personal pet issues is with inappropriate use of the NOLOCK hint (and read uncommitted) . Don't get me...
2010-04-23
761 reads
Script of the week
Every week I will scour the internet for useful SQL scripts and post my favorite on here.
This weeks comes from...
2010-04-23
396 reads
A DMV a Day – Day 23
The DMV for Day 23 is sys.dm_os_process_memory, which is described by BOL as:
Most memory allocations that are attributed to the...
2010-04-23
2,402 reads
Book Review: Knives at Dawn: America’s Quest for Culinary Glory at the Legendary Bocuse d’Or Competition
Another find from the new book shelf at the local library, Knives at Dawn: America’s Quest for Culinary Glory at...
2010-04-23
479 reads
Rules to Live By: Do the Hard Things First
I can’t say I stick to this one 100 percent of the time, but it’s definitely a deeply held belief....
2010-04-23
514 reads
Adding Administrator
I installed a new VM with SQL Server in it, along with Win 7 and Reporting Services. The plan was...
2010-04-23
801 reads
Book Review - Rework
I have been a fan of 37 Signals for some time, and I read their blog regularly. I think they...
2010-04-23
796 reads
Presenting at 2010 European PASS – Sort Of
I was so looking forward to the trip to Germany to speak at the European PASS Summit
on April 22nd. Two...
2010-04-23
424 reads
Results of Microsoft Certification Poll
In a recent poll at www.bradmcgehee.com, I asked website visitors if they had any Microsoft SQL Server certifications, and if...
2010-04-23
1,197 reads
PASS Summit Content Survey Results
The results of a survey conducted by the PASS organization have been posted (thanks to the Board for all their...
2010-04-22
635 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers