Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,376 through 6,390 (of 59,089 total)

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
Reply To: How to create a minimal tally table and to describe its advantages (if any)

Steve Collins wrote:
However, it appears the OP didn't go for it and just only wants his kludge to be made to work.
Considering the way the OP asked the question, I'm not...
--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:52 am

#3790543
Reply To: Size of table

caz100 wrote:
Hi
This probably a silly question but.....
If I query the size of a table and it shows 20 gigs in size, when I do a select * from that table...
--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:31 am

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

The reason why I wanted you to post your test harness is because you claimed that the Tally solution took 19 MINUTES to the rCTE's 12 MINUTES on that 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)

September 23, 2020 at 10:58 pm

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

Steve Collins wrote:
Jeff Moden wrote:
Steve Collins wrote:
Here's another one. It took 19 minutes vs 12 minutes for the rCTE. There's no sample data and no time for making any up. Hopefully the query...
--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 23, 2020 at 10:19 pm

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

jcelko212 32090 wrote:
I showed you can be put in a CTE, a view or used as a standalone query as needed.
Nope... you may have mentioned it but you've not "shown" anyone...
--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 23, 2020 at 10:18 pm

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

Steve Collins wrote:
Here's another one. It took 19 minutes vs 12 minutes for the rCTE. There's no sample data and no time for making any up. Hopefully the query is sound. ...
--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 23, 2020 at 9:37 pm

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

Steve Collins wrote:
jcelko212 32090 wrote:
Any time I've needed to populate a table of sequential numbers, I just done it by brute force. No recursion or fancy stuff. Remember the definition of place...
--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 22, 2020 at 11:29 pm

#3790240
Reply To: Dear Past Me on My First Day as a DBA

Cebisa wrote:
You definitely do work with all departments in the company, which is an aspect of the job that I like.
Heh... when I first heard of "DevOps", my thought was...
--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 22, 2020 at 5:15 pm

#3790164

Viewing 15 posts - 6,376 through 6,390 (of 59,089 total)