Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,411 through 4,425 (of 59,098 total)

Reply To: OK, I still think like a programmer -- is there a better way to do this?

GaryV wrote:
The difference of bad data before and after computers is that bad data in computers can be perpetuated and disseminated so much faster.
And that more people believe the bad...
--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 3, 2021 at 6:23 pm

#3947621
Reply To: Recursive Query to get get diff between two rows for same client

Tallboy wrote:
Hi Jeff,
Good questions Jeff, its in development so not sure exactly what to do with results yet?
If Client has only one row then leave it out of the results...
--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 3, 2021 at 5:01 am

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

Michael L John wrote:
Well, this is interesting. SQL 2022. No more parameter sniffing?
https://www.youtube.com/watch?v=ncF-zFzBDAY
Heh... nothing could go wrong there, right? 😀
--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 3, 2021 at 12:38 am

#3947319
Reply To: replace all tables used in view with prefix and update view defn automatically

Sorry... post withdrawn. Wrong 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)

November 2, 2021 at 9:14 pm

#3947261
Reply To: Best Practice question

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
Actually you could be causing a performance problem by getting SQL to use the same query plan for different values, i.e., by avoiding the "overhead" of a...
--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 2, 2021 at 8:36 pm

#3947247
Reply To: Best practice to store - How many days, minute and second ?

ratbak wrote:
I'd love to see a generic framework/example for this, even if the OP has left the building.
I know your preference for datetime over datetime2, but would also be interested...
--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 2, 2021 at 8:31 pm

#3947241
Reply To: Best Practice question

ScottPletcher wrote:
Actually you could be causing a performance problem by getting SQL to use the same query plan for different values, i.e., by avoiding the "overhead" of a recompile. 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)

November 2, 2021 at 8:16 pm

#3947235
Reply To: Best Practice question

mike 57299 wrote:
The example is for a query called by the Customer List page of the web application. It will execute 1000's of times a day.
In that case, please see 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)

November 2, 2021 at 3:53 pm

#3947140
Reply To: How to solve this

@sunilkmr284 ,
Any interest in your own problem that you posted?
--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 2, 2021 at 3:16 pm

#3947125
Reply To: Best Practice question

The common name for such a query is a "Catch-All" query and "It Depends" strongly comes into play here. How often will this query be executed?
--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 2, 2021 at 3:07 pm

#3947120
Reply To: Best practice to store - How many days, minute and second ?

Ken McKelvey wrote:
If you are planning for large amounts of data you might be interested in some 'light' reading:
https://www.itprotoday.com/sql-server/interval-queries-sql-server
Itzik's article is fantastic but I hope that doesn't scare off 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)

November 2, 2021 at 2:42 pm

#3947105
Reply To: Best practice to store - How many days, minute and second ?

Adelia wrote:
Thanks to all
Adelia,
Don't go yet. I asked you some questions about datatypes that you've not answered yet. If you let me know that the datatypes of the start and...
--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 2, 2021 at 2:14 pm

#3947091
Reply To: Best practice to store - How many days, minute and second ?

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
I'd say it depends on how often you need to show the resolution duration. That's a rather complex calc to do repeatedly..
I have to disagree. If 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)

November 1, 2021 at 11:49 pm

#3946885
Reply To: What ate all my DB resources?

ashkan sirous wrote:
Regarding calculated column VS persisted triggered data, I don't have enough knowledge so I would like to read more. I was expecting the indexes to come to play already...
--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 1, 2021 at 11:33 pm

#3946882
Reply To: Best practice to store - How many days, minute and second ?

ScottPletcher wrote:
I'd say it depends on how often you need to show the resolution duration. That's a rather complex calc to do repeatedly..
I have to disagree. If you use 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)

November 1, 2021 at 3:31 pm

#3946752

Viewing 15 posts - 4,411 through 4,425 (of 59,098 total)