Jeff Moden

Forum Replies Created

Viewing 15 posts - 466 through 480 (of 59,069 total)

Reply To: Creating an Index with a lot of Columns

emuller1982 wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 18, 2024 at 4:24 am

#4437791
Reply To: Where to Test Your Code

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 18, 2024 at 4:19 am

#4437790
Reply To: TSQL Help, Possible a recursive CTE

2nd page bump to get post to appear
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2024 at 4:41 am

#4436457
Reply To: TSQL Help, Possible a recursive CTE

erics44 wrote:
-- 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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2024 at 4:36 am

#4436456
Reply To: Updated Table Not Displaying Data

yrstruly wrote:
Attached is some sample data. I could get this code to work, by inserting one row where FY/YEAR is 2024 and all of FY/YEAR 2025.
The original tables data goes...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2024 at 4:30 am

#4436455
Reply To: SQL Saturday Pittsburgh 2024 (#1094) - Call for speakers and other event details

I'd rather go for a nice dinner and maybe some pool shooting at a good bar with big screens to watch the lions game than to get caught up in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2024 at 3:41 am

#4436451
Reply To: How soon will relational databases become obsolete, if at all?

Simon Hundleby wrote:
Hi, I' am currently in the process of designing the Data Warehouse spec for my company (Start up Business),
During discussions a number of the technical leads and C# developers...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 13, 2024 at 7:40 pm

#4435886
Reply To: SQL Saturday Pittsburgh 2024 (#1094) - Call for speakers and other event details

David Burrows wrote:
Jeff Moden wrote:
With some luck, one of the sessions I submitted will be selected and I'll "make the trip" to Pittsburgh!
will you drive or fly Jeff 😀
Drive. Right now, it's...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 13, 2024 at 3:02 pm

#4435845
Reply To: EightKB... I'm presenting! Bring your water-cooled helmet! :D

gdudley wrote:
Hello Jeff, I came across your presentation while researching the evils of using GUIDs as PKs and to say it was very informative would be an understatement. Do you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 13, 2024 at 1:42 pm

#4435829
Reply To: backup file name null in msdb..backupset table

Perry Whittle wrote:
Jason A. Long wrote:
Snargables wrote:
disregard. i found it. I'll reply w/ what i end up with to close the loop
Did you ever find the solution? If so, would you be kind...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 12, 2024 at 5:29 pm

#4435624
Reply To: The Number that shouldn't be a number

mister.magoo wrote:
Jeff Moden wrote:
Ah... be careful now. That's absolutely not possible.
Be carefuller - What happens when the number is not part of that plan?
All phone number in the UK start...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 12, 2024 at 5:20 pm

#4435623
Reply To: TSQL Help, Possible a recursive CTE

erics44 wrote:
Haha how do I do that?
In an attachment?
Haha... Just like you've done before...
https://www.sqlservercentral.com/forums/topic/hierachy-by-tsql#post-4093618

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 12, 2024 at 5:17 pm

#4435621
Reply To: TSQL Help, Possible a recursive CTE

Jonathan AC Roberts wrote:
Here you are courtesy of ChatGPT
Heh... Ok... since you brought it up, what prompt(s) did you use?
The key here is, again, the folks answering the questions shouldn't have to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 12, 2024 at 5:13 pm

#4435620
Reply To: The Number that shouldn't be a number

mwyss wrote:
I worked with one company that stored phone numbers as integers. Yes. Plural. They broke up the 10-character US phone numbers into separate AreaCode (first 3 digits), Exchange (Next...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 12, 2024 at 2:29 pm

#4435561
Reply To: The Number that shouldn't be a number

andrew gothard wrote:
"On the plus side, storing telephone number as int uses less storage than a varchar. Ok you won't need to use any numeric functions on it, but you probably...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 12, 2024 at 2:27 pm

#4435559

Viewing 15 posts - 466 through 480 (of 59,069 total)