SQL Server Interview Questions
Questions Answers Views Company eMail

what is the main difference between constraints(like primary key etc..)& joins?

2 3872

What are the types of model in sql server and explain


2 3886

Wht is the difference between stored procedure and trigger


6 10370

What are the types of backup and tell me the difference between full and differential backup?


4 9662

What is the difference between login and a user?


13 21174

What is the use of placing primary key and foreign key constrains on columns.

Value Labs,

4 4597

what is IDE,DMV in sql server?

Value Labs,

1 6282

Wht is Stuff in sql ser

2 2706

how to get 25th row in any table in sqlserver can u tell me syntax

8 7032

what is the diffrence between Snap Shot and Transaction Replication


2 9176

What is the default value of CHAR type?


10 14418

How to find the last update record in SQL Server?

4 13405

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

Value Labs,

7 6099

Can we create a clustered index on composite primary key.


3 14021

what is hash table

Teledata, ILFS,

3 17043

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How to trouble shoot if unable to connect SQL Server


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?


You are doing log shipping due to some reasons it is failing. How you will proceed from there


Which is the best place or learning center for MS SQL?????In Bangladesh?????


query processing


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it


how to overcome kernel isssues


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?


What is best institute to Learn DotNET And SQL in chennai?


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?


wat wil hapn if we give the both read and deny read permission to user?


how can you attach more than 20 ldf files in sql server