Jeff Moden

Forum Replies Created

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

Reply To: To partition or not to partition

Heh... apparently 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 18, 2023 at 6:34 pm

#4310621
Reply To: tempdb sizing

Thumbs up to the previous 2 replies. The code is in serious need of some real help and the Developers need to be taught how to write good code. I'm...
--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 18, 2023 at 6:26 pm

#4310591
Reply To: To partition or not to partition

@ericwenger1,
Any chance of you posting the CREATE TABLE statement along with the indexes and constraints? We might be able to make some additional suggestions, once we see 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 15, 2023 at 9:38 pm

#4308662
Reply To: Backup to SQL Server NULL device

I realize that this is a wicked old post but thought I'd add why I use a backup to NUL.
I do it for testing code demonstrations, especially demonstrations concerning "Minimal...
--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 15, 2023 at 6:43 pm

#4308612
Reply To: Count only unique dates from a subquery

JeremyU wrote:
Hello,
I have a question.
Me too. Where's the "Readily Consumable" test data and the desired results that match the test data?
With that being said, be advised... You've been asked to...
--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:07 pm

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

Rod at work wrote:
I might do that. I confess I've reached a point where I've learned not to ask. Asking tends never to get an answer, only stares. So, learn helplessness.
Still, I'd...
--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:17 am

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

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