Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 59,082 total)

Reply To: Database copies (cross environment) and sizing strategies for 2019

It's always a pain. Have you considered investing in something like "SQL Clone" from RedGate?
Redgate also has tools to help you modify PII so that it's no longer PII... it'll...
--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)

January 31, 2023 at 12:27 am

#4143481
Reply To: Azure Managed Instance Maintenance

Tom Uellner ,
If you're still around, do you have any links on the subject at hand?
--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)

January 30, 2023 at 11:54 pm

#4143476
Reply To: Azure Managed Instance Maintenance

Thanks, Grant. I remember you speaking of Brad's input on the subject before. I've not found it, yet, either.

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

January 30, 2023 at 11:53 pm

#4143475
Reply To: Azure Managed Instance Maintenance

I realize this thread is a couple of years old now but, I have to ask the question, can either of you share some links to articles where someone states...
--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)

January 30, 2023 at 6:53 pm

#4143431
Reply To: AWS : SqlServer to Postgree continous replication

thbaig wrote:
I want to replicate them continuously (once a day) on postgres.
Wholesale table change or only things that have changed?
Either way, I'd explore the possibility of a BCP OUT...
--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)

January 30, 2023 at 5:08 pm

#4143396
Reply To: The Complexity of Metrics

Heh... another "metric" that I'm really sick and tired of is "index fragmentation", especially when it comes to 3rd party vendors, both good and bad. You call them and ask...
--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)

January 30, 2023 at 3:21 pm

#4143340
Reply To: Read data based on date-range in huge table is slow

durai nagarajan wrote:
Hello Jeff ,
thanks but i suggested to consider not to create directly. as i don't see the plan, I suggested based on the data column he pulled.
I never created...
--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)

January 30, 2023 at 2:54 pm

#4143315
Reply To: DB Size

Talha222 wrote:
Optimizing indexes: Reorganizing or rebuilding indexes can improve the performance of a database and potentially reduce its size.
I strongly recommend against the use of Reorganize. It simply doesn't 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)

January 30, 2023 at 2:36 pm

#4143313
Reply To: Read data based on date-range in huge table is slow

durai nagarajan wrote:
Can you consider Columnstore index , non clustered, if you need many columns & read is huge in the DB query.
Can we have full plan or highly used area...
--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)

January 30, 2023 at 4:51 am

#4143115
Reply To: The Complexity of Metrics

Great article. PLE reminds me of the "tree falling" riddle...
"If a tree falls in the forest (PLE crashes and starts coming back up) and no one was there to hear...
--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)

January 30, 2023 at 4:38 am

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

SGAB, I had high hopes for the new GENERATE_SERIES() function in 2022, which I finally took the time to download the Developers Edition for and install. Things were looking promising...
--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)

January 30, 2023 at 4:26 am

#4143109
Reply To: Single index reorg took 2 full days or more to complete

p.s. If you want to see a presentation on all this, here's one that talks a lot about Random GUIDs just because they're the "poster child" for fragmentation. It shows...
--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)

January 30, 2023 at 3:29 am

#4143103
Reply To: Single index reorg took 2 full days or more to complete

JasonO wrote:
Or instead of reorg, will it be faster if I just rebuild index instead?
The answer to that question is a resounding OMG YES!!!! Even if you're in the Full...
--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)

January 30, 2023 at 3:23 am

#4143102
Reply To: DB Size

It sounds to me like the database was defined that large to begin with. And, no... SQL Server doesn't reduce the file size when data is deleted, either.
--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)

January 30, 2023 at 2:21 am

#4143086
Reply To: ROUND or CONVERT the output of the POWER function

And do remember that the resulting number is actually huge coming in at E33 and isn't just 3.97. Because of that, I'm seriously doubting this whole formula... especially since 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)

January 29, 2023 at 5:40 pm

#4143021

Viewing 15 posts - 2,056 through 2,070 (of 59,082 total)