How to make Identity Column in Existing Table.

We got a request to make column IDENTITY column in the existing table. This is the process we followed. 1. Script-out...

How to Find SQL Server Version,Edition,Product Level

1. Select @@version 2. Run below Query in SSMS Select Case When Convert(Varchar(128), ServerProperty ('ProductVersion'))...

SQL Server 2014 Installation

SQL 2014 software downloaded from Microsoft site and now we will learn the installation. I downloaded the ISO file,So...

SQL Server Reporting issue -- What to look at first glance

We had a issue with our reports since  users were not able to access the reports. We checked the reporting log files...

Cluster Index with Drop Existing

CREATE CLUSTERED INDEX cixEmp on Employee_InfoV2(emp_id) with ( DROP_EXISTING = ON, sort_in_tempdb = ON,   ...

JOIN OPTIONS IN SQL SERVER

WHEN TO USE WHICH JOIN OPTION FOR FASTER JOIN OPERATIONS? MERGE JOIN: APPLICCABLE FOR LARGER TABLES LOOP JOIN: APPLICABLE...

SQL SERVER ISOLATION LEVELS:

A MECHANISM TO CONTROL THE DEGREE OF DEPENDANCY BETWEEN TRANSACTIONS. EVERY TRANSACTION HAS A UNIQUE AUTO ASSIGNED LSN:...

SSAS tabular model process using XMLA code

We will create the SQL agent job for processing the SSAS tabular model. Below are the steps: 1. Connect to SSAS instance...

Grant Execute permission to user in SQL Server

we need to create database role in particular database where user wants execute permission. Use DB_NAME GO CREATE ROLE...

Uninstall SQL Server 2012

we have to open control panel -->Programs. We will land to new window. Now we need to look for "Microsoft SQL...

Setup Account Privileges Rule failed while installing SQL server

We got Setup Account Privileges Rule failed while installing SQL 2012. Reason:  The account that is running...

Error While enabling Windows feature: netFx3

While installing SQL server 2012, we got this error message. This error indicate that .net framework 3.5...