Viewing 15 posts - 3,001 through 3,015 (of 6,676 total)
Are you logging into the server using a windows administrator account? When you state that SQL Server and SQL Server Agent are running with an administrator account - do...
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
August 20, 2011 at 10:34 am
lance.kentwell (8/20/2011)
SELECT DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0))
2011-07-01 00:00:00.000
I want...
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
August 20, 2011 at 10:28 am
Mike John (8/20/2011)
From what you said in the original post it sounds...
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
August 20, 2011 at 10:21 am
I agree with Ninja...a loop here is one of those cases where it would be appropriate. You could build a dynamic string that includes all of the sp_send_dbmail calls,...
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
August 20, 2011 at 10:06 am
aaron.reese (8/20/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
August 20, 2011 at 9:59 am
GilaMonster (8/20/2011)
The query optimiser costs were times at one point. They were benchmark times on a specific computer in the MS testing...
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
August 20, 2011 at 9:52 am
So, you only want to exclude rows where varA = 1 and varB = 'Green'.
WHERE NOT (varA = 1 AND varB = 'Green')
Assuming that varA and varB are actually columns...
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
August 15, 2011 at 9:01 pm
I am assuming this is on Windows Server 2003 and not on 2008. If you are on 2008 then this may not be correct.
No, the quorom drive does 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
August 15, 2011 at 2:52 pm
Even if you cannot afford SQL Compare now - or convince management of it's usefulness, download the trial edition and use it to synchronize the systems.
Use the tool to generate...
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
August 14, 2011 at 7:42 pm
santhubt (8/13/2011)
Why can't u backup log and then shrink it?
Because the database is mirrored - you cannot access the mirrored database.
If the log file is growing on the mirror, it...
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
August 14, 2011 at 10:00 am
Sorry, misread this...
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
August 13, 2011 at 1:29 am
Welsh Corgi (8/12/2011)
I just thought that this could be a practice exercise in the event of a issue in the future.
I prefer Lightspeed...
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
August 13, 2011 at 1:20 am
Open up the maintenance plan in SSMS - select the maintenance cleanup task and generate the T-SQL. Paste that here and we should be able to see if there...
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
August 9, 2011 at 3:02 pm
GilaMonster (8/9/2011)
Insert in batches or use an insert method that can be minimally logged (and drop any nonclustered indexes before you start)
Don't drop the nonclustered indexes - disable them instead,...
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
August 9, 2011 at 2:50 pm
SwePeso (8/8/2011)
The behaviour change is documented here in Books Onlinehttp://msdn.microsoft.com/en-us/library/ms143359(v=SQL.100).aspx
Interesting - thanks for the link.
Another fix on a previously known bug - that will have some people making changes to...
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
August 8, 2011 at 2:54 pm
Viewing 15 posts - 3,001 through 3,015 (of 6,676 total)