March, 2007

For part two of my short series on data file shrinking, I want to look at how elements of your schemas can cause shrink to take much longer to run. In SQL Server 2005, three things in your schema will drastically affect the run-time of data file shrink...

Frustration at Microsoft's seemingly haphazard organization of whitepapers finally won and Kimberly spent a bunch of time between sessions at SQL Server Magazine Connections putting together a great page listing a *ton* of whitepapers - see her post here...

This week's topic is data file shrinking. I've seen lots of mis-information in the last few weeks and I've had a bunch of questions about it. First up is auto-shrink. In my opinion, this feature causes way more problems than it solves (in fact, I can...

In previous posts I've explained how to use a hex editor to corrupt a database for testing and exploration. MVP Tony Rogerson has gone one step further by using bulk load to import a database into SQL Server and then create various corruptions using regular...

A great new whitepaper has just been published on TechNet - Online Indexing Operation in SQL Server 2005 . It gives a detailed explanation of the online index build process plus guidelines and best practices for implementing online indexing in production...

I was sent a question today that seems like it could be something that many people get confused about – why can’t an NTEXT column be specified in the INCLUDE list of a CREATE INDEX statement in SQL 2005? (In one of my internals posts from last year...

This is very cool - an undocumented option to UPDATE STATISTICS that allows you to fool the server into thinking a table has more rows or pages than it actually has - very useful for testing. See this blog post on the old Query Optimizer team blog. Thanks...

My recent post on SLAs prompted some interest and comments from readers so this is a follow-up to that post. What most people wanted was a list of some SLAs applicable to SQL Server - easier-said-than-done because a lot of SLAs depend on the application...

While in the UK last week, Kimberly and I were interviewed by David McMahon of the Next Generation User Group . Topics covered include the crappy weather, why we took 5 years to ship, 3 features I wish we'd done in Yukon, and our favorite features in...

Many apologies to those who were hoping to see my presentation on corruption detection and recovery at SQL Server Open World in Denmark last week. An emergency came up after the class Kimberly and I taught in England and we ended up flying a *lot* further...

Funny how a bunch of people all seem to have the same problem at the same time. Maybe it’s just that people don’t want to talk about corruption until someone else does – it’s like a dark secret that once let out of the bag – everyone talks. The common...

(In the UK now hanging out with Kimberly and Tony Rogerson before teaching a Masterclass tomorrow in Reading. Then it's off to Copenhagen for SQL Server Open World , with a little R&R in London beforehand and Copenhagen afterwards, before we fly back...

A bit of a diversion from the normal SQL Server posts. Recently I’ve found a very useful feature in Visual Studio that can help to analyze large amounts of source code – the Visual Studio Code Model objects Depending on the language of the code base...