Tag: SQL Server

Generic trigger for audit log – SQL Server

  Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.


SSDT – The untold story

Every SQL Server database developer is aware of SQL Server Management Studio (SSMS) but there is one more important tool SQL Server Data Tools (SSDT) that can bring a lot of benefits to them. SSDT is based on Visual Studio There are many ancillary jobs that a database developer performs apart from writing T-SQL queries, … Continue reading SSDT – The untold story

Decoupling vs Performance – SQL Server

Did you ever noticed thousands of lines of code in a single Stored Procedure? Did you faced performance issues in such Stored Procedure? Did you faced difficulties in debugging such Stored Procedure? Did you ever noticed the millions and billions of rows in a single Table? Did you faced the difficulties and performance issues in dealing with … Continue reading Decoupling vs Performance – SQL Server

Normalization vs Performance – SQL Server

Are you dealing with high volume online data and having trouble in performing online analytics over it? Normalization could be one possible reason behind poor performance of your queries. Every solution has some trade-off so normalization also has. If your data is extensively normalized then you may be performing a lot of joins in order to … Continue reading Normalization vs Performance – SQL Server

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