A confusing question, with a confusing explanation!

I read it several times and couldn't work out if it was a true test or some kind of trick 😉

So I didn't learn...

Definitely should be "it depends"... I think the question is trying to show what happens when you add a clustered index to a heap and how the data is likely...

Great article - I've always worried about Fill Factor as it does seem to be an area shrouded in confusion and contrasting views.

For example, if you're always adding to the...

Thanks for a good question - I hadn't realised there would be a scope problem in this instance so I learnt something new today 🙂

I think as long as people learn does it matter if they ran the code? 🙂

This WHILE was very convoluted so I ran the code to see if I could...

It would have been much clearer if the instructions to run the insert twice were in the question not hidden in the comments - I would probably still have got...

What interested me was how long the random names are in sysobjects - obviously Microsoft planning for LOTS of temporary objects being created!

A good introductory article, but I think people need to be careful when looking into using Indexed Views.

I recently added a view to a 3rd party application and thought it...

Hi Steve,

In the Major Builds box at the top the KB Article given for SP2 is actually the KB article for SP1 🙂

By the way, this is probably one of...

A very good explantation - thanks. I got it right with a bit of guesswork, but hadn't realised that the operator precedence was the key.

I would agree with earlier comments that if your table is indexed properly dates shouldn't be an issue. Our main order table has many tens of millions of rows and...

Spooky - I have also decided to use a horrible pink for production!

Drat - tricked again 🙁

A good question that has taught me two things:

1. You can't trust SQL's ISNUMERIC function

2. You can build a recursive CTE - although I'm no sure I would want to...

I was looking for the catch - nice that for once it wasn't a trick question!