Viewing 15 posts - 2,806 through 2,820 (of 2,905 total)
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
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
kucyk - Friday, February 17, 2017 7:20 AMture, but only for >= 2012 instances 🙂 thank you
Extended events existed in 2008 as...
February 17, 2017 at 7:32 am
Viewing 15 posts - 2,806 through 2,820 (of 2,905 total)