Jeff Moden

Forum Replies Created

Viewing 15 posts - 256 through 270 (of 59,063 total)

Reply To: DigitsOnlyEE and AlphaNumericOnly

ARM07470 wrote:
You can simplify the WHERE clause in AlphaNumericOnly and AlphaOnly by taking advantage of the fact that upper and lower case letters differ only by the 6th bit, 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)

December 7, 2024 at 7:58 pm

#4494768
Reply To: DigitsOnlyEE and AlphaNumericOnly

I'm a little late here but great observation, Anthony. I'll have to give that a try.

--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)

December 7, 2024 at 6:57 pm

#4494731
Reply To: Blob Storage automated downloads

Brandie Tarvin wrote:
...even Microsoft stuff has to go through a testing / peep process here.
From the looks of things, MS hasn't done a good job on QA since 2017.
--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)

December 5, 2024 at 10:12 pm

#4493883
Reply To: How can I see a DEPENDENCY TREE for objects used inside SP1 Stored Proc, and for each object referenced further inside each object, etc.?

Does Example 7 of the following article do it for you?
https://www.mssqltips.com/sqlservertip/2999/different-ways-to-find-sql-server-object-dependencies/

--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)

December 3, 2024 at 2:35 pm

#4492670
Reply To: Need a list of stored procedures that execute multiple stored procedures

Does example #7 in the article at the following link do it for you? You can add criteria to only consider stored procedures.
https://www.mssqltips.com/sqlservertip/2999/different-ways-to-find-sql-server-object-dependencies/

--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)

December 3, 2024 at 4:57 am

#4492462
Reply To: The Funny SELECTs

Robert Sterbal wrote:
It will be funny because the column labels are 10 years different than the WHERE clauses
Tru dat!
--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)

December 2, 2024 at 6:24 pm

#4492281
Reply To: Tracing a performance issue

That other post can be found at the following link...
https://www.sqlservercentral.com/forums/topic/tracing-a-performance-issue

--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)

December 2, 2024 at 6:16 pm

#4492280
Reply To: Doing a Little Research

Removed accidental dupe post.
--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)

December 2, 2024 at 3:48 am

#4491898
Reply To: Doing a Little Research

There's been some good things since 17 hit the streets. They did, however, break copy'n'paste. I have a special color (Red) that I use for ALL constants and a special...
--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)

December 2, 2024 at 3:47 am

#4491897
Reply To: The Funny SELECTs

It's also going to miss any and all "whole dates" (a.k.a. dates with a midnight time) for the 3 years involved. The > should have been >= in all 3...
--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)

December 2, 2024 at 2:05 am

#4491880
Reply To: Over-Engineering

skeleton567 wrote:
Several years after that my old boss related to me that the bug fixes had never been released, and the whole system had been retired and replaced.
Ya just gotta...
--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)

December 1, 2024 at 10:48 pm

#4491844
Reply To: Simple Junction table design question

ScottPletcher wrote:
I believe the more common, and better, naming for tables is plural. I can't think of a major relational dbms that uses singular system table names.
For example: sys.objects (SQL...
--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)

November 30, 2024 at 5:32 pm

#4491356
Reply To: Simple Junction table design question

eichnerm wrote:
Thank you all for getting back to me. I appreciate the advice. Because of your advice, I won't make a big deal out of removing the ID. Oddly, 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)

November 27, 2024 at 4:08 am

#4489649
Reply To: Microsoft Recommendations for Update Stats?

Brandie Tarvin wrote:
Wow. Just ... WOW. Watched the 1.2. Now going to watch 3.
Thanks, Jeff.
That's the same reaction I had when the size charts gave me a hint about what was...
--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)

November 27, 2024 at 12:28 am

#4489610
Reply To: Microsoft Recommendations for Update Stats?

Bumping my own post because of the 2nd page issue on this forum.

--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)

November 26, 2024 at 11:59 pm

#4489597

Viewing 15 posts - 256 through 270 (of 59,063 total)