If you have two fields in your where clause, in this case F1 and F2, then it would take advantage of an index that has the key fields (just F1,...

PLE is only accurate for what you want to use it for after the cache is full. This is returning the average age of the pages in memory, so...

While I feel it's probably good that you can do this through t-SQL if required, I think the idea of adding -t1222 is more than a little out-of-date. Starting in...

SQL Agent jobs that failed on the last run:

SELECT J.name

, run_datetime = cast(STUFF(RIGHT(run_date, 4), 3,0, '/') + '/' + LEFT(run_date, 4) + ' ' + REPLACE( RIGHT(CONVERT(varchar(30), CAST(convert(varchar(8), STUFF(STUFF(RIGHT('000000' +...

Here's a script that will give you the top 10 wait stats over the last 15 seconds along with what percent of the overall waits they were on the server...

Query Stats has it all, and if you join to sys.dm_exec_cached_plans you can find the object type and filter it down. I actually recently put a blog post together...

I have my blog syndicated through SQL Server Central. The problem with blogging is that there's no feedback on if you're providing a useful service or if people are...

If you have parallelism, you also have the added cost of parallelism. In this case, you're taking two completely separate processes and running them at the same time, which...

George,

I'm working through the same exact issue with the same vendor right now. I have a couple procs, and I think this is one of them. Have you...