This is the second time this exact question has been posted:

http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx

No answers to the questions, no further interaction at all. I wouldn't be surprised to see it again in two...

First, a question, you're moving 1.8 million rows out of the EventInformation_rob table. How many rows total are in the table? If you're moving most of the table, you're going...

I'd suggest getting a copy of the book "Database Administration" by Craig Mullins. It's not technical and it doesn't focus on SQL Server at all. Instead it talks about the...

I thought I remembered seeing that before.

george sibbald (1/21/2009)

---

Grant Fritchey (1/21/2009)

---

The overwhelming majority of our production systems are 2000. We're starting an initiative this year to get them upgraded to 2008 over the next two years...

True.

And one other thing I just thought of, your clustered index is a part of the covering index even though you can't see it.

Assume that ID is the clustered index....

Statistics are enough the same between the versions that you don't really need to worry about them too much.

The only way to create a covering index in 2000 was to...

The overwhelming majority of our production systems are 2000. We're starting an initiative this year to get them upgraded to 2008 over the next two years because, in 2010, extended...

How does table 3 relate to the others?

Also, didn't this get posted before in the same form?

Abhijit More (1/21/2009)

---

I think below example will give you better performance ...

CREATE TABLE tmpProduct

(

ProductIDINT IDENTITY(1, 1) PRIMARY KEY CLUSTERED,

ProductNameVARCHAR(10)

)

CREATE TABLE tmpProductSales

(

ProductSalesIDINT IDENTITY(1, 1) PRIMARY KEY CLUSTERED,

ProductIDINT,

TotalAmtMONEY,

BalanceAmtMONEY

)

INSERTtmpProduct(ProductName)

SELECT'Pr0duct' UNION

SELECT'Pr0duct2' UNION

SELECT'Pr0duct3' UNION

SELECT'Pr0duct4'

INSERTtmpProductSales(ProductID,...

Are you trying to insert into the first temp table filling the gaps?

Because if you're simply trying to insert unique numbers, you can get the max value from the original...

And if you want to get really confused, then, without an IDENTITY setting on the column, when the table is empty, the MAX value should be NULL. I'll bet that's...

Great. Glad to hear it. And thanks for posting the success of the suggestion.

So when you say you want to "extract non-generic sql" do you mean that you have stored procedures in your database that you need to pull out or that you...

I didn't have that one on my list. I do now.