Grant Fritchey (9/27/2011)

---

Tim Walker. (9/27/2011)

---

I started this thread more than a year ago now. Thanks very much for the replies to date.

We're now about to kick off another round of...

I started this thread more than a year ago now. Thanks very much for the replies to date.

We're now about to kick off another round of evaluation (partly using Redgate...

Thanks for the feedback Grant, it's appeciated. Also good to know that RedGate are bought into SQL Azure (I suppose you should be given how Microsoft are positioning it!)

Grant Fritchey...

Steve and Ray,

Sorry for the delayed response (I've been on holiday).

Thanks for the feedback. I was hoping there might be an easy way to check, but I guess I can...

Michael that's a very fair point.

Don't get me wrong. For some things I can see it would be great. Ticketing applications are the obvious example where the latest hot thing...

Thanks for the link Steve.

I agree that cost is a barrier, but I don't think it was the main barrier for me.

What I didn't like was that it's not...

Janie.Carlisle (5/19/2011)

---

Will that create all the tables from one database to another? I need to do a bunch of test scripts and bring in the new data using new packages...

Thanks Carl!

I have reviewed the article, and this appears to be exactly what has happened. I can track through the messages in the log as described over a nine minute...

Thanks for the feedback GSquared. One thing I should have added was that the performance issues reported to me are on the same server but different databases. So I'm wondering...

The same principle 'probably' applies

i.e. Create table and clustered index, populate IN CLUSTERED INDEX ORDER, create additional indexes

But...

(1) With this much data you may well be sorting it first...

Which is why I said 'BE CAREFUL'.

Clearly using the script in the wrong circumstances could get you fired!

In the general options, click 'Script Drop' which is false by default.

I think this will do what you want.

My preference, if this is possible to do in your scenario, is:

1. Create table and unique clustered index

2. Insert data IN ORDER OF CLUSTERED INDEX

3. Create non clustered indexes

This way,...

Sorry, previous post lost the last bit.

-- Tables with foreign key constraints acting on them must be deleted

SELECT

'DELETE FROM ['+name+']'

FROM

sysobjects

WHERE

xtype = 'U'

AND name NOT...

Running this will create a script to do it.

It works in 2008 but yes, I know it is deprecated code - I presume the OP just wants something to use...