I'm one of those that fall into the "will be retiring soon" group. Yet a year ago I moved into the compliance arena and find that I am learning new...

Interesting concept, thanks.

I agree, over protection is far better than under.

I think it's a great idea. That would give us better control, tracking, and implementation.

John Mitchell-245523 (12/2/2016)

---

Or this:ALTER DATABASE SQLTRIX SET SINGLE_USER WITH ROLLBACK IMMEDIATE

You can use RESTRICTED USER instead of SINGLE USER if that's more appropriate (in other words if none of the...

Thanks for the continued in depth look at Hadoop

What's with having something undocumented, so they can throw it out later?

Just learning something new is a benefit to my own self esteem, regardless of how it may have an affect on my long term status.

ggrewe (12/1/2016)

---

I am not sure why are you dropping and recreating the Foreign Keys? Why not just disable and re-eanble them?

If the table has an Identity column, you cannot...

Thanks for the article and extra info.

My dad was a used care salesman (an honest one).

Does it really matter how the code is written as long as the finished product functions in a way that works...

Interesting script. I need to look at this a little closer. I do see that you have it so you can just print out results by swapping which lines are...

Thanks for the article.

Budd (11/29/2016)

---

That was EYE opening - http://www.sqlservercentral.com/Forums/Skins/Classic/Images/MessageIcons/W00t.gif

I have often wondered of the (Effects?) of ANSI_NULLS, and now I have a slightly clearer understanding.

By changing SET ANSI_NULL to OFF...

NULLs can be a problem.