Viewing 15 posts - 16 through 30 (of 30 total)
June 21, 2018 at 6:58 am
I can't find anyone with this problem. This is a very bad bug if that is what it is. Linked servers haven't been touched in over a year. sys.servers is...
June 19, 2018 at 6:54 am
November 21, 2017 at 12:19 pm
So we know we can make the query faster by a rewrite, we are kind of interested in the fact that the optimizer is picking a plan that is vastly...
November 21, 2017 at 8:53 am
2008R2
https://www.brentozar.com/pastetheplan/?id=BJ891oexM 1:00
2012
https://www.brentozar.com/pastetheplan/?id=H125WiexM 10:12
November 20, 2017 at 11:42 am
November 20, 2017 at 11:26 am
November 20, 2017 at 10:59 am
I know, but the users are lets say, technologically challenged...
October 11, 2017 at 9:20 am
October 11, 2017 at 9:01 am
try sp_spaceused 'tablename', 'true' for the table that you are deleting from, we ran into this yesterday. For some reason meta data on the table was stopping the shrink and...
February 9, 2017 at 1:51 pm
February 9, 2017 at 12:59 pm
February 8, 2017 at 10:04 am
Viewing 15 posts - 16 through 30 (of 30 total)