Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Solution – Puzzle – Statistics are not Updated but are Created Once

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Statistics
Earlier I asked puzzle why statistics are not updated. Read the complete details over here: Statistics are not Updated but are Created Once In the question I have demonstrated even though statistics should have been updated after lots of insert in the table are not updated.(Read the details SQL SERVER –…
Read More

SQL SERVER – Running SSIS Package in Scheduled Job

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Utility

I previously wrote article SQL SERVER – Import CSV File into Database Table Using SSIS. I was asked following question by reader that how to run the same SSIS package from command prompt. In response to the same I have written article SQL SERVER – Running SSIS Package From Command Line. Within few minutes of the blog post, I received email from another blog reader asking if this can be scheduled in SQL Server Agent Job.

Read More