Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,741 through 10,755 (of 59,095 total)

RE: huge free spaces in data file can make query slower?

Just to add a bit about performance, most of the performance is in the code when applied to a correctly indexed table. If you have code that is generated by...
--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, 2018 at 7:39 am

#2012185
RE: huge free spaces in data file can make query slower?

Cool2018 - Thursday, November 1, 2018 8:39 PM
Jeff Moden - Thursday, November 1, 2018 5:12 PM
--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, 2018 at 7:32 am

#2012182
RE: How can I get a set Date and Time Range between Yesterday and Today?

People worry about code readability and that's a good thing but they forget one of the most important tools there is that makes even the most obtuse code (sometimes necessary...
--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, 2018 at 6:02 am

#2012172
RE: Data population slows down application performance

andycadley - Thursday, November 1, 2018 1:25 PM
If you're just trying to refresh the summary data and don't want the calculation times...
--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, 2018 at 7:52 pm

#2012133
RE: Function Information

Jason A. Long - Thursday, November 1, 2018 5:57 PM
Jeff Moden - Thursday, November 1, 2018 4:57...
--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, 2018 at 7:48 pm

#2012132
RE: TempDB

If there's that much contention for TempDB, I'm thinking there might be some code problems that need to be fixed.
--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, 2018 at 5:30 pm

#2012129
RE: huge free spaces in data file can make query slower?

There IS a form of freespace that WILL cause your code to run slower and also consume more memory. If you do a bunch of deletes but it doesn't actually...
--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, 2018 at 5:12 pm

#2012128
RE: Function Information

Jason A. Long - Thursday, November 1, 2018 4:53 PM
Jeff Moden - Thursday, November 1, 2018 4:42...
--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, 2018 at 4:57 pm

#2012127
RE: Function Information

Pretty cool. I just wish it could figure out who wrote the objects returned so that I can add their names to a pork chop list. 😀
--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, 2018 at 4:42 pm

#2012125
RE: Are the posted questions getting worse?

jasona.work - Thursday, November 1, 2018 11:55 AM
ZZartin - Thursday, November 1, 2018 8:36 AM
--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, 2018 at 4:36 pm

#2012124
RE: Changing 1 or + in a telephone number to the correct format

Sergiy - Thursday, November 1, 2018 6:07 AM
May I say something really offensive?
Please don't beat me too hard...
Data normalization.
Store country...
--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, 2018 at 8:10 am

#2012047
RE: Quitting Over Training

wodom - Wednesday, October 31, 2018 1:09 PM
This reminds me of a quote I heard. Someone on TV was interviewing a business...
--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, 2018 at 7:59 am

#2012046
RE: Max Time of Max day

Jason A. Long - Wednesday, October 31, 2018 5:30 PM
irehman - Wednesday, October 31, 2018 4:56 PM
--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)

October 31, 2018 at 6:49 pm

#2011988
RE: DT_BYTE to DT_DBDATE

jklenk86 - Wednesday, October 31, 2018 4:30 PM
Lynn Pettis - Wednesday, October 31, 2018 4:27 PM
--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)

October 31, 2018 at 6:47 pm

#2011987
RE: Create a scalar function (or not)

Can you post the code for the "TimelineMatch" function that you're calling from "inline"?
--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)

October 31, 2018 at 4:04 pm

#2011974

Viewing 15 posts - 10,741 through 10,755 (of 59,095 total)