Viewing 15 posts - 2,656 through 2,670 (of 2,756 total)
that'd likely be it then. Running it in compatibility mode you'd be using the old engine for your service broker.
As you had said "According to Microsoft, "nothing" has been...
February 22, 2017 at 1:58 pm
I know that feeling. I come here to learn too and help where I can.
I am an accidental DBA as well.
I would give them a high estimate...
February 22, 2017 at 1:43 pm
If it is currently inaccessable, how much worse can it be?
It will just cause some blocking while it runs.
But 27 GB out of 115 GB isn't...
February 22, 2017 at 1:31 pm
How large is the table?
Updating statistics on a table will only be slow if that table is huge. Well, blocking will likely also occur, but if that table...
February 22, 2017 at 1:08 pm
As a thought - did you have your 2012 DB in compatibility mode when you upgraded to 2016?
February 22, 2017 at 12:32 pm
@sqlguru - Okay. I'd like to...
February 22, 2017 at 11:20 am
February 22, 2017 at 10:55 am
February 22, 2017 at 8:15 am
Your original post was roughly 2 weeks ago.
I am assuming that performance is currently slower on that server, correct?
My thoughts at this point would be...
February 21, 2017 at 2:03 pm
February 17, 2017 at 9:11 am
February 17, 2017 at 8:36 am
Thanks for your advice.
I will take a look at DxEnterprise.
In terms of the Microsoft Data...
February 17, 2017 at 8:09 am
What do you get from:
SELECT count(*) FROM tablename
WHERE Column >= getdate()-5
I am wondering if instead of doing a DELETE, you could select the rows you want...
February 17, 2017 at 8:04 am
If you want to make your licensing costs a little bit lighter, you should look at DxEnterprise. Same guys who made Polyserve back in the day. It'll do the failover...
February 17, 2017 at 7:40 am
Viewing 15 posts - 2,656 through 2,670 (of 2,756 total)