Viewing 15 posts - 14,851 through 14,865 (of 59,063 total)
sqlenthu 89358 - Wednesday, June 21, 2017 9:34 PMThanks Jeff. Very helpful and interesting.
Thanks for the feedback. Just to add to the...
June 22, 2017 at 7:45 am
June 22, 2017 at 7:41 am
The question that I have is, should 15 or 16 Mondays be returned?
June 21, 2017 at 8:20 pm
SELECT June 21, 2017 at 8:16 pm
Thought I'd throw my hat into the ring. Might as well make the functionality reusable in case requirements change or you someday need to go in the other direction. Further...
June 21, 2017 at 8:08 pm
June 21, 2017 at 3:03 pm
If proc cache hasn't been cleared, it may show up in the built in reports as one of the queries that used the most I/O.
June 21, 2017 at 2:59 pm
June 21, 2017 at 2:49 pm
Test data...
IF...
June 21, 2017 at 2:44 pm
I wouldn't put it anywhere in a PIVOT for the very reason of NULLs. If you use a CROSSTAB instead, it's all "auto-magic" and can be twice as fast, as...
June 21, 2017 at 2:14 pm
Further, using scalar functions to select from a table is going to cause a performance problem. The function code needs to be converted to an iTVF.
June 20, 2017 at 12:29 pm
June 19, 2017 at 2:40 pm
Crud... "Random Masking". It thought it was an early question about Halloween. 😉
June 19, 2017 at 2:11 pm
June 19, 2017 at 2:09 pm
Viewing 15 posts - 14,851 through 14,865 (of 59,063 total)