Viewing 15 posts - 4,486 through 4,500 (of 6,676 total)
Paul S. Huebner (10/14/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
October 14, 2009 at 9:26 am
krypto69 (10/14/2009)
but
when I use
WHERE ld.delq_dt >= DATEADD(month, DATEDIFF(month, 0, CURRENT_TIMESTAMP)...
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
October 14, 2009 at 7:42 am
FreeHansje (10/14/2009)
WITH ResultSet AS (
SELECT ROW_NUMBER() OVER (ORDER BY Column1 )
AS Row, Column1
FROM MyTable)
SELECT *
FROM ResultSet
WHERE Row between 200 and...
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
October 14, 2009 at 7:40 am
Lutz - yes, I meant to put in my response that you had already pointed out this solution. I just wanted to review the concepts for the OP so...
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
October 13, 2009 at 6:37 pm
There really is nothing wrong with having a very large transaction log - but, it really depends on how and why it got that way in the first place.
If 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
October 13, 2009 at 3:20 pm
krypto69 (10/13/2009)
is this wrong?original way:
WHERE
isnull(datediff(dd,ld.delq_dt,getdate()),0) < 30
this:
WHERE
isnull(datediff(dd,ld.delq_dt,'2009-09-30'),0) < 30
This method will prevent the usage of any indexes (if they exist) on the column. In this case, if your...
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
October 13, 2009 at 3:15 pm
How are you going to determine rows 200 through 300? If you only have one column in this table, there is no way you can identify a row 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
October 13, 2009 at 9:37 am
Yes, check the permissions for the mdf/ldf files and grant access back to the Administrator. You will find that the only one who has any permissions to the file...
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
October 12, 2009 at 3:56 pm
In addition to what SilverFox has stated:
Step 3 is only necessary on indexes that have not been rebuilt. If your index was reorganized - then you need to update...
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
October 12, 2009 at 12:09 pm
FYI - when you detach a database from SQL Server 2005 or greater, the file level permissions on the mdf/ldf file are changed to the user to detached the file.
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
October 12, 2009 at 10:40 am
xxdbxx (10/12/2009)
Have you installed the SQL instance on both nodes? You must install each instance you intend to run on every node. If you look on the drive...
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
October 12, 2009 at 9:52 am
Mani-584606 (10/9/2009)
If you have any custom objects in master - the upgrade will keep the compatibility level at 80 and you will have to manually change it.
But we do 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
October 10, 2009 at 12:26 am
Review the documents here:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
Under the Enterprise Manageability section you will find whether or not Express supports Database Mail.
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
October 9, 2009 at 2:03 pm
Check the properties for the cluster group - verify whether or not you have turned on 'Allow Failback'.
We always disable this feature and 'Prevent Failback' on our clusters.
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
October 9, 2009 at 1:31 pm
What node is currently hosting SQL Server and is that the same node you are looking at in Configuration Manager?
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
October 9, 2009 at 1:21 pm
Viewing 15 posts - 4,486 through 4,500 (of 6,676 total)