Viewing 15 posts - 766 through 780 (of 59,078 total)
Are you absolutely sure that the drive path and the UNC are actually pointing to the same directory? I HAVE seen people get confused on such issues before.
February 6, 2024 at 8:46 pm
Have you ever read a book on RDBMS?
You can explain things without being such an absolute condescending asshole, Joe!
February 6, 2024 at 1:40 pm
Note : its Partitioned on column - Col_ID ( have to modify the clustered index but just provided as is )
Crud... I missed that detail because I was only...
February 6, 2024 at 1:35 pm
As yet another side bar, unless you have a REALLY good reason to move to 2022, I'm here to tell you that, compared to 2017, 2022 is about 30% slower...
February 6, 2024 at 6:29 am
Duplicate post deleted.
February 6, 2024 at 6:28 am
As a bit of a sidebar, I'd change the YrMo and YrMo2 columns to a DATE datatype. It's 1 byte less than an INT and a whole lot more useful...
February 6, 2024 at 6:20 am
Thank you, Jeff.
You bet, Rod. Thank you for the feedback.
As a bit of a sidebar, I have a now fairly old laptop that I got a couple of year...
February 6, 2024 at 5:41 am
BTW... thank you for the heads up on the UK postal thing and the really incorrect premise that the computer is right until you can prove it's not. Both are...
February 6, 2024 at 1:26 am
Sorry Jeff for the inconvenience. kindly see the below code
INSERT INTO [dbo].[10_SOR_MB]
([item_id]
...
February 5, 2024 at 11:16 am
Search in Duck-Duck-Go for "installation requirements for SQL Server Developer Edition" leads us to a link for the following...
That has links on it for other versions.
February 5, 2024 at 3:21 am
Then, this is fairly easy even in a 24/7 environment (although you didn't list the CREATE TABLEs in full so not 100% sure)
To be sure, the first thing that I'd...
February 5, 2024 at 3:12 am
The article cited "This also coincided with a (an unrelated) law that changed saying computer systems were presumed correct and anyone accused of a crime had to prove the computer...
February 5, 2024 at 2:41 am
I'd much rather they spent their time making SQL Server 2022 run as fast as it used to in 2017. They "broke" it in 2019 and still haven't fixed it...
February 5, 2024 at 1:32 am
Do any of the tables that you want to delete from have IDENTITY columns in them? I don't see IDENTITY anywhere in your CREATE TABLE scripts but just need to...
February 4, 2024 at 12:42 am
Elon Musk moved "X" back to on-prem with, reportedly, a substantial savings.
There are a ton of other companies that have or are considering moving back to on-prem. Here's a decent...
February 3, 2024 at 5:36 pm
Viewing 15 posts - 766 through 780 (of 59,078 total)