Excellent.

But that doesn't explain why a couple of gb file fills up 20gb of tempdb... I still think something else must have been going on.

Good gosh no, I'm not upset. I just realized that simply saying over and over again "Service Account" wasn't being very clear. So I decided to be clear as crystal....

I had never heard of that before. Extremely useful information. Thanks for putting it up. Makes the decision to keep hyperthreading off production even better.

What's the context that the "index group" is mentioned? The only thing I can find referencing is in the dynamic management views for looking at missing indexes. According to Kalen...

Are those two seperate fields? If not, ORDER BY with a TOP will get what you want. If what you're trying to do is find all the records for a...

I did some tests. For good or for ill, I found that the XML & Table of Numbers worked better than anything else when dealing with large tables and complex...

You just have to keep the tests honest. I wasn't counting icons and going "Oooh, it's faster." In the simple tests, both processes had a table scan. The one that...

Very good points. I was just going to start looking up similar solutions in Itzik's books when I saw your post. I figured there was a way to bring a...

I just tested it on some larger procs. It really is better. Hmmm I'll have to document this one in our best practices doc.

antonio.collins (1/6/2008)

---

how can this:

select * from monitor_hosts where @myList like ('%,'+cast(hostid as varchar(8)+'%')

be faster than this:

select * from monitor_hosts where hostid in (select val from dbo.fListToValues(@myList))

the first statement will always...

If you're using the function as a table, you can simply join to it. We do it all over the place.

Unfortunately, table valued functions don't have statistics, so if the...

The link to the ZiffDavis IT myths doesn't seem to be working.

I agree with Jeff here. Naming tables after the database they're contained in is not going to be helpful. Also, I wouldn't recommend using the module in the names. I'd...

Inside the SQL Server 2005 folder is a folder called Configuration Tools. Inside there is a tool called SQL Server Configuration Manager. Open that up. In there on the left...

Is "E" a drive or a share name?

It has to be permission issue from the service account that SQL Server runs under. Not the 'sa' login, but the login...