Fragmentation can cause performance issues. So do you advice me to change the order in any way.... Please tell me as what should be the order to...
Hi, We have a database with lots of DML operations everyday and as data grows we face the application running slow. So we have partitioned some...
Hi Hassan, There is a maintenance sheduled for our database which is run daily and the steps are as :- 1) Merge Partition 2) Set Next Partititon...
yes, there is a clustered index on these three columns
Hi, I am using temp tables to replace some inner queries to speed up the performance. The table in inner query has around 12 lakh records. Will it...
Hi Preethi, Thanks for looking into the query. I have pasted a formatted query only but once pasted here, it comes unformatted...don't know...
This sql query is beig run inside a procedure. But I have put in the constant values for the variables that came from procedure arguements and trying...
Hi This query is taking long time to run...may be because it has lot of joins. I am new to tuning. Please guide me as where to start on it and what...
Hi, In my application there are around 75 concurrent users accessing application at one time through internet. We need to increase the users upto...
Separate names with a comma.
