Jeff Moden

Forum Replies Created

Viewing 15 posts - 601 through 615 (of 59,063 total)

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
Reply To: Table with FK(s) to other columns within the table

ratbak wrote:
Take a look at Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets & Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations from...
--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 23, 2024 at 6:57 pm

#4414666
Reply To: Db growth rate

mtz676 wrote:
Is there are db growth rate formula which can be used to predict say next 3/6 months of db growth rate.
Yes. It's known as "Linear Regression Analysis". I'm giving...
--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 23, 2024 at 6:55 pm

#4414665
Reply To: Hardcoded filter vs filter by parameter

blom0344 wrote:
Adding the option (recompile) slows it down even further , taking an additional 30 seconds to start the dataflow
Heh... now that's interesting. And, I just noticed... this is for...
--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 23, 2024 at 1:28 am

#4414305

Viewing 15 posts - 601 through 615 (of 59,063 total)