Tag: NOLOCK

By Posted on Posted in Uncategorized No Comments Tagged with , ,

Join us for a 30-minute livestream session, next Wednesday July 31, 2024 at 10:30 am, where we’ll explore how Stedman Solutions can safeguard your SQL Server environment during your DBA’s absence. Learn about our comprehensive managed services that provide continuous monitoring, immediate issue resolution, and expert support, ensuring your SQL Server remains optimized and secure. Discover how our team of …

Ensuring SQL Server Stability: How Stedman Solutions Can Assist When Your DBA is on Vacation Read more »

By Posted on Posted in Performance, Podcast No Comments Tagged with ,

There is a great deal of confusion about the WITH NOLOCK query hint. The following is a transcription of a conversation that I had on the SQL Data Partners Podcast #57 about the WITH NOLOCK hint, and some of the misconceptions about it. WITH NOLOCK Hint Carlos: So the next on is the WITH NOLOCK hint and I think this …

The Use of WITH NOLOCK Query Hint Read more »

By Posted on Posted in Database Health, Technical Debt No Comments Tagged with , , , , ,

As Beta 7 of the Database Health Reports approaches is just three weeks, the big new feature that has been added is the SQL Technical Debt Analysis. The SQL Technical Debt Analysis a great check for those areas that are known problems when working on SQL Server. But what if I like the GOTO statement? All of the Database Health …

SQL Server Technical Debt Read more »