Viewing 15 posts - 16 through 30 (of 7,465 total)
Yes ( according to this MS art: Supported version and edition upgrades (SQL Server 2022) )
July 10, 2025 at 9:17 am
Here are some recommendations documented by MS with regards to your question: Database files and filegroups
July 9, 2025 at 11:04 am
Did you test having
ALTER DATABASE [YourDb] SET AUTO_UPDATE_STATISTICS_ASYNC ON
July 3, 2025 at 12:31 pm
So ... nowadays still having win2003 OS with SQL2005 or worse comes into the picture
June 26, 2025 at 6:29 am
Don't perform "in-place" upgrades!
You'll want to migrate to an new ( and supported ) OS anyway.
Request 2 OS : 1 temporary - 1 permanent target
June 24, 2025 at 10:38 am
In SQLServer you cannot drop a PK when it is being reference by FK(s). It will produce an error.
That being said, as long as you don't change the data type...
June 19, 2025 at 7:17 am
Make sure all your consumers are also in the cloud ( to avoid traffic costs ! )
Check bundle prices / volume prices, maybe multiple SQLVMs come better than installing multiple...
June 12, 2025 at 7:58 am
Select ....
from msdb..sysjobhistory JH
inner join msdb..sysjobs J
on J.job_id = JH.job_id
Where J.enabled = 1 -- only active jobs
and JH.step_id = 0
....
Keep in mind, you can launch disbled...
June 10, 2025 at 12:15 pm
Keep in mind you can use DNS-aliasses instead of (client side) sql server aliasses !
If you rely on kerberos, you will have to register SPN(s) using the FQN of the...
June 10, 2025 at 11:49 am
Have a look at the database options <snapshot options>
May 26, 2025 at 8:22 am
Define duplicate row !
Otherwise, have a look at ranking functions
May 26, 2025 at 8:19 am
I recently asked AI to revamp a MERGE statement into the 3 separate regular parts .
Of course, you can copy / paste and execute that generated code directly into production,...
May 20, 2025 at 6:33 am
remove the " not " from your where clause
May 15, 2025 at 6:22 am
Viewing 15 posts - 16 through 30 (of 7,465 total)