Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 59,086 total)

Reply To: Are the posted questions getting worse?

Michael L John wrote:
Jeff Moden wrote:
I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me...
--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)

September 5, 2022 at 7:52 pm

#4084127
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

david.wright-948385 wrote:
Good timing - the current feature list for SQL Server 2022 includes the function GENERATE_SERIES(), which looks like a handy way to generate the Numbers or Tally rows.
Agreed. It...
--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)

September 5, 2022 at 7:42 pm

#4084126
Reply To: last time index was re-org or rebuilt?

Unless you have a system, such as Ola Hallengren's index maintenance solution, there's nothing in SQL Server that logs this information. And, no... even though index REBUILDs update stats, I...
--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)

September 5, 2022 at 4:22 pm

#4084092
Reply To: T-SQL Language Changes in SQL Server 2022

paul.hermeneutic wrote:
Jeff Moden wrote:
paul.hermeneutic wrote:
Is anything here part of ISO/IEC 9075:2016 (ANSI X3.135)? https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/
What parts of the SQL standard has Microsoft not yet implemented?
At the prices they charge for the specs,...
--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)

September 5, 2022 at 2:25 am

#4083869
Reply To: Are the posted questions getting worse?
Sergiy wrote:
Jeff Moden wrote:
[
Correct... but it didn't convert to FLOAT in other versions either (thank goodness for that!)... It converts numeric literals (constants) that have a value larger than the bounds...
- This reply was modified 3 years, 11 months ago by Jeff Moden. Reason: Added more info about possible multiple floats being used behind the scenes
--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)
September 5, 2022 at 1:55 am

#4083853
Reply To: Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)

You simply can't constrain a column to NOT NULL if it contains NULLs. There has to be a value in every row of a NOT NULL column or one that...
--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)

September 4, 2022 at 11:38 pm

#4083836
Reply To: Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)

SomeID doesn't have to have a value to have the FK placed on it. FK's are "if something, other than a NULL, is present, it has to be in that...
--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)

September 4, 2022 at 10:42 pm

#4083829
Reply To: T-SQL Language Changes in SQL Server 2022

paul.hermeneutic wrote:
Is anything here part of ISO/IEC 9075:2016 (ANSI X3.135)? https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/
What parts of the SQL standard has Microsoft not yet implemented?
At the prices they charge for the specs, I'll never...
--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)

September 4, 2022 at 10:36 pm

#4083828
Reply To: Problem : Passing a Variable is not working in Dynamic Query

No need for the Dynamic SQL, the WHILE loop, or any of the other complexities that go along with those things.
Here's a sample "tbl_names" table that I made up for...
--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)

September 4, 2022 at 10:15 pm

#4083826
Reply To: How do I query to exclude the "first position of a 3 digit number"

Steve Jones - SSC Editor wrote:
ScottPletcher wrote:
I have to say, in this case I would use a char/varchar column for room numbers, not an int. Even if the hotel guest rooms are all numeric,...
--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)

September 4, 2022 at 9:14 pm

#4083817
Reply To: Are the posted questions getting worse?

That's a beautiful thing, Steve. I didn't know of anyone that had actually downloaded the public eval of 2022 and installed it. Thank you very much?
I was thinking that this...
--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)

September 4, 2022 at 8:56 pm

#4083816
Reply To: Crazy Interview Questions

stasikpasik wrote:
I agree interviewers love to ask tricky questions.
Heh... wait for it...
--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)

September 4, 2022 at 7:12 pm

#4083804
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:
Jeff Moden wrote:
I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me...
- This reply was modified 3 years, 11 months ago by Jeff Moden. Reason: Added a note about a resonable documentation alternative
--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)
September 4, 2022 at 5:29 pm

#4083791
Reply To: Are the posted questions getting worse?

DesNorton wrote:
Jeff Moden wrote:
I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me...
--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)

September 4, 2022 at 5:13 pm

#4083789
Reply To: Are the posted questions getting worse?

I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know 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)

September 4, 2022 at 4:41 am

#4083697

Viewing 15 posts - 2,836 through 2,850 (of 59,086 total)