Viewing 15 posts - 1 through 15 (of 28 total)
April 5, 2018 at 7:47 pm
April 5, 2018 at 7:38 pm
April 4, 2018 at 8:01 pm
I see "DBA dying" in the topic I click. 😀 Totally agree with your last paragraph. Sums it up.
I'm actually moving out from my 8 year...
April 4, 2018 at 7:53 pm
There is a possibility some person with high enough privs created a job or proc or has a habit of running either DBCC FREEPROCCACHE or DBCC DROPCLEANBUFFERS.
March 6, 2018 at 6:58 pm
Hello, you also have the option to backup the DB (or use an existing latest backup) then use RESTORE WITH MOVE TO for each file (mdf, ndf, and ldf).
This...
March 5, 2018 at 5:01 am
hahaha im really curious to see if this is an actual problem or interview question. 🙂
March 4, 2018 at 6:25 pm
hello -- adding a few more bits of info
1. backup the tlog then shrink is enough in your case
2. reason why it makes sense to grow tlog manually in...
February 28, 2018 at 6:44 pm
the two nodes are in the same subnet. I was aware about...
February 27, 2018 at 10:07 pm
hello -- you might already be aware that the driver they use will have an impact?
But just in case here's the link: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-client-connectivity-sql-server
February 26, 2018 at 6:53 am
February 26, 2018 at 6:47 am
agree that the more time a query has to run, it increases the chance it could deadlock with something else. this might be the most generic correlation to deadlock.
February 25, 2018 at 7:21 pm
hello -- you might already be aware that the driver they use will have an impact?
But just in case here's the link: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-client-connectivity-sql-server
e.g.