Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL Server Interview Questions
Questions Answers Views Company eMail

What is a trigger?

4 4776

What is a view?

6 5842

What is an Index?

Yardi Software,

3 6568

What are the types of indexes available with SQL Server?

Standard Bank,

2 5511

What is the basic difference between clustered and a non-clustered index?


9 32721

What are cursors?

8 6303

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 15533

Which TCP/IP port does SQL Server run on?

2 8127

From where can you change the default port?

3 4913

Can you tell me the difference between DELETE & TRUNCATE commands?

15 17076

Can we use Truncate command on a table which is referenced by FOREIGN KEY?


2 7797

What is the use of DBCC commands?


4 6361

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.



Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 2966

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

World Tech, Yardi Software,

11 22798

Un-Answered Questions { SQL Server }

What is SubQuery in SQL Server 2008


What is the difference between a stored procedure and a user defined function?


What is ms sql server reporting services?


Explain about thread and memory management process of SQL?


Is truncate a dml command?


is there a column to which a default can't be bound? : Sql server database administration


Can group functions be used in the order by clause in ms sql server?


Are resultset updatable?


What is data source in connection string?


how can a database be repaired? : Sql server administration


How many null values we can have in a unique key field in sql server?


Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?


Can we use pragma autonomous_transaction in trigger?


Difference between drill down and drill through report.


How to fetch the next row from a cursor with a "fetch" statement?