Dinesh's Blog :::: Being Compiled ::::
Showing posts with label
Constraints
.
Show all posts
Showing posts with label
Constraints
.
Show all posts
Friday, September 8, 2017
SQL Server - Dropping Primary Key will drop the Clustered Index?
›
Everyone knows that SQL Server creates a Clustered Index when we add a Primary Key if there is no Clustered Index already exist in the ...
Monday, October 24, 2016
Disable PRIMARY KEY before data loading
›
In order to improve the loading performance, specifically when a data warehouse or a large table is loaded, it is recommended to disable c...
Friday, August 14, 2015
Can I disable all constraints when loading data?
›
Generally, when loading a large data set, we disable constraints and drop indexes for speeding up the loading process. Constraints help us...
Friday, February 20, 2015
Does my table hold invalid data after importing data? Constraints have been violated?
›
It is rare to see a table without at least one constraint because constraints are required to manage data integrity rules. Although we add...
›
Home
View web version
