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

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