I found the grammar and spelling to be fine.

Can you point out any typos?

Great start

Ahhhhh glasshopper

How many db's have you got - it would have to more than about 20 to dismiss Bill's excellent suggestion.

Whether you do an attach or restore (with move) you'll need to get him/her to create some users and give them permissions on the restored db.

Create the user under the...

Had a similar issue on a Dell server running with 8GB of RAM -

Go to Server Properties - Memory tab and ensure the "Reserve physical memory for SQL Server"...

Have you got your Windows account registered on both servers and does it have permissions on the databases you are querying?

Just a thought.

This is interesting (I'll just put my anorak on)

I have recently been playing with a copy of Quests SQL Central (I don't...

Is it blocking or is the server running out of locks?  If you are running out of locks it means that the available memeory is low. 

What is the specification...

Sorry - carriage returns lost in transit!!!

USE UserDB

GO

DBCC SHRINKFILE (DataFile1, 7)

GO

I agree with Craig - set up the shrink as a task - try using shrinkfile - I don't like using the maintenance task shrink method it never seems to...

Enjoyed the article - just use the undo button!!!  🙂

Gonna use the transaction template - cheers.

Sim

Thanks for the tips folks - I am going to experiment with Recompile and the keep plan option - sounds good to me - cheers

Sim

This drives me mad - previously some stored procs run in 100 ms or less - then suddenly jump to 2000-5000 ms without a by or leave.

We have tried using index...