Search Results

Trying to understand deadlock that is occurring with repeatable read isolation level when the stored proc is invoked. This is the deadlock xml : <TextData> <deadlock-list> <deadlock victim="pro …

Below ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = { 150 | 140 | 130 | 120 | 110 | 100 | 90 } is not propagated to secondaries in DB mirroring or AlwaysON since they ship log blocks vs tr …

You should check out This is how to shred Extended Event XML faster. The gist is to Put the XML into a variable. Shred the XML rows into a temp table. Also, see below answer by Martin Smith …

Deleting files on NAS should not be done by sql server. You should rather use powershell to do it. You can use my function Clean-NASOldFiles which uses robocopy to scan files extremely fast and will …

The alternative you mentioned seems to be the best choice. What you can do is a 2 step process : Take native sql server backups with compression using Ola's backup solution locally. Use Robocopy to d …

I have a slightly different opinion. If you are not experiencing memory pressure and your application is just working fine, why introduce an unknown variable (in your case - increasing sql server max …

Based on the comments so far - SQL server has no knowledge of how EFS does encryption. Turning off EFS - the timing is reduced almost similar to pre-TDE timing (confirmed by OP). This means that EF …

To get subscription list from a publisher database, you can run below tsql : use publisherDB; select db_name() PublisherDB , sp.name as PublisherName , sa.name as TableName , UPPER(srv.srvname) …

I would suggest using dbatools - Sync-DbaAvailabilityGroup with -Exclude <-- exclude the settings that you dont need to sync. Honestly, you should sync all e.g. sp_configure, logins, jobs, etc

My understanding is that you are not approaching this in the right way. you just copy the login using the same sid to all the secondary server. Users get replicated since db is part of AG. Basically …

There is no point in taking db into single user mode and then making it offline. background service like sql agent might try to connect to the db. If you want to get more details of what process is …

If the listener port is 1433 and the clients also gets connected through port 1433 to the reporting server that is part of the Availability group will there be any port conflict. If 1433 is just ded …

You can set the service property to restart it (service properties --> recovery --> first / second / third failure and have a delay between each restarts e.g. 1 min). You should also, have the service …

You can use dbatools which is powershell based. For your case you need to have a 2 step approach. use the cmdlets in Backup and Restore – Certificates Backup-DbaDbCertificate Backup-DbaDbMasterKey …

You have to shutdown sql server and start it in single user mode (in configuration manager, you specify -m as start up parameter) and then restore master database. See : this mssql tip for more detail …