Viewing 15 posts - 2,791 through 2,805 (of 2,899 total)
Another thing to think about is licensing cost.
SSRS requires a SQL license. So if you put your database and SSRS server on different physical servers, you will need 2...
February 23, 2017 at 10:12 am
February 22, 2017 at 3:29 pm
February 22, 2017 at 2:21 pm
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 view that...
February 22, 2017 at 11:20 am
February 22, 2017 at 10:55 am
Viewing 15 posts - 2,791 through 2,805 (of 2,899 total)