I find that the dateadd/datediff method is the most convenient way to code for these sorts for problems. Once you understand what it is doing, it is very intuitive...

This should do what you want.

SELECT

*,

DateRecorded AS Expr1

FROM

tbl_ISALOG_SingleUser

WHERE

DateRecorded < dateadd(day,datediff(day,0,getdate())-3,0)

Phil Factor (12/31/2007)

---

[font="Courier New"]--1) How to find out the current month's first Date ?

SELECT CONVERT(DATETIME,'01 '+RIGHT(CONVERT(CHAR(11),GETDATE(),113),8))

--2) How to find out the current month's Last Date ?

SELECT DATEADD(DAY,-1,'01 '+RIGHT(CONVERT(CHAR(11),DATEADD(MONTH,1,GETDATE()),113),8))

--3) How to...

You must...

You can use the function on this link to generate up to 16,777,216 rows at a time for any valid datatype integer range.

I recommend that you do not insert more...

I would recommend that you do transaction log backups much more often; every 15 minutes 24x7 is a good starting point. If your transaction volume is really high, you...

You can use a default value like this:

datename(month,getdate())+' '+

convert(varchar(2),day(getdate()))+', '+

convert(varchar(4),year(getdate()))

This will do it.

select

FirstOfThisMonth =

dateadd(month,datediff(month,0,getdate()),0),

LastOfThisMonth =

dateadd(month,datediff(month,-1,getdate()),-1),

FirstOfLastMonth =

dateadd(month,datediff(month,0,getdate())-1,0),

LastOfLastMonth =

dateadd(month,datediff(month,-1,getdate())-1,-1),

FirstOfNextMonth =

dateadd(month,datediff(month,0,getdate())+1,0),

LastOfNextMonth =

dateadd(month,datediff(month,-1,getdate())+1,-1)

Start of Time Period Functions:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64755

Start of Week Function:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307

End Date of Time Period Functions:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64759

End of Week Function:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64760

You should read about collations in SQL Server Books Online.

Set the collation of the PK column to a case sensitive collation.

This script gives you a number of ways to analyze space usage on a server:

File Details

Total by Database and File

Total by Database and Filegroup

Total by Database and Filegroup Type

Total by...

You can only shrink a database file if it has free space. The script below will give you that information.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

This works on 7.0, 2000, and 2005

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

Carla Wilson (12/11/2007)

---

I did work on a database where we had a table with jut one row, to hold the company's billing address, phone number, primary contact name, contact email,...

Barry McConnell (12/11/2007)

---

Classic confusion of keys vs. indices. The purpose of a PK is to provide referential integrity; access is provided by an index. One simple case where a PK...