Viewing 15 posts - 3,256 through 3,270 (of 6,676 total)
Is SQL Server Agent running under the same service account? Was that account added separately to SQL Server and granted sysadmin, or are you relying on group membership?
Do 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 2, 2011 at 8:20 pm
I probably would have just set the format on the text box itself, instead of using an expression. The formula would be the same.
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 29, 2011 at 3:05 pm
The way you implement parameters will be slightly different, depending on where the code for the report sits. If the code is embedded in the report - then 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
April 29, 2011 at 2:59 pm
QQ-485619 (4/29/2011)
Error 30002: Type 'DirectoryInfo' is 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
April 29, 2011 at 2:54 pm
You can add additional filtering to the statement after the cte. In your case, you need to identify the criteria that determines that you have reached the appropriate management...
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 29, 2011 at 2:51 pm
You can use a script task in SSIS and use something like the following:
' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain class...
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 29, 2011 at 11:34 am
SQLMyFriend (4/26/2011)
"I would probably not do that - instead, I would use proxy accounts to grant the appropriate rights needed for each...
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 26, 2011 at 8:01 pm
TheSQLGuru (4/26/2011)
I actually think ApexSQL's Log product might be able to unwind or redo transactions given your scenario. Tell them TheSQLGuru sent you.
Just to be clear - if 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 26, 2011 at 2:24 pm
Review this article: http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/
I would also recommend that you review the discussion that follows that article.
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 25, 2011 at 5:26 pm
This is usually an indication of a bad execution plan for the parameters being run from the application. Recompiling the procedure and then running with the same parameters generates...
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 22, 2011 at 3:36 pm
I prefer using ALTER DATABASE ... MODIFY FILE to move database files. This method preserves the database ownership and does not require a detach/attach of the database.
The first step...
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 22, 2011 at 10:08 am
It sounds like you may have hyper-threading enabled on those cores. If so, try disabling the hyper-threading and see if that helps performance.
The reason I say this is 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 22, 2011 at 10:01 am
I can't really answer all of your questions, but just to clarify about your mirroring. The mirroring state will not go to suspended unless someone is issuing a command...
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 18, 2011 at 10:12 am
Probably not - what you really need to do on your laptop, if it is causing you issues is to set a reasonable max memory for that instance. 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 17, 2011 at 8:04 pm
Chrissy321 (4/14/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 14, 2011 at 5:48 pm
Viewing 15 posts - 3,256 through 3,270 (of 6,676 total)