Upgrade to SQL Server 2008 and use datetime2.

anders-906993 (10/14/2009)

---

As I wrote, in reality I don't shrink the database to a smaller size, but just forces SQL to reorganize all pages because the database will in most cases...

Next step: Configure SQL Server Agent to use Database Mail.

Right-click SQL Server Agent in the Object Explorer, select properties and setup the alert properties to use Database Mail. Once...

Paul S. Huebner (10/14/2009)

---

To clarify, this log file was sized this way before I became in charge of it. It did not grow to this size on it's own....

krypto69 (10/14/2009)

---

I love this method only because I can leave it in place and it will always get the previous month.

but

when I use

WHERE ld.delq_dt >= DATEADD(month, DATEDIFF(month, 0, CURRENT_TIMESTAMP)...

FreeHansje (10/14/2009)

---

Maybe you could use the ROW_NUMBER() function, something like this:

WITH ResultSet AS (

SELECT ROW_NUMBER() OVER (ORDER BY Column1 )

AS Row, Column1

FROM MyTable)

SELECT *

FROM ResultSet

WHERE Row between 200 and...

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...

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...

This method will prevent the usage of any indexes (if they exist) on the column. In this case, if your...

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...

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...

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...

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...

xxdbxx (10/12/2009)

---

---jocampo

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...

Mani-584606 (10/9/2009)

---

But we do not...