Viewing 15 posts - 4,801 through 4,815 (of 6,676 total)
John Rowan (7/21/2009)
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
July 21, 2009 at 2:36 pm
Differential backups are cumulative - in other words, they contain all of the changes in the database since the last full backup.
In your case, I would expect to find a...
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
July 21, 2009 at 1:57 pm
On x64 systems, it is highly recommended that you set a max memory setting. If you don't, then it is likely that SQL Server will take all 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
July 21, 2009 at 1:53 pm
I would have done the following:
SELECT * FROM #tempa
EXCEPT SELECT * FROM #tempb;
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
July 21, 2009 at 1:43 pm
This issue was first reported here: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177
And, fixed here: http://support.microsoft.com/kb/919611/
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
July 21, 2009 at 1:39 pm
How many instances do you have in the cluster? When you apply a hotfix for SQL Server 2005 in a cluster, all nodes are updated for the specified instance.
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
July 21, 2009 at 1:25 pm
PaulB (7/20/2009)
Slick84 (7/20/2009)
Would the inserts go first or the updates?
Two questions...
1- Are we talking about a small OLTP alike transaction OR are we talking about a large ETL alike transaction?
2-...
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
July 20, 2009 at 3:40 pm
I would handle it using transactions. Whether that was in a try/catch block or not would depend on what was being done.
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
July 20, 2009 at 3:30 pm
I would perform updates first, then inserts. If you perform inserts first, then you are going to update the rows that were just inserted - which is just a...
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
July 20, 2009 at 2:41 pm
2147483647 in mb
What does this mean ?
Hint: 1024MB = 1GB, 10240 = 10GB and 102400 = 100GB. So, what does that number really mean?
Does it mean that 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
July 19, 2009 at 4:33 pm
You still need to identify what is writing to the model database. The transaction log will not grow unless there is activity being performed in the database. 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
July 17, 2009 at 2:09 pm
Jason Shadonix (7/17/2009)
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
July 17, 2009 at 12:48 pm
We should also take a look in the transaction log to see what transactions are being execute - but, that is going to be a lot of data to search...
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
July 17, 2009 at 12:39 pm
There is definitely something filing into the model database. Run the following to see if there are any user objects in this database:
Use model;
Select *
From sys.objects o
...
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
July 17, 2009 at 12:27 pm
Well, the only other thing I think it could be is that the operator is not set to the right email address. Try executing sp_notify_operator to test the operator...
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
July 16, 2009 at 9:22 am
Viewing 15 posts - 4,801 through 4,815 (of 6,676 total)