Viewing 15 posts - 46 through 60 (of 301 total)
Synonyms. Minor PIA, much less so than alternative of editing DB names every time you migrate code. Fixing your DB names is better long term strategy, and you should keep...
December 27, 2017 at 10:05 am
For many years I've been using a free utility called ClickOff, by Johannes Hübner. Works well. Easy to find on the internet.
December 13, 2017 at 9:49 am
ManicStar, thanks for posting your findings. Good info.
October 12, 2017 at 8:08 am
Doh. That would be the Luis Cazares solution.
September 1, 2017 at 5:53 am
September 1, 2017 at 5:52 am
I'm with crow1969 on this. We've done it with both AG and FCI server setups, never had a problem.
August 16, 2017 at 8:53 am
I thought this was great. Learned something today. Thank you.
August 7, 2017 at 7:13 am
"The Nimble Elephant" by John Giles. Best, most-pertinent design book I'veread.
July 7, 2017 at 8:02 am
Something that could make these gaps matter more is a smallint column datatype.
March 8, 2017 at 4:11 pm
I reckon the join to #Archive was the critical improvement factor. That makes sense to me. Thanks for posting this.
February 24, 2017 at 12:37 pm
Chris, this has been pretty interesting thread. Now that things are better, would you mind summarizing or showing what was the change that actually seemed to make a difference? I've...
February 24, 2017 at 9:41 am
Nice question but now I reckon I don't properly understand this. I compiled the proc w/out modification, using my sysadmin login, but when I run it I always get...
May 27, 2016 at 10:55 am
Workload-related index recommendations can be obtained from sys.dm_db_missing_index_details. Many good articles have been posted on how to do this.
This would also recommend FK indexes due to parent...
April 26, 2016 at 8:51 am
If no parent deletes (and no updates to parent keys) I would not add an index "because of" the FK. If you need the index due to workload then...
April 25, 2016 at 1:51 pm
Viewing 15 posts - 46 through 60 (of 301 total)