Explore >> Select a destination
|
You are here 
|
antzucaro.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. | |
| | | | |
buttondown.com
|
|
| | | | | In a SQL database, you can set up a foreign key with REFERENCES: nullbitmap=# CREATE TABLE ab (a INT PRIMARY KEY, b INT); CREATE TABLE nullbitmap=# INSERT... | |
| | | | |
stribny.name
|
|
| | | | | A list of things that we can do when we need to scale a SQL database. | |
| | | | |
blobeater.blog
|
|
| | | Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory for your SQL Server. You can clearly see that if you enter a silly figure such as 50 MB, the minimum memory amount allowable for max server memory is 128 MB. You will see SSMS... | ||
