Answer – Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)
Question :- How many non clustered indexes are possible in a table in SQL Server 2008R2 1) 1 2) 249 […]
Interview Questions
Interview Questions
Answer – Question of the Week – 28/12/2013 – Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5 rows
Answer – Question of the Week – 28/12/2013 – Question 2 Read Post »
Deleting Duplicate rows using CTE
Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is
Answer -Question of the Week – 25/12/2013- Question 1
Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname
Answer -Question of the Week – 25/12/2013- Question 1 Read Post »
Interview Questions
Question of the Week – 28/12/2013 – Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5
Question of the Week -25/12/2013- Question1
Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Interview Questions
Interview Questions on Sql Server -Part 3
1. What are the Sql Joins? Sql Joins are the way to get data from many tables based on some
Interview Questions
Interview Questions On Sql Server -Part 2
1. What is the difference between the Union and Union All? 1) Union is used to select distinct data
Interview Questions
Interview Questions on SQL Server -Part-1
1. What is the Normalization? Normalization:-Normalization can be defined as the process of organization the data to reduce the redundant
Difference Between Having and Where Clause in Sql Server
Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there
Difference Between Having and Where Clause in Sql Server Read Post »
Interview Questions, SQL Basic Concepts, SQL Server
How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a
Difference between Clustered Index and Non clustered Index
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval
Difference between Clustered Index and Non clustered Index Read Post »
Sql Server- Difference between Stored Procedure and Function
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to
Sql Server- Difference between Stored Procedure and Function Read Post »
Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still
Difference between Primary key and Unique key
var gaJsHost = ((“https:” == document.location.protocol) ? “https://ssl.” : “http://www.”); document.write(unescape(“%3Cscript src=’” + gaJsHost + “google-analytics.com/ga.js’ type=’text/javascript’%3E%3C/script%3E”)); try { var