SQL Server Interview Questions
Questions Answers Views Company eMail

What is a trigger?

4 3919

What is a view?

6 4809

What is an Index?

Yardi Software,

3 5424

What are the types of indexes available with SQL Server?

Standard Bank,

2 4882

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

9 30559

What are cursors?

8 5197

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 13921

Which TCP/IP port does SQL Server run on?

2 7482

From where can you change the default port?

3 4254

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

15 14508

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


2 6580

What is the use of DBCC commands?

4 5511

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 2391

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

Yardi Software, World Tech,

11 20288

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it


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.


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?


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


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions


Which is the best place or learning center for MS SQL?????In Bangladesh?????


wat wil hapn if we give the both read and deny read permission to user?


SQL Server Architecture ?


How to restore performance issues and how to check?


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that


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.


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


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?