I posted it here. Not sure whether it is the right forum for this.

http://www.sqlservercentral.com/Forums/Topic480536-146-1.aspx

Let’s see how SSC members think and whether need a debate.

I remember there is a parameter showing the restore progress, like 10% something, when using xp_restore_database. I did not see it work when I used it.

David, do you know...

SQL Server (2000 or 2005) needs to be installed on the top of a cluster with 2 (or more) identical nodes (either Win2000 or Win2003).

I do not think you can...

I submitted a feedback to SQL Connect regarding this issue. If you like to add any comments or additional information, please go to this link. https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=336047

set showplan_all on

set showplan_text on

select ... from tablename

The code for SQL2005 is very interesting. Do you have query execution plan? Any difference between these two plans?

Check this earlier post. It may help.

http://www.sqlservercentral.com/Forums/Topic474364-146-1.aspx

Will do. Coming soon. 😉

That should be the right place to go. Thank you Grant.

Course Name: 2791:Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services

Anyone interested? Need more people/registration to get the class roll.

http://www.nexientlearning.com/NexientLearning/en-ca/Search/CourseSearchResults?keyword=2791&uselike=0&location=&showdates=yes&org_no=ORGA2005020217135306154192&category=&coe=

Right. As it is called "Transaction" log. One Delete statement is one transaction no matter how may records or simple model.

For import data like Bulk Insert, there is...

how long the deletion had been running before "kill"? It most likely takes the same amount of time to roll back.

Huge amount of data to delete within 1 transaction?...

What was the process doing? How long has the process been running before the kill command?

Does sp_who2 show the IO changes?

You can use KILL spid WITH STATUSONLY...

As it is 2005 already, we should have better options ONLINE index, SORT_IN_TEMPDB and my favorite MAXDOP option.

Online Indexing Operations in SQL Server 2005

http://www.microsoft.com/technet/prodtechnol/sql/2005/onlineindex.mspx

So in terms of speed is this relativly slow, due to it leaving the table available?

---> No

And in terms of the transaction log; potentially this will make the log...