Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,076 through 6,090 (of 59,101 total)

Reply To: How to reduce physical size of database

Jo Pattyn wrote:
You might want to try out table/index pagecompression to reduce the size
Totally agreed, especially for a database that is becoming "Read Only". Still, row and page compression will not...
--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 2:19 pm

#3813064
Reply To: The Wide Impact of PASS

Ok. Thank you, 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 23, 2020 at 1:40 pm

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

I previously provided you with a link to the Temporal Tables documentation and it has examples, etc, with different links for different things. Of course, if you want the quick'n'dirty...
--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 5:42 am

#3812873
Reply To: Rough Consensus

I've found that too many people apply too much consensus and not enough test code. It's one of the main problems in a lot of IT shops. There's also 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)

November 23, 2020 at 4:46 am

#3812862
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

Viewing 15 posts - 6,076 through 6,090 (of 59,101 total)