Viewing 15 posts - 1,186 through 1,200 (of 59,066 total)
Nominal scales are modeled as character strings, not integers.
Instead of the normal long retort that proves you wrong that subject, I jump straight to the punchline this time......
August 23, 2023 at 1:34 am
Recommendation: When posting performance issues, please follow the guidelines posted in the article at the 2nd link in my signature line below.
August 23, 2023 at 1:28 am
Yep... there's the "can thing" and understood.
Since values from 000 thru 999 have already been distributed, we can't just use the simplicity of base 36 so I guess I'd do...
August 21, 2023 at 5:02 pm
After migrating a massive number of documents for the AAIB and MAIB earlier in my career I became and avid watcher of Air Crash Investigation. One fatal...
August 21, 2023 at 12:31 pm
The reason why the code doesn't produce an error can be found in the execution plan. Apparently, since SQL knows there's only 1 row, it never executes the...
August 17, 2023 at 7:20 pm
It's like the ORDER BY in the second query. Do the ORDER BY using the column aliases for the SUMs rather than the SUMS themselves.
August 17, 2023 at 5:26 pm
The reason why the code doesn't produce an error can be found in the execution plan. Apparently, since SQL knows there's only 1 row, it never executes the ORDER BY. ...
August 17, 2023 at 5:09 pm
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
Gosh... thanks for the very kind words but I'm far...
August 17, 2023 at 2:07 am
I've never seen anything like that from a CU before. What happens when you re-enable the jobs?
August 17, 2023 at 2:04 am
His name is "Hallengren". 😉
Hello SQL Experts,
Followed the guidance provided by Microsoft.
What guidance??? Be specific because, if they have to do with indexes, MS finally figured out what a...
August 17, 2023 at 1:59 am
Building a new logic may take time plus avoiding certain characters, or keeping a conversion table and when there no resource available, why don't you expand the field itself. ...
August 16, 2023 at 3:39 pm
Hi
In Sql Query or using Stored Procedure
Thanks
Such formatting can, indeed, be done in a query or stored procedure. My "Morning Report" emails I get from the servers are proof...
August 15, 2023 at 7:07 pm
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
Gosh... thanks for the very kind words but I'm far from perfect. ...
August 15, 2023 at 6:50 pm
You'd think someone working in it would know how to ask for help properly..... developer just sent me.
"the UAT ETL server seems to be really slow this morning. Any...
August 15, 2023 at 6:09 pm
I totally agree with Grant. IMHO, what he's recommending (AD Groups a.k.a. Active Directory Groups) is the only way to go on something like this.
August 14, 2023 at 1:55 pm
Viewing 15 posts - 1,186 through 1,200 (of 59,066 total)