SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 3715

What are the types of model in sql server and explain


2 3724

Wht is the difference between stored procedure and trigger


6 10153

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


4 9316

What is the difference between login and a user?


13 20394

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

Value Labs,

4 4374

what is IDE,DMV in sql server?

Value Labs,

1 6054

Wht is Stuff in sql ser

2 2550

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

8 6760

what is the diffrence between Snap Shot and Transaction Replication


2 8878

What is the default value of CHAR type?


10 14036

How to find the last update record in SQL Server?

4 13038

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 5841

Can we create a clustered index on composite primary key.


3 13189

what is hash table

Teledata, ILFS,

3 16342

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

how many no of arguments can be passed in procedures and functions


your distribution database is full what will u do


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?


how to take backup bcp out for a column in table in sql server?


How do use Having,Group by,Group function in SQL?


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?


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


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do


What are the dis_advantages of stored procedures, triggers, indexes?


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...


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 ?


Tell about MOM Tool(Microsoft Operator Manager)?


If we delete pack Spec what will be the status of pack Body ?


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?