Technical Article

Generate Add Foreign Keys statements for the table

I was going through the painfull optimization of the database of creating better clustered indexes (not the default ones on the primary key).This operation was requiring removing all foreign keys to this table and then recreation them again.I created this script to optimize this quite tidious task.

1 (1)

You rated this post out of 5. Change rating

2006-06-08 (first published: )

739 reads

Blogs

Microsoft Purview GA menu’s

By

The new data governance features in Microsoft Purview are now being made generally available...

Connect to Power BI as a Guest User in another Tenant

By

Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...

Parsing EXE Output in PowerShell

By

I saw a post internally that asked this question: Anyone have a handy powershell...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

Automate reports for when the SQL database was last used

By PreethiKenchappa1

Hi, I'm working on cleanup activity of deleting databases that aren't in use or...

Veeam Queries.

By goodtimecharlie

Good morning campers! I'm hoping to pick your collective hive brain wrt Veeam /...

Visit the forum

Question of the Day

Disable All the Indexes

How do I disable all the indexes on the dbo.Logger table?

See possible answers