Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,361 through 3,375 (of 59,098 total)

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
Reply To: Datefirst format

Absolutely perfect. That graphic explains it all. I have a high performance idea on how to do this and I'll explore it tonight after work.
--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:24 pm

#4048763
Reply To: Datefirst format

LearnSQL wrote:
Jeff,
The above is the i/p which i receive my client which may having missing weeks data, so i need to populate 0 for missing weeks.
Also, actually it has two...
--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 12, 2022 at 9:10 pm

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

First thing I'd check for is the size of the log file being restored and then I'd check the original database to see the size and how many VLFs are...
--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 11, 2022 at 6:44 pm

#4048081

Viewing 15 posts - 3,361 through 3,375 (of 59,098 total)