Gives a whole new meaning to "deep dive"....

:-D:sick:

CirquedeSQLeil (2/9/2010)

---

J-F Bergeron (2/9/2010)

---

Ehh, I wish I would've seen that comment before I posted the solution,

Why be so...

Did you perhaps define your SQL columns to be CHAR instead of varchar? Char is a fixed length column, so it will pad out the column to the defined...

Steve Jones - Editor (2/9/2010)

---

Gary's argument for the award (and Jack's) are the problem I've seen with the MCSE, MCDBA, etc. over the years. HAving one doesn't mean you have...

(This answer was removed after its future question was previously deleted).

Jeff Moden (2/6/2010)

---

The Dixie Flatline (2/6/2010)

---

Thank you for that helpful information, George. I apologize.

Can someone tell me if it makes a difference whether or not the new servers...

lmu92 (2/4/2010)

---

I can't see a reason why the following concept wouldn't work...

DECLARE @orderby VARCHAR(30)

SET @orderby='MSDue'

SELECT *

FROM myTable

ORDER BY

CASE @orderby

WHEN 'Job' THEN Col1

WHEN 'Author' THEN Col2

...

Since you cannot cast the entire CASE to a datetime, convert the date to a correctly sortable string, i.e.

CONVERT(varchar(30),cast(CASE Job.[MFG Date] WHEN '1753-01-01 00:00:00.000' Then '12-31-2049'

ELSE Job.[MS Due...

GilaMonster (2/1/2010)

---

milzs (2/1/2010)

---

So does anyone have any recommendations? The requirement would read like "Given one or more records in SQL Server 2008, these records need to be completely removed...

sgmunson (2/1/2010)

---

Matt,

I really thought I had it licked when I read your post. I added a ROW_NUMBER() function (alias RN) based on your post to the original selection...

The basic answer is that Raid 5 is slower, but has better recoverability. Raid-10 is a bit less good for recoverability, but is substantially faster to write to.

That said...

I'm a little late to the party, but worrying about the phantom copy of the record in the DB when your using CLASSIC ASP to access the data is like...

Agreed to avoiding @@identity- although if you are in 2005...

I'm having a bit of a low-brainpower day, but I think you can achieve what you're looking for using ROW_NUMBER(). If you use whatever you were passing as the...

If you went from a Raid 10 stripe-set to Raid 5, your perf will suffer. The more write intensive in fact the worse it will get.