SQL Server Interview Questions
Questions Answers Views Company eMail

What is a trigger?

4 3972

What is a view?

6 4890

What is an Index?

Yardi Software,

3 5549

What are the types of indexes available with SQL Server?

Standard Bank,

2 4948

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

9 30732

What are cursors?

8 5274

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 14058

Which TCP/IP port does SQL Server run on?

2 7527

From where can you change the default port?

3 4298

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

15 14649

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


2 6709

What is the use of DBCC commands?

4 5562

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 2435

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

Yardi Software, World Tech,

11 20460

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)


How you trouble shoot when any job fails


If the job running very slow what is the action you do


what exactly sql injuction.how to overcome.....


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail


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.


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A


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


your distribution database is full what will u do


Working with TLogs


how many no of arguments can be passed in procedures and functions


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


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.


What are the dis_advantages of stored procedures, triggers, indexes?