Thanks for the interesting question!

Tom.Thomson (3/29/2011)

---

If ARITHABORT is ON and ANSI WARNINGS off, arithmetic overlow causes the batch to be aborted. See the second sentence of the remarks section of this BoL page.

SELECT @i+=1...

george sibbald (3/29/2011)

---

UMG, you talk about THE development server and THE production server, do you only have one of each? If that is the situation you can afford to apply...

Nadrek (3/29/2011)

---

That's easy to imagine; transactions started prior to time X get the prior version, transactions started on or after time X get the new version. Thus, any one...

Nadrek (3/28/2011)

---

If MS wants to go with the CU approach, then MS should design the system such that CU's can be applied (and rolled back!) realtime, without any outage. ...

Steve Jones - SSC Editor (3/27/2011)

---

At the same time, we have CU6 for R2 and no CTP for the first Service Pack. Granted the RTM quality of R2 was very...

Thanks for the question!

Thanks for the article, and the discussion, there is a lot of good information here.

happycat59 (3/25/2011)

---

Steve - whilst you may not have heard of checksum (Vs parity) in relation to RAID 5 , try searching google for "RAID 5 checksum". I do agree...

Thanks for the question Steve!

I just noticed that the formats, both source and final, you list in the subject don't match what you have in your code, so I'm not sure which is supposed...

Lisset (3/23/2011)

---

Hi everybody I want to convert data like '27-Ene-11' to format yyyy-mm-dd, for this I'm using the script:

select convert(char(8),cast('27 Ene 11' as smalldatetime),112)

and show the error :

Msg 241, Level...

I suspect that there is a setting that is different on the third server. Try checking all the settings by right clicking on the linked server and scripting it out...

CirquedeSQLeil (3/24/2011)

---

TCP 1433 should be changed in most cases to a different port number. This port can be changed but whichever port you decide on for the TCP stack...

That should work fine, there is noting in the DB/backups that are specific to the CPU architecture. (x68 vs. x64)