Viewing 15 posts - 61 through 75 (of 7,505 total)
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
What have you tested ?
Here is an example ( but you'd still have to validate performancewise in your environment )
drop table #test
CREATE TABLE #test
...
May 14, 2025 at 1:58 pm
Check your SQLMI instance / Compute + storage / Backup section

May 14, 2025 at 9:03 am
Perplexity has a nice explenation and steps to try resolve the issue(s):
SSPI handshake failed error code 0x80090311
May 13, 2025 at 11:08 am
Hugo Kornelis provided a nice update on the Merge problem cases in Sep 2023 "an-update-on-merge"
May 5, 2025 at 7:55 am
there should not be a column with csv content in a 4 NF relational table.
Have a look at parent - child relationships in Codd's relational theory with normalforms
May 4, 2025 at 3:55 pm
Viewing 15 posts - 61 through 75 (of 7,505 total)