SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Wednesday, October 25, 2017
How to update 2 tables with 1 statement in SQL Server..the hard way....
›
Every now and then you will get someone asking how to update two tables with one statement in SQL Server. The answer is usually, no that ...
Foreign Keys don't always need a primary key
›
In the post Your lack of constraints is disturbing we touched a little upon foreign key constraints but today we are going to take a clos...
Thursday, October 19, 2017
Your lack of constraints is disturbing
›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
Wednesday, October 18, 2017
SQL Server does support regular expressions in check constraints, you don't always need triggers
›
Someone posted the following question I need to add table called group with a column called code How do I add a check constraint to the...
Tuesday, October 17, 2017
Standardized Naming And Other Conventions
›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
Monday, October 16, 2017
Do not trust the SSMS designers, learn the T-SQL way
›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has chang...
‹
›
Home
View web version
