that's an interesting one for sure.

The advice has to be generic I guess to cover when third party tools are being used. I usually track through the sql logs and the windows logs but as...

Funny, I had a sort of similar issue the other day. I disabled named pipes on client and server and now every connection is though tcp/ip.

Many years ago I actually...

cool! That's what I figured, I just needed confirmation and couldn't seem to find it in msdn/technet/bol/setup.

thanks.

ah well not if you set the default locations during setup. In this case the Data Root Directory was set to the shared drive - this puts the system...

generally you need to check for any errors prior to your error to see if something else cause the failure.

first thing I'd do is back the database up on its...

I usually ask questions based around the cv / what the person being interviewed claims to have done. Moral don't put stuff in your cv because you think it'll impress/get...

you may have the database selected in SSMS. These sort of messages/situation are a pain to be sure - I usually issue these two commands from any query window if...

actually the job which shows the main difference is an index rebuild.

there are no clearing dbcc commands.

Process is restore database

checkpoint

and that's it.

other tests seem to show some slower execution, as...

this will generate a set of statement to run in QA ( allows you to be selective if required ), change "Users" to the required user/logon/role

select 'grant select on ['+name+']...

to be honest 8GB of ram is insufficient to run one instance let alone two x64 sql server. If you check all the x64 stuff you'll find that a reasonable...

don't assume just because you see a cxpacket you have a problem - it's the wait time which is important.

Without wishing to generalise too much - usually poorly formed or...

having had the ability to carry out quite a period of storage sub system testing and such if your system has issues with heavy io then performance of the san...

your server has 12gb allocated to it mostly for the buffer cache. It's set correctly - you don't need permission to use awe ( well not in that sense anyway...

there's a protocols blog which might be of use http://blogs.msdn.com/sql_protocols/

this team have some really great stuff which has helped me more than once - not sure if this...