What resource were the...

There are many ways to write these types of query - not all of which are strictly the same. There are frequently slight semantic differences which mean that LEFT...

An alternative solution would be to create insert, update, and delete triggers...

coder_t2 (2/21/2011)

---

However, this SS2005 instance has 2 other databases associated with it, a Adhoc and Archive db that are about 40GB in size. I was wondering if there is a...

CREATE TABLE #User (userID INT PRIMARY KEY, email VARCHAR(100) NOT NULL);

CREATE TABLE #UserProfile (userID INT NOT NULL, fieldID INT NOT NULL, value VARCHAR(50) NOT NULL, PRIMARY KEY (userID,...

It looks like you are trying to create some sort of structured output data file from SQL Server using xp_cmdshell. This is usually a bad idea, for all sorts...

Did you try Lowell's suggestion? The 'missing' column in your data should work just fine I think. I'm too lazy to set up a test myself - perhaps...

I think you missed the fact that there is only one index, and...

Yes.

In 2008, you can often...

See http://www.sommarskog.se/share_data.html#globaltemp

SELECT A.NameA, C.NameC

FROM #TempA AS A

CROSS

APPLY (

SELECT TOP (1)

...

Using the OUTPUT clause is a much better option - I can't remember the last time I used SCOPE_IDENTITY, @@IDENTITY, or IDENT_CURRENT. Not only is OUTPUT more flexible (you...

Craig Farrell (2/23/2011)

---

Thanks Paul, I was worried I was barking up the wrong tree. Apparently I was in the wrong forest. 🙂

I'm going to need to read that a...

ken.trock (2/22/2011)

---

Hello. Has anyone seen where the max degree of parallelism setting under sp_configure is ignored? We set ours to 4 recently; restarted that SQL instance (which I'm reading isn't...

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 of encrypting? Not...