SQL Server Interview Questions
Questions Answers Views Company eMail

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 4206

what is the main difference between after trigger and instead trigger.

2 18825

I have to display ten columns values from diffrent ten tables. how many joins are require?

CarrizalSoft Technologies, HCL,

10 11874

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 18980

What is Peer to peer Replication?

CarrizalSoft Technologies, HCL,

1 5172

what is a cursor and what is its use?

L&T,

2 7377

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 7671

what is trigger

CarrizalSoft Technologies, NIIT,

1 4054

what is difference between nchar and char in Sql server ?

3 6776

How can we write or define DDL statements in Sql server and DML statements?

3 5271

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 5892

write down the code for "how we delete a table without using of Drop command " ?

CarrizalSoft Technologies, Sonata,

7 8735

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 3535

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 3264

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 10801


Un-Answered Questions { SQL Server }

Where the sql logs gets stored? : sql server database administration

510


How to invoke a trigger on demand?

522


What are the different types of collation sensitivity?

534


Is the log file is a part of file group?

533


What are the steps you can take to avoid “deadlocks”?

502






SQL Server Architecture ?

1903


How to install sql server 2005 express edition?

572


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

686


Write a code to select distinct records without using the DISTINCT keyword.

624


What is the significance of master, tempdb and model databases?

507


What is sharding?

88


How to name query output columns in ms sql server?

523


Explain the Ways to improve the performance of a sql azure database?

60


Do you know what is difference between index seek vs. Index scan?

498


How to verify a login name with sqlcmd tool?

570