Follow Our FB Page << CircleMedia.in >> 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?

Infogain,

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?

Shriram,

2 7797

What is the use of DBCC commands?

NA,

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.

iSoft,

1615

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

150


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

101


What is ms sql server reporting services?

112


Explain about thread and memory management process of SQL?

155


Is truncate a dml command?

104






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

112


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

152


Are resultset updatable?

99


What is data source in connection string?

94


how can a database be repaired? : Sql server administration

129


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

153


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

125


Can we use pragma autonomous_transaction in trigger?

116


Difference between drill down and drill through report.

140


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

142