Viewing 15 posts - 586 through 600 (of 59,060 total)
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...
April 27, 2024 at 1:40 am
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...
April 27, 2024 at 1:04 am
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...
April 26, 2024 at 5:07 pm
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...
April 26, 2024 at 4:40 pm
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...
April 24, 2024 at 4:24 pm
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...
April 24, 2024 at 4:13 pm
Overall, what are you actually trying to do? Bulk insert from files to the database or???
April 24, 2024 at 2:19 am
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...
April 24, 2024 at 2:15 am
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...
April 23, 2024 at 6:57 pm
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...
April 23, 2024 at 6:55 pm
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...
April 23, 2024 at 1:28 am
I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple...
April 23, 2024 at 1:20 am
I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple SSRS report...
April 21, 2024 at 9:58 pm
This is very likely a case where the use of a statement level OPTION (RECOMPILE) will work perfectly and very quickly.
April 21, 2024 at 3:30 pm
Heh... you, of all people, should know about "double posting".
Folks, no answers here, please. Instead, go to the duplicate post and post there. Thanks.
April 19, 2024 at 3:25 am
Viewing 15 posts - 586 through 600 (of 59,060 total)