Ever wanted to add a UNIQUE constraint WITH NOCHECK ? Maybe you had some duplicates in your data, fixed the code, but you cannot remove the duplicates, or maybe it’s a “temporary” thing.
Read more »
Category Archives: DB Development
Add UNIQUE constraint WITH NOCHECK ? Not really …
Posted by Horia
on 19/05/2015
2 comments
Passing a DataTable as table parameter from C# to stored procedures using table type
Posted by Horia
on 14/04/2015
1 comment
So may times I’ve seen useless loops to save many rows of data into a table, where data was captured in the front end part of the application. And sometimes, the row number was quite high – for example, where user was filtering some rows available to him, or imported from a data source like excel or access mdb file. Read more »
Table size growth when converting columns – VARCHAR to INT
Posted by Horia
on 21/03/2015
No comments
How many times have you seen VARCHAR columns holding INT (or NULL) values only ?
Read more »