Prevent SQL Server Blocking using Lock_Timeout
In this tip we look at a way to minimize the length of blocking using SQL Server lock timeout.
2020-01-24
Concurrency
The Many Levels Of Concurrency
When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s a heck of a lot more to it.
2018-03-06
3,361 reads
2013-08-06
1,995 reads
Free eBook: Understanding SQL Server Concurrency
When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.
2020-02-05 (first published: 2013-07-17)
106,148 reads
Blogs
Renewed as a Friend of Red Gate
By Brian Kelley
I recently received the news that I’ve been renewed as a Friend of Red...
Redgate Software Needs You!
I’ve been very blessed to be able to work for Redgate Software. We’ve done...
Extended Events: Database Auditing
Extended Events can do things that simply are not possible with Profiler and another...
Forums
SSMA 8.6 Unable to find functions in extended stored procedures
I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...
Running generic query for table information
Hi, I want to run the below query to get information about the tables...
Instance level trigger to store login information (who created what)
Hello SSC, I am looking for a simplified way to track which user created...
Ask SSC