SQL Server Interview Questions
Questions Answers Views Company eMail

What is a trigger?

4 4124

What is a view?

6 5060

What is an Index?

Yardi Software,

3 5746




What are the types of indexes available with SQL Server?

Standard Bank,

2 5065

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

9 31143

What are cursors?

8 5434

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 14328

Which TCP/IP port does SQL Server run on?

2 7652




From where can you change the default port?

3 4413

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

15 15033

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

Shriram,

2 6996

What is the use of DBCC commands?

4 5711

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,

1364

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 2556

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

Yardi Software, World Tech,

11 20844


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

954


Why we need to use secondry database file? though, we can do same work using primary database file also.

4248


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., }

1069


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.

1601


ow to bring suspect mode datbase online from scratch

700






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

687


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

913


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1167


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

963


role of sql sever 2005 in database rather than any other database

893


application server is slow what may be the problem

1095


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

865


What is Lock table in SQL?

283


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.

2694


how can you attach more than 20 ldf files in sql server

846