Jeff Moden

Forum Replies Created

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

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

I'm not sure why you have so much free space for the NDF files. Something is wrong there or you've measured something wrong or it's used space and not free...
--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 9:32 pm

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

Cool2018 - Friday, November 2, 2018 9:35 AM
Dear Jeff,
Thank you so much for all your advices and explanations.
Our current DB size...
--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 3:29 pm

#2012285
RE: Function Information

MMartin1 - Friday, November 2, 2018 12:25 PM
People have mentioned about formatting and casing consistency in code for readability. To me readability...
--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 3:16 pm

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

p.s. If your new requirement is to truncate the whole table and then reload it, it's almost stupid for the table to be partitioned. It's buying you very little and may...
--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:45 am

#2012186
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

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