Viewing 15 posts - 1 through 15 (of 6,660 total)
I think you just have to start from the actual CU you are trying to install:
Set-Location 'E:\SQL_2019\patches'
SQLServer2019-KB4577194-x64.exe /ACTION=Patch /ALLINSTANCES /QUIETSIMPLE /IACCEPTPYTHONLICENSETERMS /IACCEPTROPENLICENSETERMS /IACCEPTSQLSERVERLICENSETERMS
January 25, 2021 at 10:19 am
Just my 2ct: Check this value.
Maybe activating this setting can take some pressure of your plan cache because it only has to calculate the stub and not actually put it...
January 25, 2021 at 9:29 am
Of course, a monitoring product is nice and fine and $$
But, if you are on a 0 budget, you could start the KISS way:
( we always install as DBA DBMail...
January 21, 2021 at 9:47 am
for what it's worth ...
- it took me 5 years to get our apps to a state that sysadmin was no more needed and no non-dba had sysadmin at OS...
January 20, 2021 at 11:45 am
have a look at SQLServer Joins
January 18, 2021 at 2:02 pm
Start with Database Migration Assistant (DMA)
but I don't think it holds migration data for ssis.
January 18, 2021 at 2:00 pm
...
I farted, it made a sound... and I didn't have to change my underwear! 😀
...
MADE MY DAY ! ! 😀
January 6, 2021 at 9:28 am
Thank you for sharing this estonishing "story from the trenches".
Happy new year.
January 4, 2021 at 10:02 am
I think you forgot to pose the question related to this execution plan.
Just reply the question and attach the .sqlplan renamed to .txt file.
Happy new year !
January 2, 2021 at 12:02 pm
Why did you configure that many Listeners ?
A listener is a AD object, managed by your windows cluster.
A single one could be sufficient to have you AG available
listeners-client-connectivity-application-failover
December 1, 2020 at 10:44 am
Check out Query Store
my QS ref: https://www.sqlskills.com/blogs/erin/category/query-store/
December 1, 2020 at 10:28 am
I hope you mean the TSQL way for compression!
backup database xyz ... with compression ;
Do not use compression at windows operating system level !
Unless you have...
November 27, 2020 at 1:12 pm
Double check your target folder itself ( or volume ) has not been enabled for compression !
SQLServer does weird things when someone enables compression at disk level.
November 25, 2020 at 6:47 am
are you producing striped backup files ? ( Backup database - working with a striped media set )
That may also help to reduce the time needed. ( if that...
November 23, 2020 at 3:05 pm
Viewing 15 posts - 1 through 15 (of 6,660 total)