Viewing 15 posts - 1 through 15 (of 44 total)
Much thanks for the tutorial, great job
December 28, 2016 at 1:31 pm
Bah! If I had any control I'd give you an extra point for being a pro-active DBA
October 11, 2016 at 10:58 am
Thank you for the feedback. If I wrote the question again I would focus a bit more on learning SERVERPROPERTY options rather than nuisances of patching levels....
October 10, 2016 at 11:49 am
question is old, but taught me something new. thanks
October 4, 2016 at 2:51 pm
Thanks for the share. Might especially be good for people/companies that don't have budget for 3rd-party platform polling applications. Could loop list of servers\instances + have...
September 22, 2016 at 8:53 am
Yes, very good question
August 31, 2016 at 9:24 am
Good question. Although "not need to do anything" is not totally correct. There is some initial configuration that needs to take place. Once it's up...
August 21, 2016 at 10:57 pm
By default, the DAC only listens on the loop-back IP address (127.0.0.1), port 1434. If TCP port 1434 is not available, a TCP port is dynamically assigned when the Database...
August 16, 2016 at 8:31 am
Thanks for the feedback Tom. Definitely planning on writing more as it forces me to keep learning new stuff.
August 10, 2016 at 11:49 am
Thanks Nakul, that's a good one too I didn't see before. link has been included up top
August 10, 2016 at 8:11 am
I agree, good documentation on this prior to 2012 is limited. There is some good information in this book https://books.google.com/books?id=HvD2-aqsDtAC&pg=PA442&lpg=PA442&dq=sql+server+buf+array&source=bl&ots=POqF2EmvRg&sig=kJM2ygTBRcTSaNq3NzyZ2Q7eBMY&hl=en&sa=X&ved=0ahUKEwjru8G0grfOAhVP-mMKHW1bATMQ6AEIHjAA#v=onepage&q=sql%20server%20buf%20array&f=false
Under "BUF Array" and "Flushing and Freeing...
August 10, 2016 at 8:08 am
Thanks for the positive feedback! My hope was to not make the question too tough, trigger learning more than challenge. But looking at the % correct feel...
August 10, 2016 at 8:04 am
I understand what the author was trying to achieve in the question but it is still syntactically incorrect and will generate an error. (SET ANSI_NULLS = ON)
August 9, 2016 at 9:57 pm
old question but still really neat
August 9, 2016 at 9:19 am
Yes, question has 2 correct answers. With option 1 being most correct.
August 3, 2016 at 11:53 am