Duncan P (6/19/2012)

---

Taking a risk for a big payoff is one thing, but many people (without any other kind of safety net - e.g. a wealthy family) will not want...

Who's "you" in this question?

Everyone who fought the Nazis, including internal rebels within Germany, took...

patrickmcginnis59 (6/18/2012)

---

Matt Miller (#4) (6/18/2012)

---

patrickmcginnis59 (6/18/2012)

---

Everybody on the lower income spectrum would...

I don't have any certs. Hasn't had any impact at all, positive or negative, on job hunting, doing my job, or anything else I'm aware of.

Jeff Moden (6/16/2012)

---

I'm not so concerned with people that use sharp spoons to chop down the tree. It's the ones that think it's really cool to use six headed...

Vertigo44 (6/14/2012)

---

Yes but mine did not say 0% remaining. Mine said 0% COMPLETE after sitting for about 45 minutes. I've got MS on the line and I think we might...

I once had a transaction with 0% remaining on the rollback for 3 days. Ended up having to restore the database from a backup in order to resolve the...

RedGate has a book on that subject: http://www.red-gate.com/community/books/sql-server-execution-plans

TravisDBA (6/14/2012)

---

"I heard a great quote recently from Abraham Lincoln that I think applies. He said "If I had eight hours to chop down a tree, I'd spend six hours...

isuckatsql (6/12/2012)

---

I used a Temp Table, but it made the query a lot slower!

I also used the loop joins and nolock because they improved performance.

By combining CTE, loops joins and...

An index on a commonly-accessed foreign key column is a pretty common way to speed up Join queries. Is that what you're asking about?

It depends on what is in the column. Index size can't go over 900 though, so nvarchar(2000) is often impossible to index. BigInt is no problem to index.

I'm...

If the formulae for the computed columns are deterministic (in SQL Server's opinion), then you can persist the values, and even index them if you want to.

Here's a sample of...

You have to use double-single-quotes to put single-quotes in a string that way.

Not the shift+quote key, the quote key twice.

Had another thought on this. Modified version:

DECLARE @String VARCHAR(1000) = 'Bev\Soda\The Dew',

@Delim CHAR(1) = '\',

@Elements INT = -1, -- 0 =...