Category: SQL Server Articles

Filtered Index An optimized nonclustered index, especially suited to cover queries that select from a well-defined subset of data. It uses a filter predicate to […]

Calculated or computed column in SQL Calculated or Computed column in table uses expression which uses constant and other columns in table. This column is […]

User Defined Functions in SQL User Defined Functions are routines which performs calculation or operation to return a value or result set. It can accept […]

IDENTITY vs UNIQUEIDENTIFIER COLUMN IDENTITY Sl No Advantage Disadvantage 1 Identity column stores numeric values. Numeric value column have better performance in joins, indexes and […]

IDENTITY  property Identified column can be implemented using IDENTITY property. While specifying IDENTITY column, you specify SEED and ARGUMENT. SYNTAX : IDENTITY [ (seed , increment) […]

Create linked server : sp_addlinkedserver sp_addlinkedserver ( Stored Procedure ) is used to created linked servers in SQL server Syntax : sp_addlinkedserver [ @server= ] […]

Retrieve information from SQL table in Linked SQL Server SELECT FROM Sql Statement can be used to retrieve information from SQL table in Linked SQL […]

FOR XML Clause – SQL SELECT statement SQL SELECT query fetches results as a rowset.  By specifying FOR XML clause in SQL Select query , […]

SQL SERVER – Get Current TimeZone Name in SQL Server Use below sql script to get timezone of sql server : DECLARE @TimeZone VARCHAR(50) EXEC […]

Escape Single Quotes in SQL Single Quotes in Select , Insert and Update SQL statement can be escaped by adding another single quote in front. […]