I got your Partition right here >>>

I've concurred my SQL issues regarding performance and partitioning. I've got 2 years to implement the sliding window now. NOTE: When accessing data in the partitions, yes be sure to include the partitioned column, BUT, if your column is a date like most, use BETWEEN rather than DATEDIFF. I had a rough time trying to figure out why a query plan was not using my covering index.

TTFN

Comments :

0 comments to “I got your Partition right here >>>”