Hey Ali,

I'm not sure why you would want to. If you were writing articles and getting them published, sure, I could see that being something for a resume. ...

What Ali mentioned above will put both names on the same line (and any extra data), which is what you'll want 99% of the time in SQL. If you...

For starters, you have to understand that everything is a transaction, just you usually don't see it.

SELECT * from Foo... is a transaction, as is UPDATE Foo SET Bar =...

That's just beautiful:

SELECT

ss.SecurityID,

POWER( 10.000000, SUM( LOG10( multiplier))) AS TotMult

FROM

...

That's a deliciously beautiful workaround to the ideas...

CirquedeSQLeil (9/17/2010)

---

Brandie Tarvin (9/17/2010)

---

Trey Staker (9/17/2010)

---

I've never walked out on an...

I've also seen PAGEIOLATCH's block themselves, when they're waiting for drive data, and not seen any multi-threading when I was looking at sysprocesses.

Ah. That would depend more on the method of expansion I think, but if you're working with any of the drives that SQL server relies on, you can just...

Drix,

More then happy to help you, but need a little more information from you, since we're going to need to actually test that code. It's too dense to spot...

Sql Server won't care about the drive size unless you tell it to (such as expanding a filesize manually), or it needs to autogrow an existing file. Then it...

LutzM (9/16/2010)

---

I'm not sure if the FULL JOIN can be replaced with a CASE statement as well. At the moment it looks like it's possible. It would be great to...

Yeah, Lutz, pretty much the same result, but I see what you're driving at. I had been originally tempted not to put in any code at all and ask...

Yeah, I know, it's painful, but I was figuring this had...

GilaMonster (9/16/2010)

---

Do you have another drive with 2.5 GB on it? (The C drive even, or a flash drive, anything!)

If so, move TempDB completely (ALTER DATABASE TempDB ...), then...

$1/strip? I'd be more then happy to subscribe, say, $10/year for a weekly strip, but $1/strip? Yeaaah, no.