T-SQL

External Article

Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask

  • Article

Every time you access a relational database to make a query, you have an important decision to make: What is the appropriate isolation level for your query? If you get this wrong, the consequences can be serious. Deadlocks, Dirty reads, Non-repeatable reads, or poor performance. We're in luck, because Robert Sheldon once more answers those questions that are awkward to ask in public.

2014-12-18

12,150 reads

Blogs

Monday Monitor Tips: ServiceNow Integration

By

Earlier this year I visited a customer that was using the Redgate Monitor webhook...

Inspecting TSQL Abstract Syntax Trees

By

TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....

Becoming a creator, my website experience

By

Over the past few months, I have debated starting a new blog to discuss...

Read the latest Blogs

Forums

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

By Site Owners

Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...

Cannot get KB959420

By fabio@fullin.com.ar

Hi, we lost our sever sql2000 To restore database to a new one we...

Do You Really Need HA?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Really Need HA?

Visit the forum

Question of the Day

The New Database CheckDB

I run this code:

create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned?

See possible answers