Jack Corbett (11/22/2008)

Better late than never. Oh, and based on your tweets it didn't seem like you were...

Hey Jeff,

Just curious, I was thinking about it, and, you know, I was wondering, have you got a good, you know efficient, way to clear a table?

All my love,

Grant

Oh, and one more.

On the URGENT posts. My favorites are the ones where you post a possible answer to the question with five minutes of the OP, but you don't...

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...