Only necessary when using sp_executesql (which takes nvarchar parameters). Not important when using EXEC. Also, you cannot define a variable of type ntext.

Jeff Moden (6/9/2009)

---

Yowch! I have some pretty strong feelings about that....

There is no for loop in SQL. There's only the While loop.

Still need to see the table definitions, index definitions, function definitions and the execution plan.

Also, can you please edit your post and wrap your query in the code tags to...

SELECT SERVERPROPERTY ('EngineEdition') Will return one of 'Standard','Enterprise','Express'.

Developer, Enterprise and Enterprise evaluation all return 'Enterprise'. Standard and Workgroup return 'Standard' and Express, Express with Advanced Services, and Windows Embedded SQL...

jcrawf02 (6/9/2009)

---

Someday I'll learn how to write English that actually makes sense. What I was trying to say was that you could potentially find someone you were interviewing in SA...

They aren't formulas to have values plugged into and results calculated. They are descriptions of the time-complexity of algorithms.

To say that...

Not in SQL 2005 or above they do not.

What RAID gets you that single drives don't is redundancy. With the appropriate RAID level, you could have one or more drives fail and have the server still working. With...

usman.tanveer (6/9/2009)

---

The problem with mirroring would be, in HA mode it will not commit the transaction on primary untill commited on secondary, which could be a performance hit as the...

Jeff Moden (6/9/2009)

---

GilaMonster (6/9/2009)

---

Gee Barry

RBarryYoung (6/9/2009) Big-O notation categorizes an algorithm's complexity in terms of the dominant term (without any constant factors) of its execution run-time as a function of...

RBarryYoung (6/9/2009)

---

Yeah, sorry. :blush: In my defense, I did say that it was "simple once you understood it, but hard to explain" and I did tell him to follow...

From experience I've found that fixing the 3 top performance problems in the DB often provides an incredible improvement in overall response and performance

Steve Jones - Editor (6/9/2009)

---

Diffs don't impact log backups. At least I didn't think they did. They only reduce the number of log restores needed, but AFAIK (correct me Gail),...

Grant Fritchey (6/9/2009)

---

The key to using a nickname is to use it everywhere. You just need to have an accessible association point so everyone knows that "SQL Hottie" or whatever...