How to make Identity Column in Existing Table. in SQL Interview SQL Server on 02:31:00 No Comments 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 in SQL Interview SQL Server on 07:01:00 No Comments 1. Select @@version 2. Run below Query in SSMS Select Case When Convert(Varchar(128), ServerProperty ('ProductVersion'))...
SQL Server 2014 Installation in SQL Interview SQL Server on 05:49:00 No Comments 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 in SQL Interview SQL Server on 07:43:00 No Comments 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 in SQL Interview SQL Server on 05:43:00 No Comments CREATE CLUSTERED INDEX cixEmp on Employee_InfoV2(emp_id) with ( DROP_EXISTING = ON, sort_in_tempdb = ON, ...
JOIN OPTIONS IN SQL SERVER in SQL Interview SQL Server on 05:33:00 No Comments WHEN TO USE WHICH JOIN OPTION FOR FASTER JOIN OPERATIONS? MERGE JOIN: APPLICCABLE FOR LARGER TABLES LOOP JOIN: APPLICABLE...
SQL SERVER ISOLATION LEVELS: in SQL Interview SQL Server on 05:26:00 No Comments 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 in SQL Interview SQL Server on 01:15:00 No Comments 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 in SQL Interview SQL Server on 23:50:00 No Comments we need to create database role in particular database where user wants execute permission. Use DB_NAME GO CREATE ROLE...
Uninstall SQL Server 2012 in SQL Interview SQL Server on 22:20:00 No Comments 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 in SQL Interview SQL Server on 05:09:00 3 Comments We got Setup Account Privileges Rule failed while installing SQL 2012. Reason: The account that is running...
Error While enabling Windows feature: netFx3 in SQL Interview SQL Server on 22:20:00 2 Comments While installing SQL server 2012, we got this error message. This error indicate that .net framework 3.5...