Viewing 15 posts - 1 through 15 (of 73 total)
:w00t: congratulations indeed 😎
Last of a dying breed...
September 4, 2013 at 11:01 am
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...
August 31, 2013 at 9:14 am
Vedran Kesegic (8/28/2013)...Really tough exam. It's a race against time....
Vedran Kesegic (8/28/2013)
Race against time indeed.
If they allowed 2 days for the exam, then a lot more people would be able to...
August 29, 2013 at 2:13 am
Good luck Vedran 🙂
August 28, 2013 at 3:40 am
I'd also add the clarification that 'merge' is supported only when it comes to new extent allocations.
August 27, 2013 at 2:52 am
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...
August 24, 2013 at 12:25 pm
July 31, 2013 at 7:03 am
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.
July 26, 2013 at 5:37 am
kellie.jenkins (7/25/2013)...Is there anything else to check to try and find what is running these traces??
Is there anything else to check to try and find what is running these traces??
Might be worth checking for Stored Procs marked as 'startup' 😉
alternatively run sp_configure to disable...
July 26, 2013 at 5:17 am
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...
July 25, 2013 at 1:29 am
July 19, 2013 at 5:00 am
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...
June 26, 2013 at 5:56 am
Vedran Kesegic (6/21/2013)...I can only hope that passing threshold is not above 90%.....
Vedran Kesegic (6/21/2013)
I can only hope that passing threshold is not above 90%.
The threshold is claimed to be 70%, just like the other Microsoft exams.
I hope you've done well 🙂
June 21, 2013 at 12:49 pm
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...
June 11, 2013 at 6:22 am
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. 🙂
May 22, 2013 at 4:57 am