Viewing 15 posts - 2,236 through 2,250 (of 59,067 total)
Thanks for taking the time to post feedback, JJ. It IS interesting to see which hoops and how high the flames are that other people have to go...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 20, 2022 at 11:53 pm
Thanks for taking the time to post feedback, JJ. It IS interesting to see which hoops and how high the flames are that other people have to go through.
And glad...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 20, 2022 at 11:33 pm
SQL FOR SMARTIES 5th edition, chapter 18.2 goes into a lot of painful details znd works it all out
Thanks, Joe!
--Jeff Moden
Change is inevitable... Change for the better is not.
December 20, 2022 at 11:17 pm
Hopefully 10 seconds few times a day is a problem on you server!!!!
It's not... but the attitude that will cause everything to be written in such a fashion, or...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 20, 2022 at 5:09 am
Yes, that is how NOT IN () is defined in ANSI/ISO Standard SQL.
Thanks for the confirmation on that, Joe. Do you happen to have a link for that or...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 20, 2022 at 5:08 am
The way I write such code is to ...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 20, 2022 at 12:23 am
You code appears to be a part of Dynamic SQL. If so, then replace each single quote with two single quotes.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 19, 2022 at 11:29 pm
I found an update by someone that I personally trust on the subject (to be sure, I also trust Michael but the link below has a "chart" on the subject...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 19, 2022 at 11:00 pm
It seems this thread has gotten off-track.
BWAAA-HAAA!!!! I wonder how that happened. 😀 😀 😀
Maybe I am off-base here, but...
And, not to worry... you're not the only one...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 19, 2022 at 10:28 pm
I would ask THEM (your Help Desk people) to contact Microsoft and for THEM to take full responsibility if the proverbial poo hit's the fan because of such an upgrade. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 19, 2022 at 9:00 pm
You should have posted those here back in 2009. 😀
I also noticed the note at the bottom of your post... why not write those functions as iTVFs instead of...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 19, 2022 at 8:51 pm
@Eirikur That works, of course, but SQL Server won't be able to use any index for that query.
Using indices is not necessarily the same as having...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 19, 2022 at 8:45 pm
@Eirikur That works, of course, but SQL Server won't be able to use any index for that query.
Using indices is not necessarily the same as having better performance,...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 19, 2022 at 4:33 pm
Yeah... he came back with an "I got this" post with an embedded link. Took that one out.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 19, 2022 at 4:29 pm
What I've found is that a lot of employees have the proverbial 9-to-5- attitude and only want to improve their skills on the company nickel and on company...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 19, 2022 at 4:27 pm
Viewing 15 posts - 2,236 through 2,250 (of 59,067 total)