The main place to use Simple recovery is in systems where either all data changes are through scheduled ETL processes, or systems where all data changes can be re-run for...

bas de zwart (10/20/2009)

---

Thanks everyone for your insights. I have to be honest and have been playing a bit of the devils' advocate. I often use the (top x *)...

Gift Peddie (10/19/2009)

---

Agree with Gift and Jeff on documentation and "passing the baton". Any project that's in a position where losing a person, either due to employment termination or accident/illness,...

ItalianOlgi (10/19/2009)

---

GSquared (10/16/2009)

---

Because it tastes better that way.

(Others reading this thread, be aware that...

Right. So without some form of disaster recovery/prevention, it's looking like that one would result in potential data loss, and certainly removes the guarantee of integrity.

acarlson-861483 (10/19/2009)

---

I am constantly amazed by what people will buy or buy into. The movie "Idiocracy" does...

DateAdd month, if you're using the Arabic calendar or Chinese calendar, functions quite differently than if you're using the Gregorian calendar. All by itself, that makes the function non-deterministic.

Edit:...

bas de zwart (10/19/2009)

---

What happened to "right click in SSMS > script to 'select'"??

Works like a charm, I still haven't seen any technical reasons for this option to be here...

Agree with Peter on Pivot: totally useless function as implemented, would be useful if it didn't require hard-coding.

Agree with Gift and Jeff on documentation and "passing the baton". Any...

I prefer "tastes great" over "less filling". She's marginally better looking, in my opinion.

AD_MailingAddress.MobilePhone,

SD_Admission.SDAdmissionCD,

vs

ISNULL(AD_MailingAddress.Email,'') AS Email,

ISNULL(AD_MailingAddress.MobilePhone,'') AS MobilePhone,

That means the results will only be the same if neither of these columns is ever null. Regardless of syntactical structure, this means the...

create table dbo.CompCol (

ID int identity primary key,

MyField int,

MyDate as dateadd(hour, -5, dateadd(second, MyField, '1/1/1970')));

go

create index IDX_CompCol_MyDate on dbo.CompCol (MyDate);

Result:

Msg 2729, Level 16, State 1, Line 1

Column 'MyDate' in table...

Right. In that case, you'd use "Where left(Zip, 5) = '05123'", instead of "Where Zip = '05123'". That's why I referenced the Left() function.

If you do that kind...

GilaMonster (10/16/2009)

---

As far as I'm aware, it doesn't matter. With a missing log file, the...

Is that T-SQL?

I ask, because the parentheses at the beginning of the From clause don't seem to encapsulate a derived table.

Another first-glance issue is all the Like statements that seem...