Thanks for this. We have done a lot of what...

Thanks all.

Yes this is complicated setup with the different layers of host-vm-instance etc.

Just to add to the complication, the VM has a SQL 2008 instance and a SQL 2012 instance...

Hi Grant,

Thanks for your reply.

I've checked this morning and running the query now takes roughly 20 seconds, compared the 15 yesterday. A little longer than yesterday, so I thought maybe...

GilaMonster (1/24/2014)

---

Maddave (1/24/2014)

---

However, on the live server, I have suddenly thought, the last full backup of the database was taken back when log shipping was first created - September 2012!!...

Thanks for the reply, that is what I thought would happen. I think I need to do a bit of experimenting then. I am running R2 so can...

For reference, I had a long play around with a number of different queries, to try and retrieve the amount of writes to the disk for each database. Eventually...

Bhuvnesh (11/8/2013)

---

Maddave (11/8/2013)

---

Some of them have also ventured into using single user mode, but again, they end up locking themselves out of the database and not being able to reconnect...

Bhuvnesh (11/8/2013)

---

Maddave (11/7/2013)

---

A number of our developers may execute changes within applications and then need to restore a database back to a starting point multiple times on a test system,...

sqlmunkee (11/7/2013)

---

You don't need to bring the database back online before doing the restore.

I do this quite a lot:

ALTER DATABASE myDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE;

RESTORE DATABASE [myDatabase] FROM ...

Firstly, I would question why you are allowed access to view this data. As a developer I would normally expect you to never touch production systems. That is how...

dwain.c (9/26/2013)

---

I love extended properties. Very comprehensive introductory article!

The only think I find annoying about them (unless I missed something) is that you can't update them. Need to...

I used Extended properties to try and keep track of the multiple databases across a range of servers as well as any database users. This way I can find out...

Love this article. Point 5 I have blatently stolen and now added to a slide deck on Database Security which I have to present to a load of developers...

Thanks both of you, that is kind of what I thought would be the answer. As the DBA I am working with our IT Security team to make sure users...

No, I thought that, so made sure all query windows were closed. All that was open was a query window using the master database and the activity monitor which...