Noted. Thanks for the article.

UPDATE [dbo].[tbProducts] set [ProductCost] = @1 WHERE [ProductID]=@2

For my test using 2008 R2 I actually got the values used in the update statement and not variables. I got:

update dbo.tbProducts...

As Depeche Mode sang - everything counts in large amounts.

"So what takes 6 hours in Oracle that takes 3 minutes in SQL server? "

I'd like to know too and I'd...

Steve Jones - SSC Editor (5/31/2012)

---

jfogel (5/31/2012)

---

Our app did not try to use say ANSI only SQL, the "mode" is detected and either Oracle or SQL Server specific code...

I guess I might take this issue a bit to heart. I've had what could amount to arguments with people who claim no app can support this or that DB...

patrickmcginnis59 (5/31/2012)

---

Grant Fritchey (5/31/2012)

---

TravisDBA (5/31/2012)

---

Sorry about that. I was trying to make the point that "generic" database designs aren't really possible due to the nature of the underlying infrastructure. Clearly...

The older version of our app is one of those that supports either a Oracle or SQL Server back end. This is not the first time where I've either read...

Um, give the function a parameter so it can do either on or off. Two functions for this is a no no.

I know that

"It depends on some good senior people in your own organization, and their willingness to assess the candidates without involving themselves in a competition of sorts with the interviewee"

Never let...

I think it is how most of us roll. It goes without saying that there are standard and/or policy based practices but by and large a lot of what developers,...

"A new job every year is probably not good when you are just starting out but for a consultant it can typically be an indication of success and a measurement...

It isn't much of a secret that the older you get the more likely nobody wants you when it comes to IT. I'm sure anyone that post here can come...

michael vessey (5/4/2012)

---

nice - not sure it's got too many practical implementations other than showing a junior how to run and correct checkdb, but it's still nice to have in...

Steve Jones - SSC Editor (5/1/2012)

---

jfogel (5/1/2012)

---

I don't see ever getting on board with having a production database running on a VM. Of course, things change but I cringe at...