Jeff Moden

Forum Replies Created

Viewing 15 posts - 631 through 645 (of 59,091 total)

Reply To: An in-depth look at change detection in SQL Server - Part 02
It's an old article that I hadn't seen before. I like it a lot and just used it instead of me having to do a long winded explanation to someone...
- This reply was modified 2 years, 3 months ago by Jeff Moden.
--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)
May 6, 2024 at 9:17 pm

#4419140
Reply To: Plan Cache refreshing every 24 hours

The update stats job you have running every night isn't a huge problem. The rebuilding of plans is usually not a problem. Having stats rebuild in the middle of 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)

May 4, 2024 at 3:54 pm

#4418557
Reply To: What does it mean when Query Store Tracked Queries shows the same Plan Id twice?

Jo Pattyn wrote:
The square ones didn't complete
https://joeydantoni.com/2016/11/02/circles-and-squares-what-do-they-mean-in-the-query-store/
Interesting... you might want to let joey know. Some people will be able to see the site. I can't because my system has higher...
--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)

May 3, 2024 at 3:30 am

#4418029
Reply To: How to create a baseline using counters to analyze server performance?

My recommendation would be to buy a tool. This site exists based on the generosity of RedGate. Perhaps their monitoring to tool would save you some time, aggravation (now and...
--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)

April 29, 2024 at 10:04 pm

#4416813
Reply To: process records in loop

Unblocking stuck 2nd page of this thread...
--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)

April 29, 2024 at 2:17 am

#4416464
Reply To: process records in loop

Bruin wrote:
I can easily make it a csv file for Bulk Insert and YES there will be data on the Insert statements that have:
VALUES('967120411','864A90D40','CORP','Standard'
Can you show me the frame work...
--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)

April 27, 2024 at 4:44 pm

#4416160
Reply To: One more reason to use foreign key constraints

Good article. Thanks for taking the time to write it up and post it.
Just like humans, AI can use all the help it can get but (and just to say...
--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)

April 27, 2024 at 3:47 pm

#4416153
Reply To: some questions related to Ola hallengren maintenance scripts

vsamantha35 wrote:
Hi All,
I have couple questions related to Ola Hallengren's maintenance script. If anyone has the answers, please do reply.
1. In which order the rebuild and update stats run. 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)

April 27, 2024 at 1:40 am

#4415995
Reply To: process records in loop

Bruin wrote:
Jeff,
How would data being in csv be handled differently?
Thanks.
If they send the CSV data in a file, then the data could be imported using BULK INSERT. This would be...
--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)

April 27, 2024 at 1:04 am

#4415991
Reply To: process records in loop

Bruin wrote:
thanks The sqltoexec are passed in sql statements like:
INSERT INTO cstDetails (CompPartNbr,PartNbr,PlantCd,CostKey,usgQty,scrQty,totQty,UnitCost,usgCost,scrCost,totCost,StrJCost,StrMCost,SetUpQty,SetUpCost,CurrentOPRSetup) VALUES('967120411','864A90D40','CORP','Standard',0.2697,0.0043152,0.2740152,6.5,1.75305,0.0280488,1.7810988,0,0,0,0,0)
The CrtInsert table has a PK field called ID(int)
In the example how do I loop thru thousands...
--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)

April 26, 2024 at 5:07 pm

#4415837
Reply To: Toilets and Your Systems

David.Poole wrote:
Jeff Moden wrote:
You have to be really careful here. Constant "refactoring" of anything is a really bad idea.
I take your point though I think you are mistaking refactoring...
--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)

April 26, 2024 at 4:40 pm

#4415826
Reply To: given value of type String from the data source cannot be converted to type nvar

bvi1998 wrote:
Yes, I am performing a bulk copy from PowerShell, from a csv file.
As a bit of a sidebar, it's always fascinating to me to watch how people 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)

April 24, 2024 at 4:24 pm

#4415062
Reply To: Toilets and Your Systems

Eric M Russell wrote:
So, on a submarine, you can't design the toilets to flush into the ballast tanks or maybe a designated septic tank that periodically gets evacuated?
Heh... sounds like you already...
--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)

April 24, 2024 at 4:13 pm

#4415061
Reply To: given value of type String from the data source cannot be converted to type nvar

Overall, what are you actually trying to do? Bulk insert from files to the database or???

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

April 24, 2024 at 2:19 am

#4414777
Reply To: Backing up and Restoring a 3 terabyte database takes over 5 hours

I can't speak for the cloud but I'm backing up a 4.7 TB database over NAS on-prem in 1 hour and 13 minutes. It's a single file backup but 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)

April 24, 2024 at 2:15 am

#4414776

Viewing 15 posts - 631 through 645 (of 59,091 total)