Jeff Moden

Forum Replies Created

Viewing 15 posts - 511 through 525 (of 59,063 total)

Reply To: indexes cleanup
Hey there, Sam...
I took a look at your index spreadsheet. That's a good thing but it's missing some critical information...
1. Add an IsUnique column to identify if the index 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)
June 20, 2024 at 3:36 pm

#4430058
Reply To: Have you seen this in the news today?

There is some original basis of truth in rumor and old wives tales. While you place no faith in Fox, it did make people at least look.
While your opinion that...
--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 18, 2024 at 4:46 pm

#4429460
Reply To: Is Perfect Software Attainable?

Ah... I found the word I was looking for...
Lookup the term "enshittification". It's a term that was coined by XXXXXXXXXX in 2022 and became the "word of the year" 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)

June 18, 2024 at 3:54 pm

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

Understood. Thanks for the feedback, Steve.
--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 17, 2024 at 7:51 pm

#4429093
Reply To: Is Solution PIVOT?

As an important sidebar, I don't know why you need to do this but it's generally a really bad idea to denormalize data in such a fashion. Maybe post 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)

June 16, 2024 at 7:28 pm

#4428849
Reply To: Find Unused or Backup Tables

harriga.rabie-1008938 wrote:
Hi All ,
fitst you need to disable all maintenance plan , perhaps your rebound or organise process all table without considering fragmentation .
also tha sal server audit can...
--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, 2024 at 6:40 pm

#4428846
Reply To: Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps

Lowell wrote:
change the database compatibility to SQL2019 prior to the items below.
the optimizer is different between versions, so it's pretty standard to have to, at a minimum, rebuild statistics with...
--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, 2024 at 6:32 pm

#4428845
Reply To: Cabot connect to Prod1

Phil Parkin wrote:
What is 'Cabot'?
I second that question.
--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, 2024 at 6:26 pm

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

@Grant Fritchey,
I think you'll absolutely love the following article...
https://getpocket.com/explore/item/looking-to-ditch-twitter-morse-code-is-back

--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, 2024 at 2:03 pm

#4428245
Reply To: large transaction log backups

Is someone doing any form of Index Maintenance? It may not be in a separate job somewhere.... it may be something that someone has added to a stored procedure 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 12, 2024 at 9:54 pm

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

Steve Jones - SSC Editor wrote:
If you can send a note to marketing@ with your specific complaints or issues, that will help. There is a proposal up with our internal IT staff/developers to do...
--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, 2024 at 12:39 am

#4427899
Reply To: blocking due to cuncurrency problem.
Jonathan AC Roberts wrote:
To stop the table locking you could use a rowlock hint:
```
-- Ensure we are using row-level locking
SELECT @intID = (idPool + 1)
  FROM IdConfiguration WITH...
```
--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, 2024 at 1:38 pm

#4427689
Reply To: blocking due to cuncurrency problem.
ScottPletcher wrote:
Jeff Moden wrote:
```
DECLARE  @intID    BIGINT
        ,@bridgeid BIGINT = 1
;
 UPDATE dbo.bridge 
    SET...
```
--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, 2024 at 2:46 am

#4427588
Reply To: blocking due to cuncurrency problem.

SQL BrainBox wrote:
Try not to specify the idPool column twice in the same Update statement and get rid of the Select statement.
The select statement where criteria is the same as 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)

June 11, 2024 at 2:43 am

#4427587
Reply To: Using USE does not set DB context

The Dynamic SQL is executed in a different context.
--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 10, 2024 at 10:03 pm

#4427566

Viewing 15 posts - 511 through 525 (of 59,063 total)