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
thank you all too much for your help ! this was very informative and I am sure has pointed me in the correct troubleshoting direction!
2005-05-24
I would do this in some front end scripting language. That's much easier.
2005-05-24
SQL Server 2000 has indexed views, which can greatly improve database performance. However there are a number of restrictions on building the view, including the restriction against outer joins. So how can this work? New author Jean Charles Bulinckx brings us a technique that can help you get around this restriction.
2005-05-19
20,441 reads
how do you view the data on a selected table? in sql 2000 you could do that by selecting the table and right click it then click return all rows.. what is the equivalent of that in sql beta 2005 3? i have a table named user and i want to see the information on […]
2005-05-18
2 reads
Chris has great advice. Be sure that you test under loads to be sure which one might run better.
2005-05-16
DBCC SETINSTANCE is undocumented and basically only the underlying call behind the sp_user_counter procs.
2005-05-03
2005-05-01
I would suggest if the vendor is stating it can then you put the responsibility on the vendor to find and restore the transaction otherwise the user will state the vendor said it can be done and that you are lax in your abilities or not be cooperative. I truely however believe there was no […]
2005-04-30
This script gathers stats_date and index information for all of the current database. Please feel free to modify it as it is made up of components that are available on this site here- http://qa.sqlservercentral.com/scripts/contributions/97.aspand a BOL entry for stats_date.I needed this information and thought I would share it.
2006-07-17 (first published: 2005-04-29)
547 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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