Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,781 through 6,795 (of 59,072 total)

Reply To: Nearest Proximity For every record

Phil Parkin wrote:
marty.seed wrote:
How does that help?
Because it gives you the distance from every building to every other building.
And, if you use the right measurements, it gives you the actual driving...
--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, 2020 at 10:06 pm

#3769576
Reply To: Find the last occurrence of \ character and get the left of string.

What version of T-SQL are you actually using? I ask because there's no such thing as "VARCHR" in T-SQL. There is "VARCHAR" but it has two "A"s in it instead...
--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, 2020 at 4:52 pm

#3769459
Reply To: Beating the Cloud Vendors

David.Poole wrote:
Confusing pricing, limited hardware choices, and a feature mix that is different.
The king is dead, long live the king!
In our case, a feature mix that is inadequate when 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)

July 13, 2020 at 4:48 pm

#3769458
Reply To: Isnull in a Where Clause

david.edwards 76768 wrote:
Luis
You have the same column on the left and right of the equality
WHERE fldinfo=ISNULL(@parameter,fldinfo)
...
Happy to stand corrected.
It's actually because of the function usage on a column. Every row must...
--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, 2020 at 1:35 pm

#3769405
Reply To: Snapshot database

Phil Parkin wrote:
Steve Jones - SSC Editor wrote:
I think Phil is showing a restore of the database from the snapshot, essentially rewinding time.
Correct. To be honest, I just assumed that the OP had worded their...
--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, 2020 at 1:23 pm

#3769402
Reply To: Function to split string

😀

--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, 2020 at 1:21 pm

#3769401
Reply To: Returning data from table based on date ranges

sc-w wrote:
Hi Jeff, thanks for your reply. The dates will not changes each year they will remain the same. What are your thoughts based on this? Thanks.
My thoughts on 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)

July 12, 2020 at 10:24 pm

#3769281
Reply To: Controlling Intelligent Query Processing Features

I forget which movie I saw it in but the quote was "A man's gotta know his limits". To convert that to something more appropriate to this thread, "A DBA'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 11, 2020 at 4:58 pm

#3769162
Reply To: Function to split string

Jeffrey Williams wrote:
If I am reading your function correctly - all it is doing is splitting the delimited string and returning the values as rows. There is no reason to do...
--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 11, 2020 at 3:52 pm

#3769158
Reply To: Returning data from table based on date ranges

sc-w wrote:
So I have a table called charges that stores rent and service charges for properties. Some properties pay rent monthly and others in English quarter days which are (March...
--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 11, 2020 at 3:48 pm

#3769156
Reply To: Moving away from an RDBMS

Doctor Who 2 wrote:
I'm jumping in early, as I haven't yet read Leonard Lobel's blog post. As a developer I am very interested in NoSQL databases, and in particular CosmosDB. However, there'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 10, 2020 at 6:58 pm

#3769049
Reply To: 1-Table & 2-Table data migrate

LLSQL42 wrote:
Hi,
I tend to copy data from Table1 to Table2.
Table1 will always being refresh & truncate, because it will subsequent load new record into it.
Table2 will be permanent main table.
As...
--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 10, 2020 at 3:06 pm

#3768988
Reply To: How to Make Scalar UDFs Run Faster (SQL Spackle)

I could not think of a higher compliment and I'm humbled by your words. Thank you again, good Sir!
--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 10, 2020 at 2:50 pm

#3768981
Reply To: Moving away from an RDBMS

skeleton567 wrote:
Well, my career progressed from card decks (80 column, then 96 column) and MICR sort machines, then flat files that we had to write sort utilities to reorder, through...
--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 10, 2020 at 2:46 pm

#3768980
Reply To: How to Make Scalar UDFs Run Faster (SQL Spackle)

david.edwards 76768 wrote:
"Cracking" (groan) article. One for the briefcase, thank you.
Thanks for the feedback, David. Really appreciate 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)

July 10, 2020 at 2:05 pm

#3768954

Viewing 15 posts - 6,781 through 6,795 (of 59,072 total)