November 2015

A Closer Look Over Function & Stored Procedure in SQL Server

Function and Stored Procedure are two very different entities in SQL Server, you may already familiar with these two commonly used terms. T...

SQL Server Suspect Database As we know that the data is a vital entity for everyone. Suppose you are working on your SQL Server database bu...

SQL Server is the most common type of database management system in these days which provides flexibility to the DBA’s to manage their datab...

Stored Procedure in SQL Server A stored procedure is an accumulation of MS SQL arguments such as collection of MS SQL commands and logical...

SQL Server Recovery Models contain the backup and restore operations of the database. The main concept against the designing of recovery mod...

What is Transaction Log in SQL Server? In SQL Server, a transaction log is a type of file. The transaction log file saves all the transacti...

In the previously published blog we have discussed about the Truncate, Delete and Drop Statements in SQL Server now in this blog we will di...