Jeff Moden

Forum Replies Created

Viewing 15 posts - 586 through 600 (of 59,063 total)

Reply To: Are the posted questions getting worse?

Dear Steve Jones...
I forget how long it's been since this site was moved to WordPress but it's been a long time. Those of us long-timers that are left (not many...
--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)

May 8, 2024 at 3:48 am

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

Shop size doesn't matter to me. What matters is the attitudes of management on both the Dev and Database sides of the house and the attitudes of the folks on...
--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)

May 8, 2024 at 3:44 am

#4419627
Reply To: some questions related to Ola hallengren maintenance scripts

MMartin1 wrote:
Jeff Moden wrote:
vsamantha35 wrote:
Hi All,
I have couple questions related to Ola Hallengren's maintenance script. If anyone has the answers, please do reply.
1. In which order the rebuild and update stats...
--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)

May 8, 2024 at 3:33 am

#4419624
Reply To: The DBAccountant

I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all the "I told...
--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)

May 8, 2024 at 3:15 am

#4419619
Reply To: Multi row tally query with max value

Ok... I had a look. First, I've got to say I don't know why supposed scientists are willing to lose data by rounding it. Whatever.
Looking back at this thread, Jonathan...
--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)

May 8, 2024 at 3:08 am

#4419618
Reply To: Multi row tally query with max value

@ibbo14,
I've grown to trust more in zip files being benign and like them a whole lot better than having to go to some other site to get them. Still, there...
--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)

May 8, 2024 at 1:51 am

#4419608
Reply To: Are IT Certifications Still Relevant?

To be honest, certifications were never relevant to me. I was considering becoming certified 2 decades ago but then I ran into two people that were working for the same...
--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)

May 8, 2024 at 1:25 am

#4419605
Reply To: Knowing What You Don’t Know

Eric M Russell wrote:
Sharing what we think we know with others (external validation) is a good way to learn what we didn't know before. Even the "resident SQL Server expert" in an...
--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)

May 8, 2024 at 12:16 am

#4419595
Reply To: SQL-CTE reqursive query

Last but not least... your the one that will need to " 'splain'n'maintain" this... do you understand how it all works?
--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)

May 7, 2024 at 11:59 pm

#4419594
Reply To: SQL-CTE reqursive query
p.s. If you need the Sequence Number to restart for each ticket, then just add a PARTITION BY, as follows...
```
--===== Solution using "Relational Multiplication"
 SELECT  tt....
```
--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)
May 7, 2024 at 11:56 pm

#4419593
Reply To: SQL-CTE reqursive query

jjjohn wrote:
I have table TicketNumbers
i     TicketNumber UID
2    10                        09901a22c7c3acc6786847c775f1d113
6    5                          00dad28bef21f916240d6e8c1c1bd67d
12 20    00dad28bef21f916240d6e8c1c1bd67d
I need to produced 35 rows (UID...
--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)

May 7, 2024 at 11:40 pm

#4419592
Reply To: Performance

So, the next step is... post the code for the view.
--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)

May 7, 2024 at 11:08 pm

#4419585
Reply To: An in-depth look at change detection in SQL Server - Part 02
It's an old article that I hadn't seen before. I like it a lot and just used it instead of me having to do a long winded explanation to someone...
- This reply was modified 2 years ago by Jeff Moden.
--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)
May 6, 2024 at 9:17 pm

#4419140
Reply To: Plan Cache refreshing every 24 hours

The update stats job you have running every night isn't a huge problem. The rebuilding of plans is usually not a problem. Having stats rebuild in the middle of 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)

May 4, 2024 at 3:54 pm

#4418557
Reply To: What does it mean when Query Store Tracked Queries shows the same Plan Id twice?

Jo Pattyn wrote:
The square ones didn't complete
https://joeydantoni.com/2016/11/02/circles-and-squares-what-do-they-mean-in-the-query-store/
Interesting... you might want to let joey know. Some people will be able to see the site. I can't because my system has higher...
--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)

May 3, 2024 at 3:30 am

#4418029

Viewing 15 posts - 586 through 600 (of 59,063 total)