Excellent. Please post back with the results.

I think you're on the right track, yes. The function sure sounds like the primary cause.

As to the IN statement, with a really small one like this with hardcoded...

THREADIZENS!

Who is going to make it to any of the SQL in the City events coming up in the next week+?

You can also try XML. Parsing XML can be a somewhat memory intensive process, but moving that much data is already going to be memory intensive, so it might be...

You can use the Profiler GUI to playback a trace against a server. But, it's single threaded, so you're not going to be able to scale it up much. SQL...

You sort of can't. Not really. There's no way to break down memory, cpu or I/O by database in that manner.

However, what you can do is capture the query metrics,...

Mainly if it does what it says on the box. I've got a chapter in there, but I haven't seen all the other chapters. I'm curious how the team did....

Like it says in the article:

To use sys.dm_os_buffers as part of a monitoring process, you just have to look for the two events, RESOURCE_MEMPHYSICAL_LOW or RESOURCE_MEMVIRTUAL_LOW. These are available in...

The amount of space used by the database isn't determinative of the log size. It's the transactions that come through. You can have a gigantic database, but a very small...

I've got a detailed blog post on what's going on here[/url]. As noted, you need to backup the log file. You can change the database to simple recovery and...

If the optimizer still thinks, based on statistics, a different index is more selective than your filtered index, that would explain why it's being selected. I can't say beyond that...

Yeah, we're comparing apples to hammers to a degree. If there are varying loads on the servers, other differing executables, etc., then you can't really compare resource usage between them.

So, how's the material? You're reviewing more of the rough & ready aspect of getting the alpha, which is cool, but I'm curious how we did on the meat.

For those interested, it's worth mentioning that Red Gate SQL Backup[/url] has an automation routine built into the newest release that makes backup testing a lot easier. It will do...

It does depend on how you defined "used". You could also take a look at the index usage statistics to see how often a clustered index (which is a table)...