SQL Server Interview Questions
Questions Answers Views Company eMail

How get current date in SQL server 2000

Polaris, Cap Gemini,

4 2362

How get current date in SQL server 2000

Cap Gemini,

6 3784

In the primary key have a multiple field or not?


8 4243

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

TCS, PMAM IT Services,

7 5092

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 ?


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram


i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee


3 3174

what are the critical issues you have resloved in your company



how can you move the master database


1 2824

What is RMS migrations?



I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

Brigade, Wipro,

9 4846

What is split brain scenario in DB mirroring?

1 6744

how do we insert 100 records at a time in a table without using for loop in database

1 2995

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 3360

in how many ways we can use count()

2 1047

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How to restore performance issues and how to check?


how can u get last observation in an unknown dataset ?


Why we need to use secondry database file? though, we can do same work using primary database file also.


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


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?


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


what are the Prerequisites for Replication?


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }


tell me the disaster recovery plan


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?


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. 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 is checksum in sql server.........???