Unless you capture plan cache, you have no means of history !

And if thing start going bad, it may go steep downhill !

Bad design (view on view, ..) probably ......

Works like a charm.

Thanks for the tip Starunit. :smooooth:

Keep in mind, that with every hotfix / servicepack, this needs to be rechecked (composition of the xml as well as the...

Nice feedback Jack.

Keep in mind 24h don't make a week, month , year 🙂

Did you trace on the same weekday as when you detected the growth ?

Well, it is a...

Thank you for the refs, Dale.

I'll try them next week.

Johan

did you try this in query analyser ?

alter table yourtable

add SurrogateId int identity(1,1) not null primary key

This should add the wanted column as well as the PK constraint (clustered by...

- SQL2005 introduced the OUTPUT clause. You could use that to do what you intend to.

- Why don't your perform a direct update of T2 ?

DECLARE @opt table (thecol int)

UPDATE...

PhilM99 (9/24/2009)

---

Thanks to Silverfox and ALZDBA for the quick replies!

OK, if I do this am I on the right track?:

1) Manually:

Set recovery model to Full

Do a...

If you want to be able to perform point in time restores, you should set it to full recovery mode.

Should I continue to...

Sunil Kanta (9/24/2009)

---

Exactly, I could later manage to reorder for PK index. And I did this only because i got a error while moving.

But, what for Non-Clustered Composite Index? I...

Apparently the index you tried to move was the one supporting the primary key of your table.

That index must 100% match your tables PK definition.

Altering that column sequence results in...

HTH

Just keep in mind, by switching to simple recovery, you can nolonger perform point in time recoveries !

You should revise your DRP for that db because you may need to...

another option is to move your table to its own database and then create database snapthots at your desire.

Please refer to SQL Server 2005 Books Online topic "Database Snapshots"...

Like Elliott W replied the job will not be automatically resubmitted because of a failover;

However, if the job has an active schedule or is being activated by any other means,...

Please reply at the duplicate thread : http://www.sqlservercentral.com/Forums/Topic792349-146-1.aspx

just because at this moment that thread has more replies.

Thanks.

Just hopping in 😉

The...