SQL Server Interview Questions
Questions Answers Views Company eMail

1 01 101 01010

1574

Find top Nth employee from each department in terms of salary?

RealPage,

13 22042

How to get last system shutdown time in Sql server when restarted system?

1 8231

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

Hewitt,

9 9599

How will you collect the date from current date to last older 6 days date in sql server 2005

4 4977

how we can store the value like that 001,003,023 etc in sql server 2005

7 7411

Selet all the data from table where last name is n of employee

2 4443

How to find the latest updated value in a table without sending any parameters to that query

2 4695

how to improve the speed of SQL database server and how to avoid dead lock?

TCS,

1 5389

What is the disadvantages of index?

TCS,

3 7375

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 3661

select names starts with a,b,c

Scope International,

8 10820

How to convert a table data in XML format in sql server?

2126

how to do partition in sqlserver

TCS,

1978

can any body tell me how to know the password of current user in sql server

Crea, HCL,

1583


Un-Answered Questions { SQL Server }

How to define and use table alias names in ms sql server?

567


What is raid? : SQL Server Architecture

600


What are number line correlation administrators will use while working with a subquery?

631


what is the Ticketing tool used in Wipro technologies at Bangalore...???

7484


What is a document index?

593






How do you rebuild an identity column?

557


What protocol does sql server use?

521


What is the function of inner join?

564


How check triggers in sql server?

526


Where do you find the default Index fill factor and how to change it?

609


What are the types of normalization?

558


what are the three command line utilities and what are their primary functions?

102


What are statistics?

575


Define master database?

587


What are the transaction properties?

564