is it simple "select count(*)" or sumthing else is also running along with this??

Yes

http://technet.microsoft.com/en-us/library/ms143506%28SQL.90%29.aspx

Rohit

Yeah go with what wayne suggested import it into a temp table then join this table with main table and update the data.....

TO me it seems to be a issue with table partitioning.... and this feature is only available with SQL Server EE..

is this a live db???

If yes then restore everything on a standby server and then script out this table... create table with all constraints and then import the data...

else you...

This is really good one... thx...

Rohit

See... what you can do is when you kill the connections either you can put it in dbo mode before kicking off the restore or even simply delete the db...

Bhuvnesh (9/1/2010)

---

Mostly Sql optimizer do...

May be not always but if ordering is done properly then ... in almost all the cases....

urmarke (9/1/2010)

---

Hi All

Rather than post the execution plan, can someone point me towards a primer on how to read an execution plan generated by the ‘Display Estimated Execution Plan’ button...

What I meant was when you post the table...

Just one more addition to this..... when we select the counters we've an option to select the individual drive (i.e. C or D etc) this will give more specific info...

adnani (8/30/2010)

---

Does partitioning table need clustered Index on key( example Id or Date)

If i have a table ( ArticleDate datatime, ArticleId int ,ArticleTitle ,.....) .

when I want to partitioning this...

I'll request you to include the table definitions along with the indexes.

Grant Fritchey (8/31/2010)

---

Ramji29 (8/31/2010)

---

Matt-1034261 (8/31/2010)

---

Ramji29 (8/31/2010)

---

GilaMonster (8/31/2010)

---

DB I used to work with had a 250GB log file. Make sure that you're maintaining it correctly and don't worry too much.

Managing Transaction...