Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 59,099 total)

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
Reply To: Reorganising field in a table

ScottPletcher wrote:
Perhaps you could create a view with the columns in your (client's) preferred order? It it was a full view, it should be updatable and therefore the view name...
--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:54 pm

#4301450
Reply To: SELECT blocking DML and DDL

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

October 4, 2023 at 2:51 pm

#4301331
Reply To: Reorganising field in a table

richardmgreen1 wrote:
Is there a way to reorganise the fields into alphabetical order without creating a new table and transferring all the data?
That is, quite possibly, the worst table design idea...
--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 2:49 pm

#4301330
Reply To: High tempdb usage alternatives

Heh... Ok! The OP has left the building!
--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 2:07 pm

#4301304

Viewing 15 posts - 1,066 through 1,080 (of 59,099 total)