Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,346 through 3,360 (of 59,086 total)

Reply To: Becoming a Better DBA

Wasn't it you, David, that said (admittedly paraphrasing a bit) "If you're the first person people seek out for help on a problem rather than the last, you might be...
--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)

June 16, 2022 at 6:08 am

#4050227
Reply To: Becoming a Better DBA

To be sure, I could never do the job that you do. Thanks for what you do.
As far as the article you posted a link to, it's pretty good advice...
--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)

June 15, 2022 at 4:40 pm

#4049981
Reply To: Datefirst format

As a bit of a sidebar, you listed your week numbers as follows...
W51-2021
W52-2021
W3-2022
That's actually a really bad thing for you folks to be doing because they're NOT sortable.
The week numbers...
--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)

June 15, 2022 at 3:26 am

#4049643
Reply To: Datefirst format

Ok... I think I'm ready for ya! 😀 Post some readily consumable data in the form of a CREATE TABLE statement and some data that's coded to be inserted into...
--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)

June 14, 2022 at 9:07 pm

#4049511
Reply To: Datefirst format

Steve Collins wrote:
I'm still thrown off by week 53. What? How does this work? This topic is the same as this other one I'm assuming
The week 53 problem is because...
--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)

June 14, 2022 at 5:56 pm

#4049430
Reply To: Datefirst format

Ok... I've got the week number part down to a nice, high speed single formula. I need to add the year in but it' 03:17 here and I have 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)

June 14, 2022 at 7:17 am

#4049154
Reply To: Dealing with Transaction Log Growth

Quite contrary to popular belief, index REBUILDs are NOT a problem compared to REORGANIZEs.
Here's just one example. I had a table that had an ever increasing Clustered Key that contained...
--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)

June 14, 2022 at 5:17 am

#4049101
Reply To: Convert Datetime to other format

For those interested, here's the profiler run I fan just a bit ago. It doesn't contain all the tests but it doesn't really matter because the extra tests just prove...
--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)

June 14, 2022 at 12:12 am

#4049010
Reply To: Convert Datetime to other format
Ed B wrote:
Jeff Moden wrote:
ratbak wrote:
Format could be derived like this:
CONVERT(CHAR(10),jobstarted,103) + ' ' + CONVERT(CHAR(8),jobstarted,108)
You indicate output as "Rome Time". What timezone/offset is your source data in?
I would...
--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)
June 13, 2022 at 11:38 pm

#4049006
Reply To: Convert Datetime to other format
ratbak wrote:
Format could be derived like this:
CONVERT(CHAR(10),jobstarted,103) + ' ' + CONVERT(CHAR(8),jobstarted,108)
You indicate output as "Rome Time". What timezone/offset is your source data in?
I would recommend just...
--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)
June 13, 2022 at 9:49 pm

#4048981
Reply To: Restore stalls around 97% done with PREEMPTIVE_OS_WRITEFILEGATHER

Sounds like the log file issue might be spot on according to the following link...
https://www.sqlskills.com/help/waits/preemptive_os_writefilegather/

--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)

June 13, 2022 at 5:34 pm

#4048886
Reply To: SQL help with Pivot

wrote:
Thanks for the suggestions.
Hi and welcome aboard.
Be advised that your post looks and smells like a precursor to spam. If you're a spammer, please go away. We're watching.
If your...
--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)

June 13, 2022 at 5:05 pm

#4048880
Reply To: Restore stalls around 97% done with PREEMPTIVE_OS_WRITEFILEGATHER

webrunner wrote:
Thanks so much, Jeff, I will review those articles.
Thanks again!
-- webrunner
My disclaimer is that I don't know if that's the actual problem. It's just one that people seem 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)

June 13, 2022 at 3:01 pm

#4048777
Reply To: old backup files

I use the term "Legacy Backups" when I need to politically correct terms so as not to be taken to task for what some people would call a "Visit 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)

June 13, 2022 at 2:53 pm

#4048774
Reply To: Converting a Date to an Integer (Computed Column)

The spam entry brought me back here.
@pekoms... you never got back to me on what unit of measure you wanted the result to actually be.
Just in case you still have...
--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)

June 13, 2022 at 2:40 pm

#4048772

Viewing 15 posts - 3,346 through 3,360 (of 59,086 total)