Skip to main content

Posts

Showing posts from April, 2015

How to export performance metadata and statistics

Performance of query execution (stored Procedure or Ad-hoc query) is depends on Execution Plan and execution plans depend on Statistics-histogram. We already know Query Statistics is metadata of database engine which depend on data. Every insert-update-delete changes its stats.

SQL server allowing us to export and copy to another server. So we can use it to sync the performance of server during quality or testing of procedures and queries.
Step Connect to Production Server and right click on database.In the list just choose Generate Script.Now click on next and Choose Advance option button.Then select script statistics and then Next and Finish.This will generate Script just copy these script and run on Quality server/Testing Server Database.





Happy Reading...


Csharpcorner Annual Conference 2015

Hi friends, how are you? Hope you are doing well, as always I am cool. It was 2nd time when I didn’t missed Csharpcorner Annual Conference. Rain could not stop my 3 months waiting, yeah… heavy rain in NCR on 4th April. Organizer Mind Crackers and sponsoredInfralogistics, Aspose , MCN Solution and Plural Sight, done well in this year. Microsoft were technical partner of this event. I reached on time with my colleague @ Country Inn Sahibabad, Ghaziabad, UP. The main highlights were the no of attendees it was about 1200 including MVPs, 20 most popular speakers and 28 different sessions on two different tracks (Grand Ball Room for Technology and Majestic for Platform).
Sumit jolly started event as host and later Mahesh Chand sir keep the Keynotes in front of us who is the owner-director of CSharpcorner community. The entire community is debtor of him because his effort helping us. He explain what New Technology came in 2014. He addressed the community how he started from 0 to till now. He …