select *

from

MyTable

inner join (select custname,

...

Keep in mind that the log backup will free up space INSIDE of the transaction log, so that the DB can continue to log activity. This will NOT give...

...and don't forget - the nice thing about temp tables is that they're TABLES (meaning - can be indexed, etc...). Sometimes building an index on a temp table is...

Lynn Pettis (3/3/2008)

---

Okay, I feel even smaller now with all this praise. Jeff, the last word most people at work would use to describe me is humble. At...

Jeff Moden (2/29/2008)

---

Folks, when you do an interview, remember... you're not trying to show off how smart YOU are, you're trying to figure out how smart the other person is...

paulhunter (3/2/2008)

---

One thing I haven't seen covered is column aliasing. There are two styles for that and one is syntactically more correct but I believe the other is preferable....

Did I see my name mentioned? next to some amazon gift cert? woot!

Why ODBC? ODBC is on its way out - why not OLE-DB?

Besides SQL is so much more optimized to "talk" oleDB....

Are you sure the message is originated by your install operation (as opposed to an insert trigger on the table?) I've fallen for the duplicate row message only to...

(I'm sure that one of the SNIA's will be by shortly to rap my knuckles sharply with a ruler, so let's make this "simple")

I think you're reading too far into...

1. Agree with Grant - keep the connection open only as long as is required. That being said, opening a connection, making 2 calls in a row, then closing...

Try....

System.Security.Principal.WindowsIdentity.GetCurrent.Name.ToString()

According to the BOL quote - using 0 to pass in would serve the same purpose as passing the original fillfactor. Meaning 0 = use the original fillfactor.

I'm not...

Adam Bean (2/29/2008)

---

Matt Miller (2/29/2008)

---

I was testing using the Alter...rebuild, since the DBCC REINDEX is falling out of favor these days.

That probably bears confirmation. Should be easy to verify...

For a quick "free" boost in performance - since there logically should be no overlap between the two - replace any of the UNION operations above with a UNION ALL....