Technical Article

Drop and Add Foreign Keys

Have you tried using DTS to load a database and those pesky foreign keys mess you up? This is actually two scripts, one to generate the SQL needed to drop all the Foreign Keys in a database and another to Add the Foreign Keys back when you are done. I've thrown in Disabling and Enabling […]

5 (9)

You rated this post out of 5. Change rating

2005-07-13 (first published: )

3,053 reads

Blogs

SQL Server 2025: Not Just a Database; A Data Engine Reimagined

By

Let us be honest; most database upgrades feel like a patchwork of performance tweaks...

Build and Deploy Dockerize Python Application to Azure Container Instances (ACI) using Azure DevOps

By

As a software Engineer, I would like to deploy my Dockerized Python Application to...

Navigating Modern Data Architecture: DW, Lakehouse, and Lakebase Explained

By

The report outlines the evolution in data management systems, transitioning from traditional siloed structures...

Read the latest Blogs

Forums

Data Model for a framework to keep track of ETL processes

By GBeezy

Im attempting to come up with small framework or set of SQL tables that...

How to optimize queries using AI (SQL Expert)

By Daniel Calbimonte

Comments posted to this topic are about the item How to optimize queries using...

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Visit the forum

Question of the Day

Capacity Planning for an Existing SQL Server Workload?

You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires?  What single or multiple tools would you use to answer the questions around resource needs?

See possible answers