Select all then paste?  Oh master poster of over 3500 posts, surely you meant "Select all, then copy?"

Have you considered making smaller transactions?  The incremental deletes you're doing get committed only at the very end of a transaction. Somthing like

(

DECLARE @start_id int

DECLARE @end_id int

DECLARE @total int

SET @start_id...

I would echo what R L is saying.  I came across it worded a little differently, and I have it experienced this under certain circumstances:

Charging less than appropriate, less than...

Well - a many to many is implemented in SQL using 2 1-to-many relations from the mapping table.

If you want to base a query on the many to many relationship,...

This would be functionally the same as the initial query he had only if there are no duplicate values (in Salary).  This query would return only one record, whereas the...

This is using a sub-query.  The sub-query  "(SELECT COUNT(DISTINCT (e2.salary))

FROM tes e2 WHERE e2.salary >= e1.salary)" tallies up the number of distinct values that are greater or equal to each...

RANT ALERT...... RANT ALERT.....   RANT ALERT....

<rant>

It's funny to me to see how little respect Application developers seem to get from the data community.  Let's face it - it's a self...

Zippy -

look up the BCP utility.  It's a command-line util which will allow you to save the contents of a SQL execution.  There are a bunch of options you...

ouch...so you either have:

• something that creates an outlandishly large transaction and doesn't commit it
• something smaller that failed while in a transaction, and didn't roll it back (so the transaction stays...

I know I'm coming in late to the party - but do you really need transaction logs on the tempDB?  If it really is being used as it is -...

That was the gist of the conversation we had with the CIO when he cooked that scheme up... We had to educate him on our support woes with our off-site...

I'm not sure if there's a SQL-related question, or if it's a business rule you're grappling with. 

That being said - if a particular aggregation isn't meaningful, then don't use it. ...

...from the SQL 2005 "how to license" document.

http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc

<quote>

Virtualization is defined broadly as the running of software on a “virtual environment.” A virtual environment takes place when an operating...

...meaning - VM's work well when there are peaks and valleys of activity in each of the instances, so that the resources can bounce back and forth.  SQL servers (well...

...true as long as the instances are running in the same instance of the OS.  It's by "virtual" CPU (so if it's running in a VM situation, it's per CPU/VM). ...