Out of interest, are the indexes on your T: drive both non-clustered and clustered or just the clustered indexes?

GilaMonster (3/11/2013)

---

Dunno about the law where you are, but there's often a difference between taking a copy for personal use (backup) and distributing copyright material to someone else. It was...

Thanks for the advise Gail, duly noted. Guess I'll...

No worries, if you IM me with your email address I'll get some bits sent over to you. Hopefully they'll help.

I must admit, since I started with SQL Server (back in Jan 2012) I've definitely...

anthony.green (3/11/2013)

---

If you could send me the material for 50400A that would be great, unsure my contacts can send it without getting into trouble with MS, so would be good...

anthony.green (3/11/2013)

---

Nope not done 50400A, but did do 6231A and 6232A, which where when 2008 got released which covered the DBA and DD exam routes at the time.

I do have...

That's one of the reasons I'm concentrating...

I really do sympathise with you Anthony as I know how gutted I was when I didn't pass (@DBAReactions on Twitter had a great post that expressed it quite well...

Check this link out, it may help:- http://msdn.microsoft.com/en-gb/library/ms345368(v=sql.105).aspx

If you've got the disc space and you're having performance issues with the Tempdb, I'd definitely look to move it to it's own...

Is your TempDb on it's own disc or is it on the same disc as the other system Db's?

Hi, have a look at the 'prerequisites' section in this...

Oliiii (2/22/2013)

---

We've tried mirroring many DB on the same instance and we started having problem at around 50 DBs, that might have changed on SQL 2012 though but mirroring is...

I can't think of a way (other than creating a dedicated log shipping/mirroring test environment and using copies of your...

Hi, I love DR so I'm also intrigued as to what people think....

Firstly, how big are the Db's on the server and secondly, do you have a budget to work...