 |
Post Axnzrsnag6GKiewo4G by [email protected] |
 |
More posts by [email protected] |
|
Post #AxnzrsUnnxEXmO9nma by [email protected] |
|
0 likes, 0 repeats |
|
|
|
Buckle up, kids. I'm going to tell a story. A story about the best UPDATE s… |
|
|
|
Post #AxnzrsbXOuca7HJBHU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
Back in 2002/2003 I was part of an application development consulting team work… |
|
|
|
Post #AxnzrshZ2VRSPy7zfs by [email protected] |
|
0 likes, 0 repeats |
|
|
|
Because of the client's niche business model, they needed to extensively cu… |
|
|
|
Post #Axnzrsnag6GKiewo4G by [email protected] |
|
0 likes, 0 repeats |
|
|
|
Most of my colleagues were VB6 jockeys (which was rad and cool back in those da… |
|
|
|
Post #AxnzrsuKH3eN3Y6BZA by [email protected] |
|
0 likes, 0 repeats |
|
|
|
One of the difficult problems we needed to solve was one of maturing leases, be… |
|
|
|
Post #Axnzrt0htKkpNL5HVo by [email protected] |
|
0 likes, 0 repeats |
|
|
|
One of my colleagues built a solution in the custom VB6 UI we were delivering. … |
|
|
|
Post #Axnzrt7RUI8riEEf0i by [email protected] |
|
0 likes, 0 repeats |
|
|
|
The client was delighted. This was a tough nut to crack, and the fact that this… |
|
|
|
Post #AxnzrtEB5FWu37O2Vc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
Why use any complicated set-based SQL stuff when you can write hundreds of line… |
|
|
|
Post #AxnzrtKugCuwO0XQ0W by [email protected] |
|
0 likes, 0 repeats |
|
|
|
Everyone was busy drinking celebratory beers and patting themselves on the back… |
|
|
|
Post #AxnzrtQwJnjoghMEOu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
I did some math and realized that 100,000 x less than two minutes didn't fi… |
|
|
|
Post #AxnzrtXJw4qH0ULKLY by [email protected] |
|
0 likes, 0 repeats |
|
|
|
At this point everyone looked at me and said "so about that set-based nons… |
|
|
|
Post #AxnzrtdhYLwjKHKQIC by [email protected] |
|
0 likes, 0 repeats |
|
|
|
So I sat down and started looking more closely at the problem, and at the datab… |
|
|
|
Post #Axnzrtkn7zcLgGe5LM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
Fortunately I had an awesome project sponsor, and with her support I was able t… |
|
|
|
Post #AxnzrtrshdHy2FxkOW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
I spent almost a week writing and testing a stored procedure that would be the … |
|
|
|
Post #AxnzrtzKFxFAPLRgzw by [email protected] |
|
0 likes, 0 repeats |
|
|
|
After 20 years I have no idea what does what, but I still remember the rush of … |
|
|
|
Post #Axnzru6PpaumlKlM36 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
But would it meet the performance requirements? Would this stored procedure be … |
|
|
|
Post #AxnzruC5UVS52vPstE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
The answer, of course, was yes. Set-based processing so close to the data was a… |
|
|
|
Post #AxnzruIT6mYXMiOyps by [email protected] |
|
0 likes, 0 repeats |
|
|
|
The actual execution time, however, surprised everyone - including me.When depl… |
|
|
|
Post #AxnzruPYgQE9ihidt2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
I'd like to say I wasn't an insufferable git during the team retrospect… |
|
|
|
Post #AxnzruWIHNcC3as1Nw by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@SQLAllFather how often did you need to remind them, that you did say that you … |
|
|
|
Post #AxnzrubxwI9ULBWYE4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@TheConstructor The company we worked for went under not too long after, so I d… |
|
|
|
Post #Axnzsl8Mf4xvEj59we by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@SQLAllFather because your colleagues celebrated their VB6 data-processing when… |
|
|
|
Post #AxnzuowlSLk3dodhdQ by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@SQLAllFather this is epic (as my children tell me - the new rad term?). I so … |
|
|
|
Post #Axnzup394cqVxbcna4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@StephenWotton Yeah, but Brent won't really commit, so can we take his word… |
|
|
|
Post #Axnzuxgmx7JIksEZU0 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@SQLAllFather haha top picture. Always seems like a bloke who would be fun down… |
|
|
|
Post #Axnzv2uRXmCgwff2xc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@SQLAllFather That's a wiiiiide query. |
|
|
|
Post #Axnzv30pA3J9GSe8uG by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Sqlgene It's probably the single most complex SQL statement I've ever … |
|
|
|
Post #Axnzv38GiNGLdY85Vg by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@SQLAllFather Mine was a doubly nested cursor for Dynamics Great Plains data. B… |
|
|
|
Post #Axnzv3EILy5DwEwtu4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Sqlgene 🎵 We don't talk about cursors 🎵 |
