Blog

Use triggers in MS SQL to determine your clients’ transaction interval

Use triggers in MS SQL to determine your clients’ transaction interval for any Delete, Update or Insert. We needed to create SQL Jobs to insert data from multiple tables into a single table from 2 different databases from 2 different locations.

The Importance Of Clustered Index To Improve Database Performance In SQL

Clustered Index In Each Table Will Improve Your Database Performance In SQL When working with MS SQL every table should have a clustered index, preferably on the primary key field. The clustered index definition in SQL Server logically sorts the data adjacent to each other in that index key.

Reverse Database Engineering and Database Design

In many cases, we have an existing database but don’t have the original E-R diagram or physical model. Reverse Database Engineering allows us to reconstruct a physical and/or ER model from an existing schema.

SQL Consulting

We are experts at SQL Server database administration, performance tuning and database optimization to maximize your company's productivity. In our team we have MS SQL MVP consultant and our highest experience person has 26 years of database solutions. We are located in central NJ and provide MS SQL consulting solutions all over the USA.

Optimize your sql query for best search result

When developing solutions that require querying large amount of data, you may want to consider user Stored Procedures. When accessing multiple "query patterns", you want to program your system to use the most efficient algorithm to return your data to the user. While using dynamic SQL may work for small databases, a preferred method would be to use a Stored Procedure to optimize performance.