Date range question. 2

[sparkbyte]

Which query would be better??

Select Tracking_ID, EmployeeID, MachineName, BoxNumber, FileNumber, TrackingDate
FROM tblTrackingTable

WHERE     (TrackingDate BETWEEN DATEADD(dd, DATEDIFF(dd, 0, CURRENT_TIMESTAMP), 0) AND CURRENT_TIMESTAMP)

AND			FileNumber NOT LIKE '.box.end.'

ORDER BY	TrackingDate DESC

Number of SELECT statements 1 1.0000
Rows returned by SELECT statements 107 107.0000
Number of server roundtrips 1 1.0000
Bytes sent from client 600 600.0000
Bytes received from server 13310 13310.0000
Client processing time 31 31.0000
Total execution time 1546 1546.0000
Wait time on server replies 1515 1515.0000

OR

DECLARE @Today DATETIME
SET @Today = GETDATE()

-- Remove the time element
SET  @Today = DATEDIFF(DAY, 0, @Today)

Select 
	  Tracking_ID
	, EmployeeID
	, MachineName
	, BoxNumber
	, FileNumber
	, TrackingDate
FROM	tblTrackingTable
WHERE	TrackingDate >= @Today
AND		TrackingDate < @Today + 1
AND		FileNumber NOT LIKE '.box.end.'
ORDER BY	TrackingDate

Number of SELECT statements 4 4.0000
Rows returned by SELECT statements 110 110.0000
Number of server roundtrips 3 3.0000
Bytes sent from client 914 914.0000
Bytes received from server 31722 31722.0000
Client processing time 32 32.0000
Total execution time 1578 1578.0000
Wait time on server replies 1546 1546.0000

This table will grow on average of 10k to 20k rows per day.


Thanks

John Fuhrman

 

[sparkbyte]

Thanks Mark!!

Thanks

John Fuhrman

 

[sparkbyte]

Found this at the end of the comments on his blog.

http://www.onetooneinteractive.com/...an-update-of-my-sql-server-bad-habits-series/

Thanks

John Fuhrman