Viewing 15 posts - 14,986 through 15,000 (of 59,063 total)
As of...
May 19, 2017 at 6:50 pm
To be honest, using a scalar function here is a bit insane not to mention how complex it's been made. Like Perry...
May 19, 2017 at 6:16 am
And another here...
http://sqlhints.com/2013/04/14/sequence-in-sql-server-2012/
May 19, 2017 at 5:49 am
Michael L John - Thursday, May 18, 2017 2:48 PMAnyone else ever do this?
https://www.sqlshack.com/how-to-spoof-production-environment-resources-for-performance-tuning/#.WRr9Do_GEfw.linkedinLooks rather interesting...
I've not heard of it...
May 18, 2017 at 7:05 pm
If you use a "sequence" object instead of an IDENTITY, there will be no need for a dynamic Temp Table nor even a need to determine what the next sequence...
May 18, 2017 at 4:09 pm
Phil, the link in your first paragraph isn't working. It's pointed at some "C:" drive file somewhere.
May 17, 2017 at 6:04 am
With no reflection on the OP because he's the poor consumer of this data and not the perpetrator... you just have to wonder what the heck is on people's minds...
May 17, 2017 at 6:00 am
May 17, 2017 at 5:33 am
May 16, 2017 at 9:49 am
May 16, 2017 at 2:47 am
If you run In a transaction without committing, yes
Try it for yourself
I can't think...
May 15, 2017 at 7:57 pm
May 15, 2017 at 6:45 pm
May 15, 2017 at 6:34 pm
May 15, 2017 at 9:57 am
Viewing 15 posts - 14,986 through 15,000 (of 59,063 total)