Size Matters: 2 Products to Accelerate SQL Traffic

I talked previously about network pipelines and how to get the most out of a fat network in the post Network Packet Size: to Fiddle With or Not to Fiddle With. If you need to move large amounts of data and have a network infrastructure that can support a larger then normal packet size, you can get tremendous performance boosts by increasing packet size. The big performance boosts can only be realized if every part of the path between server
read more

Introduction to Integrity: Corruption in Allocation Pages

Welcome back for day two of this six part series Introduction to Integrity, sponsored by Idera. In this post, I want to dig into the first integrity issue, corruption in allocation pages. If you run the DBCC CHECKDB command and get errors, I isolate the most important errors (Level 16) and look at the page IDs in the errors. one of the first things I want to know is what type of page is corrupted. As I said in day
read more

Introduction to Integrity: Interpreting DBCC CHECKDB Results

I want to start a short 6 post series to serve as an introduction to integrity in SQL Server. Most posts that I write on this subject are for intermediate or advanced users, so this is a break from the normal for me. I think it is a good break though because I think there are very few introductory posts or articles on this subject. I was inspired to write this introductory series when I alpha-tested a new free tool
read more