Understood.

I'm just nervous. We've had a...

Go easy on him. He's trying. Gentle guidance, not all up in his grill.

Changing it from non-clustered to clustered won't affect the data in other tables, no.

There are a ton of other affects you're going to see, yeah, but no, it shouldn't change...

No real way to give you solid advice based on generalities.

But, in general, test your queries. Concentrate on set-based solutions. Avoid row-by-row processing. Make sure the queries are avoiding all...

The problem with disk queue length on a san is that you don't have any idea how many disks are involved, so the queue count isn't a number that allows...

Nope. That's not very selective at all. The recommended practices are that the data be about 1% selective, meaning 1 distinct value out of 100 rows. In practice it's usually...

Here's another short article[/url] to get you started on log backups.

blech, blech, blech

Oh man, I don't remember the specifics.

I do remember that we had code that made a call through ADO (I think it was) that retrieved the data structure of...

Hmmm... Contention for resources? Other processes running at the same time? Ummm... Not sure. But if you're getting pain from a multi-statement TVF, the best solution I know is to...

Our biggest problems weren't in the database. They were in the code that was written using ancient copies of OLEDB (or whatever the connection system was 12 years ago). The...

The table value function is building a table. That table gets built in tempdb. If you're just running the query, it may also do tempdb work, but it doesn't have...

There's pretty good information on backups (and everything else) in Kalen Delaney's excellent book SQL Server 2008 Internals. It's really my favorite reference after Books Online. I'd suggest reading up...

I've done both. The fact is, virtuals run slower. You have to know that going in. They always do. They always will. You're placing a layer of obfuscation between you...

You can look at trace events/extended events for a compile event. You can also check the cache itself using sys.dm_exec_query_stats to see if the use is incremented by one. Also,...