Wow, I know the US legal system's weird, but I didn't realise it...

Your way should work. Since this was posted in the SQL 2005 forum, I'm assuming the poster uses SQL 2005 and hence the...

Thanks. That'll be useful in the future.

You don't. There's no 'answered posts' feature on this forum.

Explain a bit more please?

Do you just want to know what indexes have more than one column in them, or do you want to list the columns as well?

Either way,...

Since you're on SQL 2005, use the Row_Number() function

SELECT groupid, days_remaining

FROM

(SELECT groupid, days_remaining, Row_Number() OVER (Partition By groupid order by days_remaining) AS RowNo FROM reminder) sub

WHERE RowNo = 1

darth.pathos (5/3/2009)

---

Edit: Ok, I just realised my mistake (I think) - the query I have looking at the Indexes only pulled IX_% ones; I wasn't looking at the PK_%...

Can you post the execution plan please, not an image of it? I need to see the properties of all the operators.

Right click the plan, select save as. Save as...

SQL 2005 has built in column-level encryption. SQL 2008 has built in database-level encryption (transparent database encryption)

If you look in sysindexes, the clustered index is the one that has an indid of 1. Nonclustered indexes have indids between 2 and 249.

Try this

SELECT o.name FROM

sysobjects o LEFT OUTER JOIN

(SELECT id, indid FROM sysindexes WHERE INDEXPROPERTY(ID, name ,'IsStatistics') = 0) i ON o.id = i.id

WHERE i.indid IS NULL

Not using native tools, no.

Basically if you want a table, you have to restore the DB elsewhere and then extract the table.

Litespeed allows you to recover a table from a...

Paul White (5/3/2009)

---

You lose nothing by using filegroups, and gain significantly: with a database restore, you *have* to restore everything. If the database is 1TB, that's going to take...

Is that really a serious suggestion?

I've...

RBarryYoung (5/3/2009)

---

My understanding of how they can do this (and we cannot) is that apparently we (SQL Server) always have some part of the object definition/header in the primary filegroup,...