SQL Server Interview Questions
Questions Answers Views Company eMail

1 01 101 01010

743

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

RealPage,

13 15830

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

1 6410




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

Hewitt,

9 6088

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

4 2958

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

7 4593

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

2 2913

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

2 3210




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

TCS,

1 4271

What is the disadvantages of index?

TCS,

3 5280

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 2403

select names starts with a,b,c

Scope International,

8 7426

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

1399

how to do partition in sqlserver

TCS,

1304

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

Crea, HCL,

919


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

You are doing log shipping due to some reasons it is failing. How you will proceed from there

818


which backup strategy you are following at ur company

993


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

920


SQL Server Architecture ?

1133


Comment,Datatypes are unlimited

918






i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

705


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

858


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

810


application server is slow what may be the problem

1084


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1256


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


what are the Prerequisites for Replication?

8457


How much memory that we are using in Logshipping Concept?

705


What is Lock table in SQL?

267


Scalability, Availability, Integration with internet, etc.)?

1648