Viewing 15 posts - 751 through 765 (of 59,066 total)
If InfoSec already has an issue with replication because you are going from Prod to Non-Prod, then using backup/restore is also going to be an issue. Anything that allows...
February 7, 2024 at 8:13 pm
I have a SQL database of 2 TB running on production. There is a need to refresh this database on Q environment on a daily basis. Cannot implement SQL...
February 7, 2024 at 8:07 pm
Comparing yourself to an even bigger asshole doesn't lessen the fact that you're an asshole. In fact, it confirms just how much of an asshole you are. 😉
February 7, 2024 at 3:35 pm
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
Viewing 15 posts - 751 through 765 (of 59,066 total)