Viewing 15 posts - 2,566 through 2,580 (of 39,723 total)
Yep, no heaps allowed without a really good, defensible reason.
July 6, 2020 at 2:14 pm
Thanks for the notes. I'll update the question, but I don't see GROUP BY xxx WITH CUBE|ROLLUP deprecated. It is noted as backwards compatibility and not ISO standard, but not...
July 6, 2020 at 2:08 pm
You need a connector. I've seen some for sale, like this one: https://www.cdata.com/kb/articles/ado-ssistask.rst
July 3, 2020 at 3:48 pm
Encryption is a complex topic. What to write about it depends more on requirements than the features involved. This is really just running functions on data when storing/retreiving, so depending...
July 3, 2020 at 3:48 pm
Interesting to see this. If there are no NULLs, I wouldn't expect rows to need to move or any page splits. This ought to be a meta data only change.
July 3, 2020 at 3:46 pm
On my previous laptop, I ran Dev edition for
On this one, I have 2017 and 2019, no issues. In fact, I don't usually install a default instance...
July 3, 2020 at 3:43 pm
So, I proposed rewriting the client admission and billing pieces into a web app. The proposal was accepted and I led the rewrite. We delivered that some 6 months...
July 2, 2020 at 4:14 pm
That leads me to my best day. I changed jobs and no longer had to support systems 24/7!
Scott
That's a win right there.
July 2, 2020 at 4:13 pm
I agree. You shouldn't be updating these. The reason is that if you move the server/db to a new time zone, or clients move, they can always determine the actual...
July 2, 2020 at 3:53 pm
It wasn't pointed towards me but I still felt bad for them so I replied "I'm sorry, you didn't reach out for me earlier …"
Hopefully they learned something
July 2, 2020 at 3:49 pm
I think so. I know it gets announced in a few places.
July 2, 2020 at 3:52 am
I don't believe you can change from UTC, which is expected. You should use the AT TIME ZONE to convert to local time.
What customization for the time did you have...
July 1, 2020 at 4:02 pm
The survey gets announced: https://stackoverflow.blog/2020/02/05/the-2020-developer-survey-is-now-open/
July 1, 2020 at 2:09 pm
A moment of silence, please.
I heard from his family and Mike Vessey, https://www.sqlservercentral.com/author/mvdba, passed away on 25 Jun 2020. I was pleased to meet Mike and host him on...
June 29, 2020 at 3:08 pm
Viewing 15 posts - 2,566 through 2,580 (of 39,723 total)