This may be way off what you are looking for in a answer, but have you thought about horizntally partitioning that table?

I always thought (nolock) was a default setting for select statements, but Everyone and I mean "Everyone" writing a select statement at MS uses no lock. Not...

yeah im just Dash trash ATM(contractor), its very hard to break into actual DBA work so right now im a analyst there, but I think the experience will...

Hi All,

Im sorry my cable went down so I wasnt able to participate further in this discussion Till today.

So I talked to my manager about what his solution to...

I am wondering the more I think of it,that perhaps this is what he was trying to move me towards, Lets say:

Select *

From dbo.customers

Would that plan be cached?...