Tag: Performance Optimization

Best way to deal with Index Fragmentation

Fragmentation can hurt the performance of your query very badly. It is one of the key factor behind poor performing database. Many a times, DBA takes it very easy and respond when there is complete slowdown of the application. DBA respond to the situation in reactive manner instead of the proactive manner. It is essential to removes fragmentation and reclaims disk … Continue reading Best way to deal with Index Fragmentation

Work around to scalar functions – SQL Server

There is no harm in using the Scalar UDF’s if it is used for Arithmetic operation or other purposes which doesn’t involves accessing any table. Always create such Scalar UDF’s with SCHEMABINDING to avoid Spooling. But, Scalar UDF’s are not good option if it is accessing the table. Let us evaluate the above statement. We … Continue reading Work around to scalar functions – SQL Server