opc.three (11/26/2012)

---

You make a lot of good points which is not surprising. I do not agree with many of them but as you correctly stated that's a reserved right of...

ScottPletcher (11/26/2012)

---

pdanes (11/26/2012)

---

DiverKas (11/26/2012)

---

But wouldn't this always compare all variables, though? In the syntax with OR, the query engine can see that a variable is empty, thereby satisfying one side...

You're welcome.

On the two rows (as you figured out), I only copied one into my test harness. You'll have two (or more) when you use real data.

However, you should...

Computed column won't work if there are applications that directly access the table. They'll pull the existing column in Selects, and modify it in it Update and Inserts, so...

Something like this:

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

DROP TABLE #T;

CREATE TABLE #T

(ID INT IDENTITY

...

If you can't count on catching all the entries into the table (possible inline code), then a trigger is probably your best option in SQL 2005.

However, you can probably speed...

The T-SQL query optimizer doesn't really shortcut the way you're thinking.

I took a relatively large table on one of my test servers, added an index to an nvarchar(75) column, and...

I've seen Read Committed run faster than Read Uncommitted in a couple of circumstances.

One is if the table is heavy on data-modification, and Read Committed Snapshot Isolation has...

opc.three (11/21/2012)

---

GSquared (11/21/2012)

---

opc.three (11/20/2012)

---

GSquared (11/20/2012)

---

opc.three (11/19/2012)

---

GSquared (11/19/2012)

---

Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to...

Getting the inside skinny is a good idea. May it work out well for you.

Can you save the execution plan as a .sqlplan file and post that here? That would definitely help.

The way you're doing it is pretty standard. You could switch from an inline sub-query to a Cross/Outer Apply in the From clause, but it won't really do much...

Hold out for the SQL job, instead of the docs job. At the same time, I recommend looking around for other entry-level SQL jobs.

Career-wise, database work can go a...

Can't be installed directly on Linux. Only on Windows.

Why? It's a Microsoft product, and they hate Linux with a passion. Ballmer called Linux a cancer: http://www.theregister.co.uk/2001/06/02/ballmer_linux_is_a_cancer/

If you...

opc.three (11/20/2012)

---

GSquared (11/20/2012)

---

opc.three (11/19/2012)

---

GSquared (11/19/2012)

---

Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to disallow accessing...