data type

Technical Article

RE: Problem with delete query across two databases

  • Reply

Is column oid indexed in database 1 ? If so, it might run better as an EXISTS subquery:DELETE FROM database2.dbo.transactions del WHERE EXISTS (SELECT * FROM database1.dbo.transactions TR WHERE del.oid = TR.oid)Also, are there any foreign key constraints that reference the table being deleted from ? That can seriously impact performance if SqlServer has to ensure […]


Technical Article

Maintenance plans

  • Topic

We have Veritas' Backupexec running in our Enterprise and the Veritas Install actually installs MS SQL Server MSDN on each Server in the Enterprise. It looks like it also sets up a default Maintenance plan within each of the MSDN Instances. I guess my question is.. Can I manage the Maintenance Plans on these MSDN […]



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


Can someone explain where non - clustered index is stored?

By yourjobismine

I am learning non-clustered and clustered indexing. When reading this article,involve%20any%20extra%20lookup%20step. came across this...

KBC Sim Card Lucky Draw 2022–2023

By articlewriter

Two competitions, KBC Sim Card Lucky Draw 2022–23 and KBC WhatsApp Number Lucky Draw...

Null value when checking unused indexes

By Bruin

I'm using this query to check if I have any unused indexes.. One of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers