Viewing 15 posts - 781 through 795 (of 1,127 total)
I could still do a manual failover right?
December 20, 2010 at 2:57 pm
try this http://www.sqlservercentral.com/articles/Administration/2960/..might be helpfull
December 8, 2010 at 8:37 am
Adiga (12/7/2010)
The Service Pack copies new binaries and replaces the existing ones. After that is done, it executes certain scripts to update the system dbs/objects.
Really? I didnt know that. So...
December 7, 2010 at 3:25 pm
Script? No sql-script was applied at all while installing sql updates. However could it be possible some process was accessing sql right when i was installing SP3?
December 7, 2010 at 11:06 am
Pradeep thanks for the reply. The error which i have posted is from the log folder. Thanks
December 7, 2010 at 8:39 am
GilaMonster (12/6/2010)
Which events are you tracing?
I have attached the script. Gail this is so frustrating, i have my trace and then i want to run index tuning advisor against the...
December 6, 2010 at 3:13 pm
GilaMonster (12/6/2010)
To get the exec plan you'll need profiler. I believe it's the statistics XML event.http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/
Thanks. I am able to see now but the plan or trace is not showing...
December 6, 2010 at 2:00 pm
dropping/recreating indexes on the table and then shrinking datafile worked. Thanks everyone.!!
December 6, 2010 at 8:58 am
Brandie Tarvin (12/3/2010)
sqldba_icon (12/2/2010)
John Mitchell-245523 (12/2/2010)
It could be that deleting the column freed a certain amount of space on each data...
December 3, 2010 at 8:19 am
Suresh B. (12/1/2010)
Try
DBCC CLEANTABLEHope this helps you.
Thanks Suresh. Theoritically it seems like it will work. I ran DBCC CLEANTABLE (Test_db,"dbo.Mytable") and took 7 hours and is still running. Mytable is...
December 2, 2010 at 7:41 pm
John Mitchell-245523 (12/2/2010)
It could be that deleting the column freed a certain amount of space on each data page, but that...
December 2, 2010 at 3:49 pm
Viewing 15 posts - 781 through 795 (of 1,127 total)