Koen Verbeeck (2/26/2011)

---

GSquared (2/25/2011)

---

Fully honest answers?

I'm chatty. Given the opportunity, I'll derail conversations and they'll go on indefinitely. I police it myself at work with reasonable effectiveness, but...

Try this instead:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T ;

CREATE TABLE #T (

ID INT IDENTITY

...

Jeff Moden (2/25/2011)

---

SQLkiwi (2/22/2011)

---

Steve Jones - SSC Editor (2/22/2011)

---

On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles...

SpectralGhost (2/25/2011)

---

Related to this topic, I've tried to find an appropriate time to use table variables and I still haven't found a case where a normal table is not significantly...

amenjonathan (2/25/2011)

---

I've done a few interviews. A couple were for commercial analyst positions working directly for senior management. What I wanted to see is if the candidate was willing to...

You'll have to do that by cycling through the databases. You can either do that with a cursor that selects from sys.databases, or by using sp_MSForEachDB. The sp...

Steve.hitch (2/25/2011)

---

Hi Paul,

I worked on the IBM AS/400 system for years. When I created a file and built key fields, the default was unique keys. You could override that and...

Is this what you're looking for?

SELECT T.C.value('@name','VARCHAR(64)'),

T.C.value('local-name(.)','VARCHAR(64)')

FROM @XML.nodes('/wcsxml/relation') AS T(C)

Steve:

I think what's happening is you're using the term "primary key", but what you mean is "clustered index". They are often the same columns in an SQL database, but...

Stefan Krzywicki (2/25/2011)

---

GSquared (2/25/2011)

---

Steve Jones - SSC Editor (2/24/2011)

---

GSquared (2/24/2011)

---

Evolution generally favors either suicidal levels of cooperation (worker ants and warrior ants giving their lives for their hill), or rabid...

Love the sig, camassey.

You wasted a perfect opportunity to spend the rest of the interview spewing out numbers!!!...

I think @@servername is what you're stuck with.

Steve Jones - SSC Editor (2/24/2011)

---

GSquared (2/24/2011)

---

Evolution generally favors either suicidal levels of cooperation (worker ants and warrior ants giving their lives for their hill), or rabid levels of competitiveness...

Yes, the format you describe in the original post is used quite frequently in reporting databases. Normalization doesn't matter as much as query speed in those. Very common...