2015-03-24
2,190 reads
2015-03-24
2,190 reads
2014-12-04 (first published: 2014-11-17)
1,410 reads
Aaron Bertrand supplies a script which generates two separate sets of commands: one to drop all foreign key constraints, and one to create them again. These scripts are stored in a table so that, if you drop the constraints and then disaster of some kind strikes during the create, you still have everything handy and can troubleshoot if needed.
2014-10-17
8,457 reads
2014-05-20
1,778 reads
2014-04-14
2,253 reads
This procedure let you list [optional] by table:
-Foreign keys
-Primary key
-Indexes
2015-03-27 (first published: 2014-02-06)
3,978 reads
Get all the dependent tables for a master table up to N level(Till the leaf ) you can either find dependency or you can find all the child tables.
2021-04-14 (first published: 2013-09-04)
3,139 reads
This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.
2013-06-17 (first published: 2013-05-30)
1,084 reads
2013-04-24
2,043 reads
Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.
2018-04-13 (first published: 2013-03-19)
1,334 reads
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
The table InventDim has some indexes, we create one index idx1 which has index...