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

Try CROSS APPLY

SELECT t.*

FROM dbo.EMP AS e

CROSS APPLY dbo.testfn(e.Employeeid) AS t;

Change it, then keep an eye on your processor to see if you're still seeing bottlenecks there. Monitor processor queue length and the wait states to see if those numbers...

When you're returning 1/7 of the table, just scanning it makes more sense for the optimizer. I suspect that's the primary issue, but without details, we're still stabbing in the...

If you're not seeing it, I'd put money down that he's accessing an old backup or has a second set of commands that's stripping out the users. Nothing else makes...

Probably just has to do with the structure and access mechanisms. Assuming no changes to the execution plan, no changes to the distribution of the data, no changes to the...

Have you taken a look at the Resource Governor?

Start at Microsoft. That's always the best spot.

I wouldn't sweat the Max Degree of parallelism nearly as much as I would the cost threshold for parallelism. The default value there is 5, which is EXTREMELY low, especially...

Take a look at the execution plan for the query. see what it's doing. It could be you're building lots of temporary storage processes (hash tables, sorts, work tables, etc.)....

I agree with everyone else. Resource Governor is going to get you close-ish, to what you're looking for, but it's not going to do specifically what you need. And, it's...