Using the DATEPART function will not allow the optimizer to use the index on the reortsentdate column so your statement will force a table scan.For more info on how to work with sql server dates you might want to look at these articles: http://www.sql-server-performance.com/fk_datetime.asp http://www.karaszi.com/SQLServer/info_datetime.asp
2005-05-25
OK. Makes perfect sense. Thanks for the 411. I'll take this under advisement and look into scripting more of my tasks whenever possible. LanMan
2005-05-24
I would do this in some front end scripting language. That's much easier.
2005-05-24
Hi, i have a xml file c:\abcd.xml in my local filesystem.. i just want to take the path as in parameter for a stored procedure and insert the values into a table type variable execute usp_xx (@xmlpath='c:\abcd.xml') -- inside the sp i would like to read the xml file and insert the same into […]
2005-05-23
8 reads
Select C.CategoryID, C.name, count(*) as Total from dbo.Category C LEFT OUTER JOIN dbo.Comments CM on C.CategoryID = CM.CategoryID and CM.UserId = @UserId GROUP BY C.CategoryID, C.name ORDER BY C.name
2005-05-20
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers