Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,046 through 6,060 (of 59,072 total)

Reply To: IDENTITY only allowed on one table at a time?

Based on what you said about being able to recover from bad deletes and updates, my recommendation would be to setup the tables for System-Versioned Temporal Tables. That means 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)

November 23, 2020 at 4:14 am

#3812860
Reply To: Sql server does not go above 50% CPU

andre1992 wrote:
Hi Jeff,
I set it to 0, And please, could you answer the other question I asked?
Thanks.
On the above, you might want to check your baseline performance for a couple...
--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)

November 23, 2020 at 4:02 am

#3812858
Reply To: Backup time not reducing even after DB size went down 300 GB

PJ_SQL wrote:
Database was 500Gb, 200 GB worth data deleted and then shrink files to reclaim space, backup was taking 2 hours before and still taking same time after database reduced...
--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)

November 23, 2020 at 3:56 am

#3812856
Reply To: Sql server does not go above 50% CPU

andre1992 wrote:
Yes Anthony,
It was just the MAXDOP set to 2!! Now it's back to working properly.
Also analyzing the differences with the previous server, I noticed that the Full-Text Upgrade Option...
--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)

November 22, 2020 at 8:54 pm

#3812784
Reply To: VBA Equivalent for DoCMD.TransferText

I don't know VBA but, looking up the command, I'm thinking that BCP.EXE using the "query out" option might do it for you (and it's nasty fast). I don't know...
--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)

November 22, 2020 at 8:50 pm

#3812783
Reply To: How to rank the records

Angela4eva wrote:
Awesome
The question now is... do you know how and why it works?
https://www.google.com/search?dense_rank+sql+server
--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)

November 22, 2020 at 7:33 pm

#3812770
Reply To: How to rank the records

Use DENSE_RANK instead of RANK in pietlinden's code.
--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)

November 22, 2020 at 7:02 pm

#3812763
Reply To: Backup time not reducing even after DB size went down 300 GB

PJ_SQL wrote:
Deleted data and shrink the data files
Understood as to what you've done. Phil's question is what were the conditions before the shrinks? For example, if your database had a...
--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)

November 22, 2020 at 6:57 pm

#3812760
Reply To: IDENTITY only allowed on one table at a time?
thetubageek wrote:
OK, let me start by answering your questions/concerns:
- The Trigger methodology I am using is what wasa showed to me. I figured it would be good for a "first...
--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)
November 22, 2020 at 6:36 pm

#3812757
Reply To: The Wide Impact of PASS

That's what I'm thinking, as well, but I just didn't want to assume.
--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)

November 21, 2020 at 11:20 pm

#3812588
Reply To: IDENTITY only allowed on one table at a time?

Lordy... why are you using a homegrown temp table version of a cursor to do this? It requires you to materialize the DELETED logical table, has two forms of RBAR...
--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)

November 21, 2020 at 4:59 pm

#3812521
Reply To: IDENTITY only allowed on one table at a time?

I have a question based on the error... do you have Replication running or did you have SET IDENTITY _INSERT ON turned on for a table? It's not easy 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)

November 21, 2020 at 2:31 pm

#3812330
Reply To: The Wide Impact of PASS

My apologies, Grant. There's a bit of confusion on my part from your answer. Your article seemed to indicate that PASS was in a bit (probably an understatement) of financial...
--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)

November 21, 2020 at 2:25 pm

#3812329
Reply To: The Wide Impact of PASS

Does that mean that the virtual summit didn't take in as much as was needed, Grant?
--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)

November 21, 2020 at 4:54 am

#3812235
Reply To: Replaced deprecated types (text, ntext) with Varchar(max) and NVarchar(max) !

Yes... the deprecated types should be changed to the modern types... or at least according to MS. So here's how to fix some of the mistakes MS made when creating...
--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)

November 21, 2020 at 3:40 am

#3812222

Viewing 15 posts - 6,046 through 6,060 (of 59,072 total)