This works for me. other people might have written a better one.

select OBJECT_SCHEMA_NAME(sys.objects.OBJECT_ID) AS [SCHEMA], sys.objects.name Object, sys.database_principals.name username, sys.database_permissions.type permissions_type,

sys.database_permissions.permission_name,

...

I'm calling MAXDOP!!!!

you probably have more schedulers on your lappy than you do on the server so it can parallelize and split the select * amongst parallel threads better.

just a...

run a showplan on both and also count the data in all the involved tables.

I'm guessing you'll see a difference somewhere.

If not, then I'd be very curious about other differences...

oh yeah and

"Mark it zero, Dude."

😎

I believe the client option exists in SQL Server's encryption and IPSec both for the same reason.

A Server which has multiple resources (in this case DB's) where some resources require...

profiler reports the database where the transaction originates.

so unless someone was actually USING tempdby a la:

use tempdb

go

it won't show up.

Cheers!

Try running dbcc checkdb with REPAIR_REBUILD

http://msdn.microsoft.com/en-us/library/ms176064%28SQL.90%29.aspx

Whatever you do don't run it with REPAIR_ALLOW_DATA_LOSS. You'll hate yourself in the morning.

If the rebuild doesn't fix it you might have to create...

In SQL 2005 both point to the same view as far as I know.

the data actually exists in the invisible resource database.

One thing to remember is the metadata visibility in...

Brings up an interesting point. I sometimes quote large texts from others to respond to and put a long dashed line beneath.

I should have done a better job of...

you nailed it.

PLE of 300 means that objects are in cache for 5 minutes.

That's not too shabby. More is obviously better.

Something to consider would be to try to average...

sql server appears to have enough memory.

The OS might be a little starved for attention.

How much memory did you leave the OS?

Like Steve, I frequently consult Slava Oks who wrote...

Rich,

That is brilliant!

I will add that to a list of things to include in future revisions.

thanks, Ignacio!

This is actually a repost.

I've been surprised at the modest amount of success the article has enjoyed.

It's mostly preaching to the choir,...

LOL!

Good stuff! Made my AM.

To know what resource the user is accessing you'll need the rpc: batch completed (stored procedure) and SQL Batch Completed (ad-hoc SQL).

There are filters for loginname in your trace filters....