Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 59,063 total)

Reply To: high VLF proactive monitoring

It's not like the VLF count will go down auto-magically and so your morning report should do just fine in reporting databases that have a high VLF count. If 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)

October 13, 2023 at 5:24 am

#4307149
Reply To: Anybody have recommendations for backing up a large number of databases?

Yes. Ola Hallengren's backup solution. It's good and it's free. I'm going to recommend that you do what a lot of people seem to not do... STUDY HIS DOCUMENTATION BEFORE...
--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)

October 13, 2023 at 5:10 am

#4307148
Reply To: Is it always better to redo a database, when upgrading an application?

Rod at work wrote:
Jeff Moden wrote:
You haven't mentioned as to whether or not the redesigns are somehow better when all is said and done.
Personally, I'd just ask the boss.
I thought I had. Well,...
--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)

October 12, 2023 at 7:19 pm

#4306895
Reply To: Is it always better to redo a database, when upgrading an application?

You haven't mentioned as to whether or not the redesigns are somehow better when all is said and done.
Personally, I'd just ask the boss.
--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)

October 11, 2023 at 11:05 pm

#4306230
Reply To: How do I keep the cost of an Azure SQL Database down?

Doctor Who 2 wrote:
Jeff, I've taken your suggestion. I didn't migrate one of our databases to Azure. Instead, I created an Azure SQL database using one of the AdventureWorks databases. It's small,...
--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)

October 11, 2023 at 3:37 am

#4305555
Reply To: Database recovery

It sounds to me like someone may have tried to move the database files and failed to do it correctly. The MDF file may still exist someone on one of...
--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)

October 10, 2023 at 5:46 pm

#4305284
Reply To: High tempdb usage alternatives

anoop.mig29 wrote:
Well i think its increase both log and mdf/ndf files of tempdb .How to get size of temp table ?
For the first statement, you don't actually know if that's...
--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)

October 9, 2023 at 11:01 pm

#4304708
Reply To: Confidence

skeleton567 wrote:
"A confident person often convinces others that they're right, by sheer force of will."
Ooooo maaannnn... you hit a real "hot spot" there for me.
One of my favorite examples 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)

October 9, 2023 at 9:36 pm

#4304676
Reply To: get week number of month

I seriously agree about the ISO thing. It's a real shame that MS hasn't made a few more built in functions around ISO Week and Year.
I advise caution when using...
--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)

October 9, 2023 at 9:07 pm

#4304663
Reply To: Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

david.wright-948385 wrote:
Does it recommend against using '--' as comment delimiters 😛
But seriously, good luck on this, Steve.
Steve didn't write it. His name shows up here because he's the person 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)

October 7, 2023 at 6:05 pm

#4303508
Reply To: SELECT blocking DML and DDL

vsamantha35 wrote:
Jeff Moden wrote:
vsamantha35 wrote:
Thank you All.
Two way street here, Sam. You've not answered my question above. Why is someone trying to Truncate a table while others are trying to SELECT...
--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)

October 5, 2023 at 12:05 am

#4301621
Reply To: Baking up and restores VLDBs

Michael L John wrote:
I'm not sure that I'd mess with BLOCKSIZE but I definitely agree with experimenting to find the best MAXTRANSFERSIZE and the BUFFERCOUNT.
BLOCKSIZE makes a big difference when backing up...
--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)

October 4, 2023 at 6:38 pm

#4301472
Reply To: Baking up and restores VLDBs

Michael L John wrote:
tzimie wrote:
Hm. Some of our databases are 20Tb. Total 80Tb on one server, takes more than a day for full backup.
How many backup files are you creating with these...
--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)

October 4, 2023 at 6:04 pm

#4301462
Reply To: Error of No Corresponding Begin Tran not getting simulated

saum70 wrote:
Hello,
I have come across this peculiar problem.
This stp is called every begin of the day of the application startup. A bug got introduced in the stp.
The BEGIN TRAN was...
--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)

October 4, 2023 at 6:01 pm

#4301460
Reply To: Index Rebuild and Reorg - how to in VLDB 24/7 env

Michael L John wrote:
I'm curious as to what measurable benefit you realized from performing reindexing / reorg on your indexes?
😉
--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)

October 4, 2023 at 5:57 pm

#4301458

Viewing 15 posts - 1,021 through 1,035 (of 59,063 total)