DonlSimpson (12/17/2014)

---

spaghettidba (12/16/2014)

---

Use 0 if the value exists and it is 0.

Use NULL if the value does not exist or is undefined.

If you used 0 when NULL was more appropriate,...

Eirikur Eiriksson (12/16/2014)

---

Eric M Russell (12/16/2014)

---

Eirikur Eiriksson (12/16/2014)

...

There is an alternative for this case which is the sparse column, it practically does normal foreign key constraint when the value is...

Eirikur Eiriksson (12/16/2014)

...

There is an alternative for this case which is the sparse column, it practically does normal foreign key constraint when the value is not null, otherwise ignores it,...

For columns containing a foreign key enforced with a constraint, you have no choice but to not use NULL, because the primary key can't contain a NULL. Even if there...

Database developers, at least in my corner of the universe, typically save our stored procedures as scripts which get checked into source control and maintained for subsequent versions. However, when...

We have that in Visual Studio. Most of my T-SQL code changes are done in VS/TFS.

Steve Jones - SSC Editor (12/15/2014)

---

Eric M Russell (12/15/2014)

---

Most backup utilities are database centric. If the server must be restored, or one wants to spin up a UAT envrironment that...

Most backup utilities are database centric. If the server must be restored, or one wants to spin up a UAT envrironment that closely mimics production, then restoring the databases is...

In the past 246 days, students have made 2,261,601 apps and pictures by writing their own computer programs. Click on the pictures and screenshots to see each program in action....

gregg_dn (12/11/2014)

---

If developers gave users what they needed, most people would never attempt to write code. I've used many different RDBMS over the years and can tell you that...

I'm not sure that a general purpose programing tool geared toward the general public would be useful. However, the general public can extend the functionality of common applications using things...

Yeah, it's kind of...

lshanahan (11/26/2014)

---

Markus (11/25/2014)

---

You guys must live in a perfect world of applications... However, the bulk of the SQL Server based apps are small companies and don't have the resources or...

However, one limitation of most commercially and publicly available address databases is that they don't include exact house number, but instead a range of valid numbers, so would have to...

ZZartin (12/9/2014)

---

Eric M Russell (12/9/2014)

---

There are many commercial providers of address data. This would be better than attempting to make a web service call for each record in an ETL...