Viewing 15 posts - 5,086 through 5,100 (of 59,068 total)
According to your sample data and results, the "Answer" you marked is not correct. For example, you stated that '10000' should return a 1 -- "Anything between 00000...
June 17, 2021 at 8:09 pm
Why? If what you're saying is true, then just use the first char in the value as the category, that's less overhead than any kind of table lookup.
Because...
June 17, 2021 at 8:07 pm
I've found that it's not often a "slow running query" is the actual problem. I've found that it's normally one that could certainly run better/faster/fewer-resources that runs hundreds or thousands...
June 17, 2021 at 8:05 pm
p.s. I also wouldn't use the "data" feature of the above method because it creates and INSERT/VALUEs statement for every bloody row of data.
If you use a product like RedGate...
June 17, 2021 at 7:56 pm
If you only need to do this occasionally, it might just be simpler to open the Object Explorer window in SSMS (press the {f8} key to open it if it's...
June 17, 2021 at 7:54 pm
Thank you for your inputs I apologize for my mistake in my sample the last case statement is 9. not 0.
Thank you for all your assistance and guidance
Ok... that...
June 17, 2021 at 5:44 pm
Stupid question, but why are some people use a low fill factor as 70 or 80%, I'm usually fine with something as 95-98 (or even 100 if it...
June 17, 2021 at 5:03 pm
I have a general issue with the idea that innovation comes from sitting people down cracking a whip and asking them to innovate. Maybe some people can work...
June 16, 2021 at 5:22 pm
My basic trouble with hackathons in a company is... why do they actually need one to begin with? It seems like that's an admission that they don't embrace...
June 16, 2021 at 5:03 pm
Stupid question, but why are some people use a low fill factor as 70 or 80%, I'm usually fine with something as 95-98 (or even 100 if it...
June 16, 2021 at 4:55 pm
Thanks, Johan. It's been a decade since the two of us have had the chance to talk in person. IIRC, the last time was at the PASS Summit of 2011.
June 16, 2021 at 3:28 pm
Can you send a more full blown version, and how I get(download) dbatools. I went to the page but didn't see how to download.
Many thanks!!!!
You mean you haven't actually...
June 16, 2021 at 3:24 pm
Stupid question, but why are some people use a low fill factor as 70 or 80%, I'm usually fine with something as 95-98 (or even 100 if it is...
June 16, 2021 at 3:15 pm
I would like to see if any other alternatives were there. other than Case.. Please
Thank you
Heh... more likely, it's probably an interview question. 😉 It's a good one, IMHO,...
June 15, 2021 at 4:52 pm
Viewing 15 posts - 5,086 through 5,100 (of 59,068 total)