Viewing 15 posts - 3,286 through 3,300 (of 6,676 total)
Just to be clear - rebuilding indexes is causing the database to grow, then you shrink the database which is causing the indexes to become fragmented.
Then, you rebuild...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 12, 2011 at 2:58 pm
rebuild does an update stats as well. reorg doesn't touch the stats
A little clarification...an index rebuild will update index statistics with a full scan. Column statistics are not updated....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 12, 2011 at 2:52 pm
Okay, now we will need to see how you are using this view - and the execution plan. With that said, I see a couple of issues right away:
1)...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 12, 2011 at 11:26 am
After reading Gail's article on catch all queries - you should also review Erland's article on dynamic SQL.
Whether or not you decide to go with dynamic SQL, a catch all...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 12, 2011 at 11:14 am
Perry Whittle (4/12/2011)
no need to take a FULL backup here to restart the log chain, a DIFFERENTIAL will suffice and allow subsequent transaction log backups
This is true, but the log...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 12, 2011 at 7:25 am
You should review the following article by Erland: http://www.sommarskog.se/dyn-search-2005.html
It goes through the various different options of writing dynamic queries for searching. Most likely, the best option for this would...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2011 at 9:20 pm
You need to post the definition of the view, and probably the definition of the tables and indexes - with some sample data, and the query you are using that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2011 at 9:13 pm
If the SQL Server agent job is owned by a member of the sysadmin role, it will run in the context of the service itself.
On Windows Server 2008...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2011 at 9:02 pm
GilaMonster (4/11/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2011 at 2:39 pm
You do not need to run both a rebuild and a reorganize task - unless you are selecting different indexes for each task.
The failure you are getting is caused when...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2011 at 2:32 pm
I am not sure what you mean by stopped working - did you check the maintenance plan history, job history, agent logs and sql server logs?
Any errors or issues showing...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2011 at 11:12 am
annasql (4/8/2011)
So if there is no tie in, then if we use that domain account which run sql agent service for other purpose for...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2011 at 11:08 am
WayneS (4/8/2011)
One thing to keep in mind - if you create scheduled maintenance plans, the jobs it creates are owned by the person creating the MP.
I handle this by updating...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 8, 2011 at 3:06 pm
Tara, it looks like you are missing a few things in the code. It is hard to tell if there is any way to optimize this without seeing all...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 7, 2011 at 3:40 pm
rabisco (4/7/2011)
Ken McKelvey (4/7/2011)
Something like the following:
DELETE docBodyVersion
WHERE EXISTS
(
SELECT *
FROM...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 7, 2011 at 3:28 pm
Viewing 15 posts - 3,286 through 3,300 (of 6,676 total)