Year or Datepart versus Table with Date Groupings

If you've an index on date field and use a range query on it , performance will not suffer

see

http://ift.tt/1vdYEBr

---

Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue

Visakh

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

My Wiki User Page

My MSDN Page

My Personal Blog

My Facebook Page