SQL Server Interview Questions
Questions Answers Views Company eMail

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

Infosys,

5 18321

Can we create clustered index on non primary key column

ABC, CTS,

20 41052

What are Sql Reporting Services and analysis services? Can u Explain

1 8372




What r sql reporting services and analysis services? how can we use it.

Microsoft,

2 10098

is there more the two primary key in a single table?

Systematix, Eforce,

26 17337

how to implement locking in sql server

Satyam,

3 5468

What is the difference between a Application Server and a Database

Oracle,

3 10029

What is the difference between 2-Tier architecture and 3-Tier architecture

CTS, Oracle,

15 55795




what is differece between union and union all

6 5935

Is trigger fired implicitely?

2 3443

how do we find every fifth record in a table

Aspire, HCL,

14 10467

What is the appropriate number of test cases that you can write on a database?

Microsoft,

2 4441

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

Microsoft,

2 4387

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 15722

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

TCS, IBM,

2 13715


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

908


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1403


System variable and temporary variables

1031


which backup strategy you are following at ur company

1041


How do use Having,Group by,Group function in SQL?

721






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?

1312


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

964


How retrieve field names from the table in SQL through JAVA code?

754


how to do partition in sqlserver

1355


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

991


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1100


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

206


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.

2731


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

901


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1335