Viewing 15 posts - 46 through 60 (of 7,489 total)
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
Notably, your concerns are coverd by "intelligent"
Ofcourse a dba will still need to interprete and test all this .
We still do not want indexes like "[<Name of Missing Index, sysname,>]"...
April 30, 2025 at 2:39 pm
Viewing 15 posts - 46 through 60 (of 7,489 total)