First, thank you to Jeff Moden for pulling out xp_dirtree, which is exactly what I was thinking when I saw the title.

With thanks to Jeff (and Robyn and Phil on...

RBarryYoung (11/14/2013)

---

Primarily because of the number of times I've executed a build script, when the the database it was trying to go to in the initial USE command didn't exist....

Mauve (11/14/2013)

---

I assign all of my SQL Server logins to the tempdb as the default database. NEVER master. This way no harm can be done by an application...

You are correct - my apologies. I'm used to having to first find the...

Steve Jones - SSC Editor (11/11/2013)

---

If people have the skills and knowledge, it becomes less of an issue because it doesn't really take longer to write the code well at...

All coding aside, in many to most of our cases, the real question is:

What is the best business case to present to management on why the increased cost, lengthened timelines,...

See the SQLServerCentral article Best Practice : coalesce vs. isnull? before you make a choice on which one to use!

Your tables - they have no indexes, particularly no UNIQUE indexes.

As the above posters have said, it's essentially a two-step process:

1) Find the <uniqueish row identifier>, MAX(VersionNum) GROUP BY <uniqueish...

Interesting article - not bad overall, though it again conflated stored procedures with parameterization, and completely missed not giving the service account admin permissions.

Password security wasn't mentioned (and given the...

Grant Fritchey (11/7/2013)

---

The other recommendations for MAXDOP are good. You can also leave it at zero if you're not experiencing any particular CPU pressure.

But, the one thing I would suggest...

GilaMonster (8/28/2012)

---

Doesn't mean they can't be corrupted due to an IO subsystem glitch. It you absolutely don't care about them at all, fine. If...

Normal SQL permissions (GRANT and DENY and the database roles) apply for reading and writing data.

TDE has no effect.

Your cryptographic approach applies for decrypting and encryption - if you use...

It is not generalizable to restore every single t-log backup in the directory you store backups - this script as presented only works if a human has already selected the...

If you're actually going to consistently follow one pattern (i.e. the domain 60 day password expiration), then I'd suggest mandating a simple SQL Server login policy. For instance:

All...

Grant Fritchey (10/30/2013)

---

Yep, you got it.

One point. You might want to consider skipping reorganize. For most indexes it doesn't do much, but is still a fairly costly operation. For detailed...