Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
colekata
Starting Member
12 Posts |
 Posted - 2011-08-27 : 20:28:47
|
| Strange problem with date range |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-28 : 01:42:02
|
| is the table partitioned based on date values? do yo have required indexes on table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
colekata
Starting Member
12 Posts |
Posted - 2011-08-28 : 02:55:03
|
| Hello Visakh,Many thanks for your help.I am not an expert in databases and our DBA is on holiday.Could you please let me know how do I fix/index such a huge table?This is a very large table with terabytes of data stored in it. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-28 : 03:13:24
|
| is it partitioned ?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
colekata
Starting Member
12 Posts |
Posted - 2011-08-28 : 08:49:26
|
| Yes it is partitioned. Thanks again. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-08-28 : 12:47:35
|
| And what, specifically, is the problem here?--Gail ShawSQL Server MVP |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-29 : 00:20:03
|
quote:
Originally posted by colekata
Yes it is partitioned. Thanks again.
why did you remove your original question?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Strange problem with date range