Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,346 through 6,360 (of 59,072 total)

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
Reply To: The 10X Programmer

skeleton567 wrote:
The greatest danger of a '10x programmer' or a 'superstar programmer' is WHO THINKS THEY ARE SUCH.
+1 Billion for that comment!!!
--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 3:12 pm

#3790712
Reply To: Key Lookup to Clustered Index

Adam Bean wrote:
Hey all,
Been a bit since I've been down this road. Clearly I'd assume this is as expected and I'm just old and rusty.
Attached is the execution plan I'm looking...
--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 3:11 pm

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

arvind.patil 98284 wrote:
Will it free the space temporary?
So in production its still happening and we needs a temporary solution for the time being. It will take us some time to fix...
--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 3:02 pm

#3790706
Reply To: The Last Compile Time

Great question but the answer is actually missing a bit of detail. If you look at the documentation at the link you've provided, it is sorely lacking in detail for...
--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 2:49 pm

#3790703
Reply To: Validate field in STaging before loading

Grant Fritchey wrote:
Check out the ISNUMERIC() function. That will tell you what you want to know.
No... ISNUMERIC() can help but it must not be considered as any type of "Is...
--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 2:24 pm

#3790694
Reply To: Index Fragmentation

stevec883 wrote:
I did get the table name to work --- will need to play around with it to get the database name, and the index name to be helpful.
In regards...
--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 1:47 pm

#3790681
Reply To: How to create a minimal tally table and to describe its advantages (if any)

Steve Collins wrote:
That's not how long the SQL code takes to execute. Tally based method would crush the OP's kludge especially as their test case is spanning thousands of days.
19 minutes...
--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 3:54 am

#3790545

Viewing 15 posts - 6,346 through 6,360 (of 59,072 total)