Viewing 7 posts - 16 through 22 (of 22 total)
Still wondering why an insert select is slower than a select into -- why don't they do the same thing? I wish there were a way to turn off...
June 24, 2015 at 10:06 am
Finally partitioned the table by date. I was hoping it would be faster since the clustered index didn't have the GUID in it but it took slightly longer. ...
June 18, 2015 at 8:13 pm
Jeff Moden (6/18/2015)My partitioning is auto-magic each month. All you have to do is write a relatively simple proc to do it.
That's what I'm trying to do but so...
June 18, 2015 at 4:40 pm
sgmunson (6/18/2015)I don't know the details of exactly how they work, but isn't this what a "partition function" is for?
Yes, except as far as I can see you must define...
June 18, 2015 at 9:57 am
Jeff Moden (6/17/2015)
June 18, 2015 at 9:33 am
Jeff Moden
June 17, 2015 at 11:07 pm
I tested trace flag 610 and it runs over 6 times faster than the tablock option. (It was 3 times faster when I still had the tablock option in...
June 17, 2015 at 5:58 pm
Viewing 7 posts - 16 through 22 (of 22 total)