Viewing 15 posts - 3,436 through 3,450 (of 7,503 total)
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 ......
September 28, 2009 at 7:43 am
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...
September 28, 2009 at 1:26 am
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...
September 28, 2009 at 12:22 am
Thank you for the refs, Dale.
I'll try them next week.
Johan
September 25, 2009 at 2:39 pm
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...
September 24, 2009 at 10:27 am
- 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...
September 24, 2009 at 7:35 am
PhilM99 (9/24/2009)
OK, if I do this am I on the right track?:
1) Manually:
Set recovery model to Full
Do a...
September 24, 2009 at 6:38 am
...
Should I set the recovery model to FULL?
If you want to be able to perform point in time restores, you should set it to full recovery mode.
Should I continue to...
September 24, 2009 at 4:00 am
Sunil Kanta (9/24/2009)
But, what for Non-Clustered Composite Index? I...
September 24, 2009 at 2:25 am
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...
September 24, 2009 at 1:14 am
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...
September 23, 2009 at 7:40 am
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"...
September 23, 2009 at 2:59 am
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,...
September 23, 2009 at 2:52 am
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.
September 23, 2009 at 2:46 am
Lynn Pettis (9/22/2009)
... I was so busy looking at the routine itself and comparing it to that other one, I didn't even consider tuning mine more.
Just hopping in 😉
The...
September 23, 2009 at 1:23 am
Viewing 15 posts - 3,436 through 3,450 (of 7,503 total)