Viewing 7 posts - 1 through 7 (of 7 total)
A little update which seems to underline one of Kevins first statements: network is especially important here.
A VMware specialist has reviewed the environment and did come up with a few...
April 17, 2015 at 1:52 am
Oh, this will so much be a great learning experience..
@kevin, hopefully your jet-lag will quickly fade... I very much care about those details. The current SQL 2012 is...
April 15, 2015 at 3:21 pm
Thanks for the feedback.
Regarding the index and statistics maintenance; that is done on a weekly basis using Ola Hallengrens solution. But even with a refreshed set of indices and up...
April 15, 2015 at 7:51 am
Setting the 'min memory per query (KB)' to a higher value could also be considered (after thorough research) as an option to prevent spilling to tempdb.
July 15, 2013 at 5:04 am
You only need to set up the Event Notification for the database (or server). The stored procedure is only needed in the database where the queue resides. You could send...
December 22, 2009 at 2:25 pm
If you need a jump start on working with Relog.exe to get .blg files into SQL Server, check out those two links.
Relog SQL database schema (nasty datetime handling)
Relog Syntax Examples...
May 8, 2009 at 1:08 pm
Laurie Bantin (7/16/2008)
i think you can write the query in the new syntax much more clearly and easily (if you are using SQL Server...
July 16, 2008 at 2:49 am