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

TCS,

2 3886

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 10370




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

CTS, TCS,

4 9662

What is the difference between login and a user?

CTS, TCS,

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

CSC,

2 9176

What is the default value of CHAR type?

Bosch,

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.

IGT,

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

783


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

832


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

834


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

892


query processing

1016






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

328


how to overcome kernel isssues

479


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?

795


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

980


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.

678


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.

1641


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 ?

875


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?

1062


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

954


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

846