For once I am glad that I knew an answer to a question without having to look it up to even confirm it.

I don't remember why, but I wound up...

Awesome article series Gail!

I know several development teams that could use to read these, if only I could make them.

They keep creating single column indexes for all their joins, without...

I can improve that to 1578 ms if I hard code a 3 for the legnth I cut off the LEN function's return.

PRINT '============ CONVERT to handle...

Finally got a chance to use Jeff's test data.

This seems to work for french, I'd expect that it would work for any language that uses convert 106 to put dd...

David McKinney (1/20/2011)

---

Très bien, Jeff! Except of course that you can't keep everybody happy!

In France, June and July are Juin and Juillet respectively, and hence JUI and JUI when...

Good question... made me think for a second.

My gut reaction was "Yes, of course, you can Checkdb just about anything".

But then I sat there thinking, "if it's so obvious why...

kenambrose (1/18/2011)

---

I believe there are some serious flaws in this article. For example, recepts represent a historical record of a transaction occuring in a moment in time.

If one...

Koen (da-zero) (1/13/2011)

---

Great, but difficult question.

I had to read the section on converting binary string data on the MSDN page for CAST and CONVERT a few times to get it.

But...

DugyC (1/11/2011)

---

God damn it!! I would have got this one right had I read the MSDN linked page properly, it was my reference from google.

I assumed VARCHAR & NVARCHAR would...

Chris Harshman (1/10/2011)

---

In my previous life as an Oracle DBA / Developer, I think I understand this question better than people with just a SQL Server background. Other database...

Koen (da-zero) (1/10/2011)

---

cengland0 (1/10/2011)

---

Koen (da-zero) (1/10/2011)

---

What kind of trigger? The question asks if it is possible with a trigger. So it is up to you to find out if there...

cengland0 (1/7/2011)

---

Since Server A gets data from several sources via SSIS packages, the database that contains the raw data gets very large transaction logs. As you are aware, any...

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

---

cengland0 (1/7/2011)

---

mtassin (1/7/2011)

---

I disagree -- it is a...

CirquedeSQLeil (1/7/2011)

---

I view it as a change but a change for the good. This provides less disk requirement, point in time recovery and is better than shrinking the logs....

cengland0 (1/7/2011)

---

mtassin (1/7/2011)

---

I disagree -- it is a major change. If it...