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

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

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

Unblocking stuck 2nd page of this thread...

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

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

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

If they send the CSV data in a file, then the data could be imported using BULK INSERT.  This would be...

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

I take your point though I  think you are mistaking refactoring...

As a bit of a sidebar, it's always fascinating to me to watch how people do...

Heh... sounds like you already...

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

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

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