Jeff Moden

Forum Replies Created

Viewing 15 posts - 526 through 540 (of 59,069 total)

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
Reply To: blocking due to cuncurrency problem.

This is a classic "Get NextID" issue.
It would also be nice if, when you posted a code example to explain your problem, that it would at least compile. BridgID 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 10, 2024 at 4:44 pm

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

cyrusbaratt wrote:
Here you go Jeff:
Thank you! That'll help others, as well as preventing future dead links.
--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 4:10 pm

#4427470
Reply To: Is date zero valid and if so what day is it?

Just to add to this (Great question, BTW!)...
The zero is known as a "Date Serial" number. DATETIME and SMALLDATETIME are capable of using Date Serial numbers directly whereas DATE, DATETIME2...
--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 4:05 pm

#4427469
Reply To: Is Perfect Software Attainable?

My biggest problem with all of this is that people keep poo-pooing the words "perfect" and "perfection". That, in itself, isn't a problem but what people think after all 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 8, 2024 at 2:39 pm

#4427133
Reply To: Transferring millions of records in live production

saum70 wrote:
Hello Jeff. Thanx for reply. I have never come across synonyms. Read some info on it. I am not really sure it will work. Anyways the old data will...
--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 7, 2024 at 9:44 pm

#4427001
Reply To: Transferring millions of records in live production

Have two tables... for example, TableA1 and Table A2.
Start out with a synonym called TableA and have it pointing at TableA1.
Have another synonym called TableAWork and have it pointing at...
--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 6, 2024 at 7:28 pm

#4426672
Reply To: Creating an Index with a lot of Columns

Might just be me but the only time I'll look at any missing index recommendations is when there's a slow query that could really use some help. Adding indexes 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 6, 2024 at 7:00 pm

#4426668
Reply To: Transferring millions of records in live production

What is supposed to happen to the 5 million rows in Table A AFTER you've copied them to Table B and is Table B on the same database and 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)

June 6, 2024 at 6:45 pm

#4426666
Reply To: Using AI for the First Draft

I agree with David Poole. To put it all in less formal terminology, I've found that tools like ChatGPT are nothing more than a very sophisticated consensus engine and, sadly...
--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 5, 2024 at 2:09 pm

#4426388

Viewing 15 posts - 526 through 540 (of 59,069 total)