Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,341 through 5,355 (of 59,089 total)

Reply To: Partitioned Heap Table

qbrt wrote:
Hope that answers your question.
It does, indeed. Thanks for the feedback.
As a bit of a sidebar and especially since the partitioning is done on a temporal column, consider 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)

April 28, 2021 at 7:51 pm

#3877048
Reply To: Partitioned Heap Table

I'm just curious... Do you ever do SELECTs from this partitioned HEAP? Do you ever UPDATE any of the rows in the HEAP? What's the HEAP actually used for? It...
--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)

April 28, 2021 at 6:15 pm

#3877011
Reply To: Index rebuild

ScottPletcher wrote:
I still have to disagree on REORG if: (1) you can't use online rebuilds AND (2) the table has some serious fragmentation you need to address AND (3)...
--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)

April 28, 2021 at 6:11 pm

#3877009
Reply To: Swimming Servers

ratbak wrote:
Based on To cool datacenter servers, Microsoft turns to boiling liquid => 3M Immersion cooling for data centers, it sounds like it's one of these: Fluorinert™...
--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)

April 28, 2021 at 4:56 pm

#3876971
Reply To: Index rebuild

Ah... gotta be careful even with those conditions. If you can tolerate the extreme log file usage on such things (the 147/227GB table I cited above was fragmented only my...
--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)

April 28, 2021 at 4:48 pm

#3876969
Reply To: Index rebuild

premkuttan wrote:
It has both reorg and rebuild. My index job runs through a different tool so it keeps to retry even if there is a interruption in SQL connection
REORGANIZE...
--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)

April 28, 2021 at 3:53 pm

#3876948
Reply To: Swimming Servers

There aren't many types of fluids that have the behavior described in the article. They usually fall into the general category of "Refrigerant" and most of those are pretty nasty...
--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)

April 28, 2021 at 2:21 pm

#3876913
Reply To: Different backup folders (Full, Diff and Log) using ola script

EasyBoy wrote:
We already keep 1 month of backup on drive and anything above that should transfer to shared backup network and that is the requirement of client.
Does that one...
--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)

April 28, 2021 at 3:11 am

#3876640
Reply To: Index rebuild

premkuttan wrote:
I have a DB of size 240 GB and when the rebuild index job runs the log file grows upto 300 GB. I do a online reindex activity....
--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)

April 27, 2021 at 10:51 pm

#3876576
Reply To: Different backup folders (Full, Diff and Log) using ola script

Yes, but not the way you think. It's a mistake to move only the FULL backups. You have no chance of restoring to a given time without the log files. ...
--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)

April 27, 2021 at 10:49 pm

#3876575
Reply To: HEAP fragmentation percent is high

juliava wrote:
if i have table not HEAPA and cant mannually rebuild or reorganize,persantage still the same,what else can be done?
How big or small is the table? Some tables are...
--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)

April 27, 2021 at 10:47 pm

#3876574
Reply To: Finding columns with null values

Yep... I was looking at his code, as well. It appears that the OP wants only columns that contain nothing but nulls.
--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)

April 27, 2021 at 9:28 pm

#3876547
Reply To: Database gets locked while copying tables from another Server

Agreed... Scott hit the nail on the head on this one, for sure. I've run into the identical problem several times and ended up doing just like Scott posted.

--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)

April 27, 2021 at 5:33 pm

#3876446
Reply To: Finding columns with null values

I'm with ya on having some good stuff in the Master database. I agree that a lot of people poo-poo such things but it works incredibly well especially if you're...
--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)

April 27, 2021 at 4:04 pm

#3876384
Reply To: Types of indexes available in SQL Server 2019

Ant-Green wrote:
Good question and well versed given the referenced link
I said 13 as you can create indexes on persisted columns as referenced in a child document, https://docs.microsoft.com/en-gb/sql/relational-databases/indexes/indexes-on-computed-columns?view=sql-server-ver15
It's a real...
--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)

April 27, 2021 at 3:52 pm

#3876374

Viewing 15 posts - 5,341 through 5,355 (of 59,089 total)