Viewing 15 posts - 5,416 through 5,430 (of 6,676 total)
Yes, your assumption is correct - the transaction log file will not shrink just because you back it up. To make the file smaller, you have to explicitly shrink...
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 13, 2009 at 11:44 am
Maintenance plans are only available on SQL Server 2005 and greater. Looks like you are connecting to a SQL Server 2000 system.
Try opening the Legacy folder and see if...
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 13, 2009 at 11:12 am
The error that you received is one of the known issues with using the NOLOCK hint on a query. The only real fix is to rewrite the query without...
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 13, 2009 at 10:48 am
What is the return code being returned from your perl script? If it is not a 0 for success, which is what SQL Server Agent expects, it is going...
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 13, 2009 at 10:40 am
glad it worked - thanks for the feedback.
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, 2009 at 11:07 pm
trans54 (4/12/2009)
How i can convert the following string to the datetime type?
'20081228012320'
I am able to convert but only when i get date in...
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, 2009 at 6:23 pm
Paul White (4/12/2009)
It's also possible to read all possible data into XML and run an XQuery... :-D/P
Paul - I'd quit now while I still had the chance 😀
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, 2009 at 9:42 am
Be careful with the synonym approach - it can only work if all queries using the procedure will use the current month table. If some look to different months,...
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, 2009 at 8:19 am
I would take the discussion out of the religious war on the evils of using NULL and place it firmly in the area of data integrity.
It is not so much...
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, 2009 at 12:35 pm
Jack Corbett (4/10/2009)This is one of my favorite things. That and the accountants not locking their PC's when they go to meetings or lunch.
This is only a problem 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 10, 2009 at 9:40 pm
Boolean_z (4/10/2009)
same here...Its not going to hurt the server performance either.
Unless someone decides to run a query on the server and return millions of very large rows. I...
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 10, 2009 at 12:58 pm
There doesn't appear to be any issue to be fixed. As has been noted in several articles and forum posts, Task Manager on 32-bit systems does not accurately report...
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 10, 2009 at 12:56 pm
I have to agree with Gail on this one - this should be done in the report, and could be done easily at 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 10, 2009 at 12:40 pm
When the database is in simple recovery model, the transaction log won't be truncated until a checkpoint occurs. So, just issuing the commit transaction will not truncate the log.
Add...
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 10, 2009 at 12:20 pm
We also install the client tools on the server. It does not hurt anything, but when you need to do something and your PC is not available (with 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 10, 2009 at 11:25 am
Viewing 15 posts - 5,416 through 5,430 (of 6,676 total)