Terribly late to the party, rude of me, I know.

I agree with Steve, it seems to come in waves. It is a bit shocking that people think that posting a...

Congratulations and very well done. That looked like serioulsy tough competition.

That was just a typo. Sorry about about the confusion. The script is right and the text is slightly off.

If anyone has a volume 4 laying around, I'd love to get a copy.

That's odd. There used to be a link to buy them. I can't find it anywhere. Steve!

Last time I tried, the files were locked. You can set up a rollover so that you're getting a new file every so often and the old files are available.

Alternately,...

It's also possible that you have different default ANSI settings on the two machines. This could affect performance. A good way to test both would be to use a trace...

The first response pointed out a number of issues you have'nt talked about addressing. Query tuning, indexing and all the associated work around those issues can and do lead to...

I understand why you might not build constraints in a data warehouse (sort of), but it makes no sense at all to choose not to build indexes. I mean, you...

Check this article out

http://www.sqlservercentral.com/blogs/michael_coles/archive/2006/08/09/the-great-sql-2005-sp-cachemiss-tery.aspx

Do you mean when you connect to a server from your machine the query takes longer than when you run it directly on the server? Data travelling across the network.

If...

I think you might be better off with an index on these columns: box_no , msisdn, log_time. Then you'd have a covering index. The reason it's not using the index...

Do you ever do a FULL SCAN on the statistics or just rely on the default behavior? The thing is, rebuilding the index on Friday updates the statistics. Running another...

It's even possible that the index is actually not selective enough for the optimizer to choose it for the query. Even though you're forcing it's use makes the query run...

Not unless I've missed it to. If the value of a number is -3, it's -3, not 3 with some negative sign kept elsewhere that may or may not change...