SQL Server Interview Questions
Questions Answers Views Company eMail

1 01 101 01010

711

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

RealPage,

13 15652

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

1 6317




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

Hewitt,

9 6034

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

4 2891

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

7 4545

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

2 2857

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

2 3156




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

TCS,

1 4221

What is the disadvantages of index?

TCS,

3 5218

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 2349

select names starts with a,b,c

Scope International,

8 7348

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

1369

how to do partition in sqlserver

TCS,

1279

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

Crea, HCL,

894


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

If a stored procedure is taking a table data type, how it looks?

4587


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

4886


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

854


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

589


How to trouble shoot if unable to connect SQL Server

743






tell me the disaster recovery plan

1260


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1271


last function used in MS Access to convert sql what function will use in sql

825


If user is owning any SQL Objects, can we drop that user

828


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

755


Call by value and call by reference in procedure and function, with NOCOPY.

122


optimization techinques

1276


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2649


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.

337


what is difference between view and Dip.

1165