User Profile

Collapse

Profile Sidebar

Collapse
Joseph Caldwell
Joseph Caldwell
Last Activity: Dec 7 '10, 10:02 PM
Joined: Dec 7 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Joseph Caldwell
    replied to Query by date optimization
    in SQL Server
    I am learning data warehousing and analysis services as I am starting to think this may be the best approach.
    See more | Go to post

      Leave a comment:

    • Joseph Caldwell
      started a topic Query by date optimization
      in SQL Server

      Query by date optimization

      Hi
      *Edit* I ran some tests and wanted to edit my question. Basically I just would like to know:

      If I have an date field as part of a multicolumn primary key, would it be best to create a nonclustered index on just the invoice date field?

      There are 760 million records and the result set is one week worth of data - 150,000 records.

      Looking for the best practice. The data is historical and is never...
      See more | Go to post
      No activity results to display
      Show More
      Working...