How do you know the number of page results?

What option did you select for the search and where did you enter that search?

What search did you enter adn with which options?

You might be interested by this thread :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=189202

So how did the identity solution turned out??

Start with this part >>

Do you have the before and after execution plans?

It could become usefull.

I'll shut up now before I put my foot too far in my mouth. I'll leave this one to the backup experts.

How does that [not] affect the statistics??

Every delete must be placed in the log which longer than to insert only half that amount of data in a new table and rename it.

What changes did you look at to affirm that??

Also yes those are the stats I'm reffering to.

Do you have the before and after execution plans?

Did you try to simply update the stats (maybe with a deeper scan).

Good... another hacker playground is born. Don't forget to update your resume cause that'll be your fault if the server gets destroyed or data stolen.

Ya I got one... didn't you notice I'm posting less lately??

The ;1 part is the be able to have any number of live versions of the stored procs under the same name. I think you'll either have to redo...

Looks like I read too fast .

Maybe I should have written, I'll go as far as saying to same thing as ten centuries

Forget the sysObjects table. This is just for a demo that'll work on any server.

The select will look something like this :

Select @Drivers = @Drivers + Name +...