Viewing 15 posts - 436 through 450 (of 59,066 total)
Nope... not "WE"... "THEY".
THEY have gotten arrogant... every damned one of them.
July 27, 2024 at 4:59 am
I agree with Brian... check with the 3rd party before you mess with one of their tables. While this is just a simple "audit" table that won't even stand up...
July 25, 2024 at 11:01 am
Do a COUNT on both columns using GROUP BY and add a HAVING where the COUNT(*) = 1.
July 25, 2024 at 5:07 am
I saw the follow soon after it came out more than a year ago. It's focus is on the very ramifications you speak of... in this case, something as seemingly...
July 24, 2024 at 3:52 am
Heh... New tag line... SQL Server 2022... It just runs slower... A LOT SLOWER!
July 22, 2024 at 9:28 pm
After long hours, days and weeks the system back to healthy state. The biggest problem was bad developers code that had to be changed. That was...
July 19, 2024 at 7:49 pm
That is really awesome, Jeff! In fact, that's outstanding. In my environment we do unit testing and UAT, and that's about it. We don't have the success rate that...
July 19, 2024 at 3:38 am
Hmmm, Jeff going. I'm going to have to see if I can make it.
Ed Wagner and I will be arriving in the afternoon on that Friday. Man, I understand...
July 18, 2024 at 5:00 am
Install this TVF.
Then this SQL will do the job
select x.value value1, x.value+1000001 value2
from dbo.GENERATE_SERIES(-999999999,+999999999,1) x
;
Install this TVF.
Then...
July 18, 2024 at 4:33 am
After long hours, days and weeks the system back to healthy state. The biggest problem was bad developers code that had to be changed. That was killing the...
July 18, 2024 at 4:24 am
I guess our code coverage is 500% plus a post prod kicker...
DEV
QA
DEVREVIEW (DBA Review and regression checks)
STAGE (UAT)
PREPROD (UAT and full system checks on full size from nightly restores which...
July 18, 2024 at 4:19 am
2nd page bump to get post to appear
July 16, 2024 at 4:41 am
-- Create TableA CREATE TABLE TableA ( MainID INT, JoiningID INT );
-- Insert data into TableA INSERT INTO TableB (MainID, JoiningID) VALUES
(No column name)
...
Heh... you didn't try to run...
July 16, 2024 at 4:36 am
Viewing 15 posts - 436 through 450 (of 59,066 total)