Viewing 15 posts - 3,556 through 3,570 (of 7,164 total)
GilaMonster (7/17/2012)
I'd add updating the non-index statistics to that, currently it only updates the stats on the indexes that get rebuilt.
I noticed that too and forgot to mention it. I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2012 at 12:26 pm
I like that you set the DB to SIMPLE recovery before rebuilding indexes but I am wondering why you are freeing proc cache and dropping clean buffers? If you're restoring...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2012 at 11:49 am
What you are running into is a broken Ownership Chain. By default Ownership Chains cannot continue across database boundaries. Your initial assertion about only granting permissions to the VIEW being...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2012 at 11:04 am
Daxesh Patel (7/17/2012)
and now I am not able to connect from my local machine.
Not sure about diffrence between "restart" and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2012 at 10:22 am
Excellent, thanks for confirming that the SID did not change. That is useful info. So to recap, after renaming an AD account that was part of an AD group setup...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2012 at 8:19 am
I would recommend a slightly different approach. Setup an Event Handler at the Package level for the OnPreExecute Event and add a Script Task to the Event Handler that will...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 3:47 pm
lawson2305 (7/16/2012)
Is there a command to change the recovery model on the fly.
Considerations for Switching from the Full or Bulk-Logged Recovery Model
In the article they show the ALTER DATABASE commands...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 3:10 pm
lawson2305 (7/16/2012)
I changed the daily code to run:USE [ActivplantDB]
GO
DBCC SHRINKFILE (N'ActivplantDB_Log' , 0, TRUNCATEONLY)
GO
Shrinking to 0 is not a good approach no matter what your situation. Growing a log file...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 2:58 pm
lawson2305 (7/16/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 2:51 pm
lawson2305 (7/16/2012)
this maintenance.sql what does it do?
You do not have to install the Maintenance package he provides but it is turnkey so if you're having trouble with backups and checkdb...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 2:49 pm
Maxime.Gagne (7/16/2012)
The connection string of the OLEDB Component of the Index Rebuild Task had been hardcoded to our...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 2:41 pm
lawson2305 (7/16/2012)
in the plan...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 2:37 pm
lawson2305 (7/16/2012)
opc.three (7/16/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 2:13 pm
I assume you have autogrow enabled on your log file. Check the default trace to see when it grew, that can help establishing a timeframe of when the log bloat...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 1:26 pm
lawson2305 (7/16/2012)
I run a tran backup and shrink every day. I append the backup daily except...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 16, 2012 at 1:23 pm
Viewing 15 posts - 3,556 through 3,570 (of 7,164 total)