Dear Gianluca Sartori,

Is that beneficial to drop and recreate a more user-friendly name? Does it help in performance of insert, update, select operation? Could you please suggest?

Following block say...

I was checking the statistics objects in my Microsoft SQL Server database and found some statistics with strange names. Could you please explain what the _WA_Sys... statistics are? Why are...

Thanks Sir.

I take full database and Transaction log backup once a day at night time when there is almost no transaction in database. Can i shrink log file to 50%...

Dear Sir,

We have 2 Database one is R/W(read/Write) and another is Read only database. And R/W database server replicates data in R only database server. Given issue is in Read...

Dear Sir, I have kept execution from production.

Sir, I captured the execution plan in small data set where it executes in 6 seconds.

I have saved the execution plan Sir. I have executed in small database. This query has execution time as 8 seconds.

This table has 40 Lakhs records. It is taking currently 7 seconds. I need to bring its time to 1-2 seconds. Is it possible?

I have created index based on actual...

Thanks for reply. Reply could you please suggest on changed query for optimization.