Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,361 through 6,375 (of 59,089 total)

Reply To: The 10X Programmer

Sergiy wrote:
...they need more action based on commonly used "best practices"...
Heh... allow me to reword that for you my long time friend in arms....
...they need more action based on commonly...
--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)

September 25, 2020 at 2:13 pm

#3790952
Reply To: Function Code

Lynn and David,
Thank you both for the very kind words. I never expect such replies and I'm seriously humbled by them.
--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)

September 25, 2020 at 2:07 pm

#3790950
Reply To: Function Code

sizal0234 wrote:
Thank you Jeff for showing the right direction. I always had this issue of generating test data and now I have a plan and your teaching is very helpful....
--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)

September 25, 2020 at 2:04 pm

#3790949
Reply To: Query tuning help.

It calls a view. We'd need to see the query for that and, again, it would be great to see an "Actual Execution" plan instead of the "Estimated Execution Plan"...
--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)

September 25, 2020 at 1:45 pm

#3790941
Reply To: DB maintenance plan to clear tempdb?

While there is some really good advice out there about the number of files, drives, types of drives, etc, etc, etc related to TempDB, I've found that the biggest problem...
--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)

September 25, 2020 at 1:43 pm

#3790939
Reply To: Query tuning help.

SQL_Surfer wrote:
Interesting. It works fine on my machine. When I double click on it it pulls up on my SSMS. It was saved using Plan Exploer if that helps.
I'm attaching...
--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)

September 25, 2020 at 1:35 pm

#3790934
Reply To: DB maintenance plan to clear tempdb?

arvind.patil 98284 wrote:
Hi Experts ,
We have identified the process which has consumes the space in tempdb . The stored procedure uses a lot of temp tables in it . Does storing...
--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)

September 25, 2020 at 1:27 pm

#3790932
Reply To: Validate field in STaging before loading

David Burrows wrote:
Nowadays I tend to create a unique staging database.
I do that same thing a lot, myself. The cool part about that is is that it can be set to...
--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)

September 25, 2020 at 1:21 pm

#3790930
Reply To: Validate field in STaging before loading

jcelko212 32090 wrote:
My guess would be that a document number should be an identifier. Identifiers are always measured on a nominal scale. Therefore, you document number should have been a 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)

September 25, 2020 at 1:17 pm

#3790929
Reply To: Function Code

sizal0234 wrote:
Jeff - I was reading your article(https://www.red-gate.com/simple-talk/opinion/opinion-pieces/jeff-moden-dba-of-the-day/) and wanted to ask, what are some of the books or resources you felt like are great resouces to master Tsql. I...
--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)

September 24, 2020 at 11:07 pm

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

jonathan.crawford wrote:
Which of these is your question:
"What does the 101 format produce on a date converted to varchar?"
"How do you convert a date to varchar and format it?"
"What is 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)

September 24, 2020 at 7:31 pm

#3790792
Reply To: Validate field in STaging before loading

david.edwards 76768 wrote:
Grant Fritchey wrote:
Strong advice: all tables, all databases, all the time, use appropriate data types. It really matters.
Obviously I agree with that principle, as a general rule. Would you say...
--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)

September 24, 2020 at 7:24 pm

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

Ok! Keeping in touch with the original intent of this thread, I've just found the perfect 2nd question to ask people I'm interviewing. It's a perfect fit for my infamous...
--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)

September 24, 2020 at 6:45 pm

#3790773
Reply To: Function Code

CONVERT is one of the quintessential functions in SQL Server. Please see the following documentation where you'll also find out what the "101" means... You should bookmark the link if...
--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)

September 24, 2020 at 6:34 pm

#3790769
Reply To: Backup size
caz100 wrote:
<li style="list-style-type: none;">
Ok thanks ...I was starting to worry one of them one must be wrong.
Heh... you still might have a problem. Compression works well but normally...
--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)
September 24, 2020 at 6:17 pm

#3790762

Viewing 15 posts - 6,361 through 6,375 (of 59,089 total)