Steve Jones - SSC Editor (7/20/2011)

---

I'd tend...

Rod at work (7/20/2011)

---

I appreciate this article, Steve, as it's something I have faced for the last 3 years. No training, no conferences, etc. However, in my situation it...

When it comes to technology training, I've always trained myself. I attend monthly user group meetings and local day events, and I earned my certifications by studying exam prep books...

Using query or join hints, the developer can influence the decisions that SQL Server makes when it creates the...

"To know ten thousand things, know...

upstart (7/14/2011)

---

Well, the reason I am worrying about this one specific table being dropped is because it is used to store information from another DDL trigger we have setup on...

Your description of the problem alone is not clear enough. Since the question is essentially how to develop the DDL for the table and SQL query, let us know how...

For the past several years I've stuck this convention: I name my tables after singular nouns, and if the primary key is a system assigned integer (ex: identity), then that...

obarahmeh (10/19/2008)

---

Dear all,

If this number " 4690573010" is the result of a sql statement: what should I do to retrieve this number in the following format:

469.057.301.0

I mean: add a...

A couple of years ago, I had the files located under my wife's My Documents folder encrypted using Windows Encrypted File System (EFS). Then one day it somehow got corrupted...

There are some DBAs who do nothing but provision servers and disk storage, schedule backups, etc. You may see that in a large organization like Google where there are hundreds...

Craig Farrell (7/14/2011)

---

Eric M Russell (7/14/2011)

---

If a primary key occurs in another table, then I most always create a foreign key relationship, and if there is a simple business rule...

If a primary key occurs in another table, then I most always create a foreign key relationship, and if there is a simple business rule that can be applied to...

Sometimes I use DRI but most of the time I do not.

When DRI is used, it makes truncating tables difficult. You need to do them in a very specific...

I don't think that knowing from memory the syntax for infrequently used T-SQL statements and admin commands is relevent. However, I do expect a candidate to complete the following test...