/* Contest Entry */

You said that this was a 2008 machine, so for Query 1 and 2 (and the 3rd non top 10 query to do the insert) you would...

The warning about the snapshot being invalidated is to do with the current snapshot (if still available - it can expire and be deleted too).

The current snapshot before dropping an...

The two procedure calls you mentioned in the original question are the ones you need to call (and in that order). This is exactly what the GUI does in...

Slightly misleading wording. It should read "how many columns can be used in a nonclustered index key". The important part is to make clear that you are talking...

That is a pretty apt analogy IMO. Tiles that you lay yourself can be a little fumbled/imperfect, but a tile-layer would be able to do a professional job. ...

CirquedeSQLeil (8/13/2010)

---

I read an article by one of those bloggers once upon a time that basically said to forget about what anybody else has done and just blog it. ...

Andy, I couldn't agree more. I have only just started but can already see the benefit. I used to have ideas that could have been put onto a...

Hi Gail,

here are the execution plans.

I think that I may have understood the reasoning behind the differences now.

I was talking about the first two tables in the execution...

Gail,

are you flying Air France by any chance? I have pretty similar times for my flight from Paris to Seattle.

Business class would be nice, but can you justify the...

Will do,

it'll be easy enough to find you in the crowd, especially with a shirt like on your avatar! 😉

I hope to have fun. I've never been to the USA, let alone the PASS Summit.

If the European Summit is anything to go by, then the bigger brother should...

Thanks Steve!

I also got this response directly from the PASS organisation team:

While registering, it will ask you what you would like to register for on the agenda page – first...

Hi there,

I want to register for the pass summit, but I cannot see where to enter the promotional code SSC3D for the extra discount and ticket to the ssc party.

Do...

Hi there,

we experienced this problem yesterday. Luckily for us only a test installation.

The workaround that we used was to remove all nodes from the cluster (1 server), uninstall the...

Hi Eric,

thanks for your heads-up too! I am migrating to 2008 64 Bit in the next few days and will have SSIS to consider too. This has not...