Viewing 15 posts - 3,241 through 3,255 (of 6,676 total)
SQL Server 2005 RTM required SSIS to be installed to use the maintenance plan feature. As of service pack 1, that requirement was removed.
It sounds like you have not...
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
May 9, 2011 at 2:15 pm
Tony,
Gail stated exactly what I would have stated - but better. 🙂
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
May 7, 2011 at 6:56 pm
WebTechie38 (5/6/2011)
1) Does a differential backup
2) Sets the recovery model to simple
3) Checks integrity
4) Reindexes
5) Checks integrity again
6) Sets the recovery model to full
7)...
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
May 6, 2011 at 5:39 pm
SELECT ...
FROM table1 t1
CROSS APPLY (SELECT max(timestamp) As t2MaxTimestamp FROM table2 t WHERE t.logid = t1.logid) t2
CROSS APPLY (SELECT max(timestamp) As t3MaxTimestamp FROM table3 t WHERE t.logid = t1.logid) t3
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
May 5, 2011 at 8:15 pm
That is correct - let SSRS do the work for you. In most cases, it is just as efficient to allow SSRS to format that data - in fact,...
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
May 5, 2011 at 2:02 pm
Looking at how you have this set up - what I see is this:
On failure, execute Notify Operator Task 1.
On success, execute Notify Operator Task 3.
So far, so good -...
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
May 5, 2011 at 1:54 pm
Another option (requires Enterprise Edition) would be database mirroring. Once you have that set up, you would create a database snapshot of the mirrored database and run your reports...
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
May 4, 2011 at 5:08 pm
bimplebean (5/4/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
May 4, 2011 at 4:53 pm
I have to agree with Craig here, well - sort of. SSIS is not going to be the right tool, but I also don't think replication is what you...
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
May 4, 2011 at 4:47 pm
Are you doing a full refresh of every table - every time? Are there any additional transformations on the data being performed?
If this is a straight copy of the...
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
May 4, 2011 at 3:55 pm
ByTheWestway (5/4/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
May 4, 2011 at 3:33 pm
Here are the 2 blogs where I first saw this as a possible issue:
http://www.sqlskills.com/BLOGS/BOBB/category/SQL-Server-Schemas.aspx
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
May 4, 2011 at 12:48 pm
Maybe I am missing something here - but I don't think you need a 0 based tally table (perm) to make this work. If you change the following:
cteTally(N) AS...
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
May 4, 2011 at 12:22 pm
You might not even need to do that - depending on how long ago the changes were made and how much data is kept in the default trace.
You can run...
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
May 3, 2011 at 8:16 pm
Is this stored procedure called by different users? And, are all objects referenced in the stored procedure at least schema qualified?
This could be a case where the procedure is...
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
May 3, 2011 at 2:41 pm
Viewing 15 posts - 3,241 through 3,255 (of 6,676 total)