Yes, the row ID is sequential within the week, so I could definitely try that. I'd like to think it would then have no choice other than to use the...

-

Ninja's_RGR'us (5/27/2010)

---

Well even if you only delete 1 week of data that equates to roughly 2% of the data in the table. With that much data, a scan will...

I updated the statistics just to be sure, and it didn't change anything.

It does use the CI if I hardcode the date instead of using a variable. But, in practice,...

Please post in the 2008 forum. This forum is for 7 and 2000, which don't have partitioning. Thanks.

This was related to my other thread... 🙂

I've resolved this also. I removed access for BUILTIN\Administrators to lock down the box from my IT/hosting people. I then created a new...

I resolved it, but I haven't a clue as to why. It wasn't a typo; Enterprise Manager won't let you create a login with Windows authentication if the Windows account...

I just did an UPDATE STATISTICS on the table, and that fixed this. So I don't need help.

What I could still use, though, is an explanation why this fixed it,...

Well I think I figured it out, on my own.

I made my new table the source of a subform, and then bound the appropriate column between the parent form and...

Well for the most part, with my forms, I'm just using the form and control properties and setting row and control sources. Even in VBA form events, I try...

Beautiful. Thank you!!

Index on (id, date)

I just discovered that using the NOEXPAND hint on the view makes this work as I expected. Is this always a requirement? (It would be news to me...

Yep--my clustered index is on the same 2 columns as the PK.

GilaMonster (4/24/2008)

---

When it does a 2-column seek, the 2 columns are matched in a single operation. Again using the above example,

WHERE Colour = @x and Age = @y

does...