Viewing 15 posts - 226 through 240 (of 7,472 total)
Start with avoinding functions in where clauses ! ( needs full ( index ) conversion before actual use )
Declare @RefTs datetime2(0) = dateadd(MM, datediff(MM, 0, GETDATE()) -...
March 25, 2024 at 12:15 pm
Can this ref be applicable for your issue?
gMSA account authentication failure during password rotation
March 21, 2024 at 1:08 pm
spid -2 is supposed to be an orphaned DTC transaction.
ref: Disaster recovery 101: dealing with negative SPIDS (-2 and -3)
March 19, 2024 at 12:57 pm
Johan, you would need to check with the vendor, but I don't belive that performance improvements are the core reason. I belive that for some special purposethey choose KS+WS...
March 19, 2024 at 8:04 am
It is indeed scheduled in the weekend (using SQLAgent and Powershell).
Still 23 minutes is a long time to collect these statistics for this single database.
It's a good thing not all...
March 18, 2024 at 5:29 pm
Currently we are collecting database statistics information using
select * FROM sys.dm_db_index_physical_stats( 14, NULL, NULL, NULL, 'SAMPLED')
For some larger databases this statement takes more than
March 18, 2024 at 3:10 pm
We collect these statistics on a weekly basis.
This way we persist runtime history for all monitored instances.
This comes in handy when provisioning for growth or planning migrations.
Devs and application teams...
March 18, 2024 at 2:43 pm
Can you save and post the deadlock graph ?
An .xdl file can directly be opened by e.g. Solarwinds Plan Explorer (free tool), which has a great replay feature, helping...
March 18, 2024 at 8:39 am
... That login is also disabled, correct?[/quote]
Correct !
March 18, 2024 at 8:35 am
We create a sqluser "NonSA" to serve as dbowner for all user databases (unless other is actually needed - eg during install/upgrade of some software)
March 17, 2024 at 9:51 am
Recently a software vendor required collation Latin1_General_100_CS_AS_KS_WS_SC for their databases.
I still don't understand why, but - as we are used to SQL_Latin1_General_CP1_CI_AS - it really is anoying to say the...
March 15, 2024 at 7:00 am
Why P2V ?
Why not just install a VM, add a SQLinstance ( or 2 if you want ) and move the databases ?
If you can , even upgrade the SQL...
March 14, 2024 at 2:35 pm
mess up = swallow its aftermath ... at least in my opinion.
I know that is not everybody's opinion, but it's the way I roll.
Be honest, especially to yourself.
In many cases,...
March 12, 2024 at 6:50 am
Save the xml in an .XDL file and open the deadlock graph using Solarwinds Plan Explorer.
It has nice replay features to help you detangle it all
March 8, 2024 at 3:05 pm
Restore-DbaDatabase -SqlInstance server1\instance1 -Path Z:\Backup -DestinationDataDirectory Z:\Restore -DestinationLogDirectory Z:\Restore
Restore-DbaDatabase : The term 'Restore-DbaDatabase' is not recognized as the name of a cmdlet, function, script file, or operable program. Check...
March 8, 2024 at 1:21 pm
Viewing 15 posts - 226 through 240 (of 7,472 total)