Explore >> Select a destination
|
You are here 
|
michaeljswart.com | ||
| | | | |
www.red-gate.com
|
|
| | | | | One of the most important aspects of data management is the ability to ensure that the data in your database is well defined and consistent. Some aspects of that are ensured through the relational data structures you design. Another piece of control is using the correct data type. Then, we get to constraints. A constraint is a way to validate data prior to adding it to your database. This is one more tool in the toolbox that helps you maintain good data. | |
| | | | |
gist.github.com
|
|
| | | | | An Assert framework for SQL Server. GitHub Gist: instantly share code, notes, and snippets. | |
| | | | |
sqlstudies.com
|
|
| | | | | Everyone deals with deadlocks from time to time. But sometimes we need to control who's the deadlock victim and who isn't. For example, I'm doing a big delete on a table in a 24x7 environment, I can't afford downtime to do it so I'm doing my delete in small chunks to reduce transaction size and... | |
| | | | |
gist.github.com
|
|
| | | Rename Roam daily files to Obsidian daily files. GitHub Gist: instantly share code, notes, and snippets. | ||
