How to find a column is updated.

In application development, there are situations where an action is driven based on a change in data. A trigger can be used to perform an action based on the data…

Read more »

Grant permission to Integration Service Catalog folder

People often confused that having access to SSISDB will also provide access to the Integration Service Catalog folders but permission for the folder is handled separately. The following code can…

Read more »

Add a NOT NULL column to an existing table – Performance improvement SQL Server 2012

Why alter table add NOT NULL column takes long time? Adding a NOT NULL column to the existing table will run for longer time for high volume tables. Because SQL…

Read more »

CHECKPOINT in SQL Server

CHECKPOINT is an internal SQL Server process that runs periodically to write dirty pages (changed pages) and transaction log records from memory to disk. It then marks a point in…

Read more »

Identifying cached tables in SQL Server buffer

When a query is submitted it goes through a sequence of phases in SQL Server. Starting from parse, optimization, plan preparation until the execution of the plan. During the execution…

Read more »

When did the last statistics update occur?

Statistics are the critical piece of information that SQL Server maintains for a table or index. The query optimization process depends on the statistics information to prepare an execution plan…

Read more »

DBCC HELP!!

SQL Server has many DBCC commands, administrators use them for maintenance, validation and to collect information about the database, for example, DBCC SHOW_STATISTICS displays statistics for a table. But there…

Read more »

Benefits of including a non-key column in a non-clustered index

SQL Server supports to include non-key column as part of the non-clustered index. Having an index with the included column improves the query performance in several scenarios. This blog covers…

Read more »

What does CHECK OPTION do in a View

When CHECK OPTION specified in a view definition, all the data modification and insertion through the view will be forced to qualify the view’s filter criteria. I will use the…

Read more »

Execute SSIS Package Using T SQL

SQL Server provides several tools to execute the SSIS package. A package can be executed using dtexec command prompt utility, SQL Agent and Transact SQL. This article provides information and…

Read more »