Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,811 through 6,825 (of 59,091 total)

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
Reply To: How to Make Scalar UDFs Run Faster (SQL Spackle)

TomThomson wrote:
So it looks to me as if things have changed rather a lot since Jeff wrote the paper, and it would probably be useful if someone could do measurements...
--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

#3768953
Reply To: A Digital Wish Card for Ken

Lordy! Emergency Surgery? What on Earth did you swallow this time? I told you not to put things in your mouth! 😀
Get well soon, Ken... you're definitely one of 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 8, 2020 at 11:25 am

#3768347
Reply To: Better Laptop Life

I don't know when they'll hit the streets but they starting to experiment with graphene-based processors (and other things) that are supposed to use only 1% of the energy 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 8, 2020 at 5:03 am

#3768297
Reply To: NPI Data

p.s. As Jeffrey Williams pointed out, if you don't have 2017 or better, the FIELDQUOTE option isn't going to work. Post back if that's a part of your problem... we...
--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 7, 2020 at 10:49 pm

#3768242
Reply To: NPI Data

According to the documentation, several of the "fields" in the data represent up to 10 digits of numeric information. While the max number of digits for an INT is, indeed,...
--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 7, 2020 at 10:47 pm

#3768241
Reply To: Document recovery procedure

Admingod wrote:
Trying to document a process in an event of disaster and different reasons. In case if the database repair attempt is unsuccessful.Do you think listing the steps of recovery...
--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 7, 2020 at 10:21 pm

#3768236

Viewing 15 posts - 6,811 through 6,825 (of 59,091 total)