SQL Server Interview Questions
Questions Answers Views Company eMail

How get current date in SQL server 2000

Polaris, Cap Gemini,

4 2551

How get current date in SQL server 2000

Cap Gemini,

6 3972

In the primary key have a multiple field or not?

TCS,

8 4466




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 5279

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 ?

863

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

811

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

NIIT,

3 3310

what are the critical issues you have resloved in your company

Wipro,

823




how can you move the master database

IBM,

1 2958

What is RMS migrations?

Satyam,

955

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 5120

What is split brain scenario in DB mirroring?

1 7341

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

1 3121

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 3533

in how many ways we can use count()

2 1226


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1 01 101 01010

743


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

940


what is the sql equivaent of the dataset relation object ?

844


What is the difference between NOROW and LOCKROW?

1293


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

949






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

1334


on line cluster can we make if yes tell me the procedure

837


How we create SQL Server 2005 Reporting Services ? Give me Sample

920


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

2677


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

177


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

362


How to restore performance issues and how to check?

845


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.

665


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

969


sql database suspect We have a sql database that is showing as suspect. How can we recover?

710