Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 59,091 total)

Reply To: inserting into varchar field doesn't error when > 8000 bytes

robh0502 wrote:
hi,
Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why this happens.
I've got a table field with datatype varchar(10). If a value greater...
--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 14, 2023 at 6:09 am

#4307858
Reply To: inserting into varchar field doesn't error when > 8000 bytes

robh0502 wrote:
hi,
Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why this happens.
I've got a table field with datatype varchar(10). If a value greater...
--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 14, 2023 at 6:06 am

#4307857
Reply To: Alerts to my SQL Server

Better yet, click on the following MS Documentation about alerts and teach yourself something new. It'll look better on your resume, as well.
https://learn.microsoft.com/en-us/sql/ssms/agent/alerts
--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 14, 2023 at 3:58 am

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

Viewing 15 posts - 1,051 through 1,065 (of 59,091 total)