When you use the detach/attach method, you'll have to detach you source

database which means that at that point you haven't even got your source

in a safe condition any longer.

SELECT BloggerName,Topic,[Year],Total,count(*)

FROM

BlogCount

group by BloggerName,Topic,[Year],Total

"Kill" always results the data in consistent state;either commit or rollback

http://msdn.microsoft.com/en-us/library/ms187928.aspx

create the exec plan for both the approaches.and post it here along with index/table definition.

Sometime i observed that these...

ignacio.aranda (12/3/2010)

---

I had a tempdb mdf file which was 60 Gb, and I tried shrinkfile, and shrinkdatabase and got nothing. I noticed that I had several databases in 'readonly' mode....

See my attachment. do we need set any settings/configuration ?

anolan (12/3/2010)

---

Thank you for all the thoughtful responses. I guess the answer is no, I should not reorganize or rebuild during working hours. I think the best way for me...

sraned (12/5/2010)

---

My SQL server knowledge is limited and would appreciate your advice. We are developing a custom report and hence had written the program code and created new custom tables...

Sachin Vaidya (11/29/2010)

---

Hi,

If I do,

SELECT col1, col2....

FROM table1 AS A

INNER JOIN

(SELECT col3, col4....

FROM table2) B

ON A.col1 = B.col3

Or, I first take the inner query in a temp table first and...

Well , it depends if you...

it might be happening when it starts...

Post your script which you are using

see this link also http://www.sqlservercentral.com/Forums/Topic1026649-145-1.aspx