Could you please post...

I thought I'd just add that we have been using it for a year as well with no problems.

GilaMonster (7/8/2009)

---

OKAJ I **WEKING CAWMED HOWM AND SAW TE UPDATE JEH? AWN I WSN LIKE WOOOT??? CO0L UPDATE3Z T0D4y PL**AXK? THWN IT WES A FREKING STWID TAWBS *********MUTEHR****** UPWDATE=!?!?!?!?!?!?! HOW...

Just my 2 cents, but I really prefer using joins. I like the separation of join criteria from filter criteria. Makes reading code much easier.

Ewan Hampson (7/8/2009)

---

Lynn Pettis (7/8/2009)

---

Simple question for you though, would you read a 600 page book written in all capital letters? I wouldn't. Mixed case as appropriate is...

Curious, if we were interested in looking at something else that may be more of true RDBMS, what would you suggest?

sqlguru (7/8/2009)

---

In a "true dr.codd" relational database, a DBA would define Table A, define Table B, define Table A's PK, then "relate" Table B to Table A. The physical side...

Sounds like your database is using either the BULK-LOGGED or FULL recovery models and you are only running full backups and possibly differential backups between full backups. Neither of...

Also, I can read code fine wether it is written in all lower case, all upper case, or mixed case. What I really want from some one writing code...

Most people on this site are practitioners not scientists. Not really sure you will find what you are looking for here.

Simple question for you though, would you read a...

If you are using the Express Edition of SQL Server, SQL Server Agent is not included, and you can't download it either. If you need to run scheduled jobs...

It should be noted, iirc, that if you want to write code that will port directly to Oracle, all object names need to be created and typed in UPPER CASE....

No. It all comes down to company standards and/or personal preference.

As a former co-worker once stated, Standards are great and every one has one.

If SQL Server required all UPPER...

What do you want to occur when both Field1 and Field2 are null? Leave them null?

Nope. Native Backup Compression is only available in SQL Server 2008 Enterprise Edition.