Viewing 15 posts - 181 through 195 (of 700 total)
Other places to check when seeing elevated ASYNC_NETWORK_IO waits:
- Check the entire network path between the database server and the client(s). A switch connection somewhere on the path may...
September 20, 2018 at 11:51 am
I agree with you that option D is the lesser of those four evils.
The correct answer is:
E - Run CHECKDB with ALL_ERRORMSGS, NO_INFOMSGS, and no repair options to determine the...
September 19, 2018 at 4:55 pm
September 15, 2018 at 10:16 pm
The target system (the server to which you are shipping logs) must be on a version equal to *or greater than* the source of the transaction log backups. Upgrade the...
September 10, 2018 at 10:05 pm
Looks like you're discovering the value of cram sites. Hope your box didn't get rooted going there.
September 9, 2018 at 4:34 pm
You patch AGs the same way you upgrade them.
-Eddie
September 9, 2018 at 4:31 pm
SELECT
September 8, 2018 at 5:29 pm
I wanted to know if setting Auto Update Statitics to TRUE will be good for...
August 29, 2018 at 4:57 pm
August 29, 2018 at 4:17 pm
If your Database Master Key (DMK) is encrypted by the Service Master Key, then you will need to re-encrypt the DMK with the new Service Master Key on the new...
July 12, 2018 at 10:52 pm
The behavior changed in SQL 2016:
https://support.microsoft.com/en-us/help/4010261/sql-server-and-azure-sql-database-improvements-in-handling-some-data-t
If you run the query on a SQL 2017 database set to compatibility level 120 (SQL 2014) or less, it will...
June 13, 2018 at 3:59 pm
I looked at the mask: 111111111100000000001111111111, which I'm guessing is:
00000000001111111111
00000000001111111111
...and they have 10-core processors with hyperthreading turned on, and this mask is to stick to the physical...
June 7, 2018 at 5:35 pm
June 4, 2018 at 5:58 pm
June 4, 2018 at 5:47 pm
I have done a lot with Distributed Replay. Some things you should know:
Distributed Replay is 32-bit code from the SQL2005 days, even if you pulled it off the...
May 10, 2018 at 8:18 pm
Viewing 15 posts - 181 through 195 (of 700 total)