:w00t: congratulations indeed 😎

Last of a dying breed...

Rumour has it that the Bugatti Veyron costs £3M to make, so they lose money for each and every one they sell at £1M.

Even if this is just an urban...

Race against time indeed.

If they allowed 2 days for the exam, then a lot more people would be able to...

Good luck Vedran 🙂

I'd also add the clarification that 'merge' is supported only when it comes to new extent allocations.

I use contig from sysinternals for defragging files.

Run it with -a -s options to see how many fragments you have per file within your sql data folder.

If you see that...

TheSQLGuru (7/22/2013)

---

.... The other biggie, and I mean potentially non-functional application biggie, is deadlocks. I have had several clients that have started throwing a blizzard of deadlocks after moving...

Best is to run the compression estimation on each structure and then decide which ones are worth row-compressing, which ones page-compressing, and which ones are best left alone.

If page...

Might be worth checking for Stored Procs marked as 'startup' 😉

alternatively run sp_configure to disable...

My guess would be *very few* if any.

If you are remoting from outside the US, the latency can make things quite a bit harder.

Last year at PASS they had booths...

congratulations:w00t:

Yes - apply principle of least privilege.

Only allow DDL access to those who deploy

Only allow write access to those who really need it (typically depoyment team again)

Everyone else just read...

The threshold is claimed to be 70%, just like the other Microsoft exams.

I hope you've done well 🙂

Also log space reservation means that the operation may need quite a bit more than double the data size to be available in log capacity.

I've seen up to 5x data...

For SQL2008+ I'd look into the Audit functionality first.

For SQL2005 or lower, SQL trace is your friend. See how you can create server-side traces on startup. 🙂