Loading
Undocumented Physical Row Locator Function in SQL Server 2008
This article describes an undocumented physical row locator function in SQL Server 2008.
Delete Duplicate Data in SQL Server
This article provides five ways to remove duplicate data (rows) from a SQL Server table.
Database Backup in SQL Server
In this article we will see a simple script to backup a database to disk drives.
All About IDENTITY Property in SQL Server
In this article, I want to explain the Identity property in SQL Server.
Need of Nvarchar Over Varchar in SQL Server
Here, I will explain the need for nvarchar over varchar in SQL Server.
Creating and Using SQL Server View
This article explains how to create a view and how to do an update using a view. The later part of the article explains the usage of the check option while creating a view.
Understanding the Memory Consumed By Char, Varchar, Nchar and Nvarchar in SQL Server
This article explains how much memory is consumed in SQL Server.
Count the Number of Tables, Stored Procedures, Triggers, Functions, Views in Your Database
In this article I show how to determine how many types of entities you have in your any database.
DateTime Functions in SQL Server 2012
This article describes all the new DateTime functions introduced in SQL Server 2012 with examples.
Determine Object Dependencies in SQL Server
This article describes some of methods for determining object dependency information.
Implement IDENTITY Column in SQL Server Memory Optimized Table
This article shows how to create an INDENTITY (auto incremented) column with a memory optimized table.
Feature, Function and Keyword Not Supported by Natively Compiled Store Procedure
This article lists the many features, functions and keywords that are not available in a natively compiled Stored Procedure.
Insert Values in Identity Column in SQL Server
Learn how to insert values into an Identity column in SQL Server.
Natively Compiled Stored Procedures in SQL Server 2014
This article describes Natively compiled stored procedures (T-SQL procedures compiled to native code and access memory optimized tables) and their use.
Delayed Transaction Durability in SQL Server 2014 (CTP2)
SQL server 2014 (CTP2) introduced Delayed Durability. It helps reduce the IO contention for writing to the transaction log.
Problems With SQL Views When Updating Records
This article explains problems with SQL Views when updating records.
Insert, Update and Delete in a SQL View
In this article, we will see how to insert, update and delete in a SQL View.
EXECUTE Statement Enhancement WITH RESULT SETS in SQL Server 2012
This article explains the EXECUTE atatement enhancement in SQL Server 2012, WITH RESULT SETS.
IDENTITY Vs SEQUENCE Object in SQL Server
This article describes the differences between an IDENTITY property and SEQUENCE object.
SEQUENCE in SQL Server 2012
This article explains the SEQUENCE value in SQL server 2012.
Delete Duplicate Rows From a Table in SQL Server
In this article you will learn how to delete duplicate rows from a table in SQL Server.
OFFSET and FETCH in SQL Server 2012
SQL Server 2012 has introduced two new keywords for doing pagination of the result sets: OFFSET and FETCH.
Find the 3rd or Nth Highest Salary in a Table Via Co-Related Query
This article describes how to find the 3rd or Nth highest salary in a table via Co-Related Query.
Lead and Lag Function in SQL Server 2012
This article explains the SQL Server 2012 two new analytical functions LEAD and LAG.
SQL Server Installation Restart Required Error
When we install SQL Server then sometimes the error Restart Required occurrs. This article explains how to solve the problem.
Introduction To SQL Server Management Object
SQL Server Management Objects (SMOs) were introduced by Microsoft to manage SQL Server objects in C#. This is the managed code replacement of DMOs.
Query to Find All About Database Schema
In this short tip you will learn how to find information about a database schema in SQL Server.
How to Install SQL Server 2012 on Windows 8.1
This article explains how to easily install SQL Server 2012 in Windows 8.1.
