Cadavre,

i used your solution without converting into date time. I needed the comments around the performance and few alternative ways. thanks for your help.

thats perfect way of testing the alternative code. thanks a lot.

Also try creating calendar table in your database which is handy if you need to use lot of date criteria. I use when i need to do cross apply when...

Please see second article in lynn's signature. I've seen many times experts are asking to provide detail in that format but most of the people ask questions without much detail....

I've seen this question following the clarification of physical and logical ordering so i got it right. I am sure i must have answered it wrong before few days. Good...

thanks gail, i understood this from our previous posts. People are still referencing this as physical order.

Point taken. thanks gail.

this sentence clarified lot of things for me.

40371 seeks requires at least 80742 page reads (and that's assuming the index been seeked is only 2 levels deep). Reading 4,367,682...

again the confusion is if clustered index puts the data in the physical order?

Just to clarify something for my knowledge, i thought CTE can be replacement of temp tables. I've started using CTEs and it is useful in terms of code readability, finding...

thanks you. that makes more sense as it is not going to take more space then default ROWID (8 bytes).

if there are more records with the same date in the table, can i create clustered index on that field?

We have 5 years records and the same day have few...

thanks all for your comments.

As i said i do understand how the table is structured with the index but i am still bit confused.

I have a table which doesnt have...

Steve, Gail,

I always assumed that clustered index put the data in the physical order in the table.

------------------------------------------------------------------------------------------------------------

Again according to this article here it says following:

http://www.sql-server-performance.com/2007/clustered-indexes/

Here are some...

Hi Drew,

I've unique key but it is combination of different fields and looks like this:

200102_00001407BFFFDCD0F3DFCE2D2B8301ED_200102_1_1

It is unique but do you think we can make this clustered index? it will take...