Why is CheckDB rolling back transactions?

• by Gail Shaw

• SQL In The Wild

I saw this one on a forum recently and it’s a fun question to look into.
When running CheckDB on an...

2009-09-24

591 reads

Estimated rows, actual rows and execution count

• by Gail Shaw

• SQL In The Wild

It’s often said that a major discrepancy between estimated and actual row counts in a query’s execution plan is a...

2009-09-22

1,799 reads

Multiple Execution Paths

• by Gail Shaw

• SQL In The Wild

It’s not uncommon to find stored procedures that have multiple IF statements controlling the flow of execution within the procedure....

2009-09-15

710 reads

Thoughts on the 24 hours of PASS

• by Gail Shaw

• SQL In The Wild

From all indications, the first 24 hours of PASS was a resounding success. Hundreds of attendees for each session, minimal...

2009-09-03

356 reads

Backing up to NUL vs Backup with Truncate only

• by Gail Shaw

• SQL In The Wild

Or “It’s 10pm, do you know where your log records are?”
Something that I’ve started to see recently is the idea...

2009-08-31

2,082 reads

Corruption in sys.dependencies

• by Gail Shaw

• SQL In The Wild

The second type of corruption I want to look at is that of missing references in sys.sql_dependencies. This typically appears...

2009-08-26

401 reads

Stats blob corruptions

• by Gail Shaw

• SQL In The Wild

There have been a couple odd types of corruption that I’ve been seeing on the forums. I want to take...

2009-08-24

343 reads

Performance Implications of Database Snapshots

• by Gail Shaw

• SQLServerCentral.com

• Performance Tuning

Books online mentions that performance may be reduced when using database snapshots. I decided to investigate how severe that reduction could be.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.6 (30)

Log in or register to rate

2008-09-23

7,163 reads

• Discuss