-
In one of my previous post I tried to share my experience on SQL trigger. Here I am adding some additional points that may help us in writing better sql in our projects. Analyzing SQL: Analyzing the performance of your SQL at best you can in parallel to the development is very important. If you perform...
-
Writing Trigger: In many scenarios we write triggers on database tables. In one of my optimization task I found few triggers extremely slow in performance due to some conceptual lacking of the developer. So here I want to share my experience about those triggers. Before writing a trigger we need to understand...
-
Temporary Tables : Temporary tables are created in tempdb. The name "temporary" is slightly misleading, for even though the tables are instantiated in tempdb, they are backed by physical disk and are even logged into the transaction log. They act like regular tables in that you can query their...
