MSSQL Server 2000/2005/2008-Interview Question

Interview

VB.Net

VC++

ASP.Net

ADO.Net

.Net Framework

Silverlight

WPF(Windows Presentation Foundation)/XAML

WCF(Windows Communication Foundation)

Java

PHP

AJAX

Assembly

XML

Wireless/Mobile Development

Cold Fusion

MSSQL Server 2000/2005/2008/2012

MYSQL

DB2

MS Access

Java Script

VB Script

JQuery

Testing

BlackBox Testing

WhiteBox Testing

OOPS

SharePoint

ASP.NET MVC

HTML5

CSS/CSS3

IIS 7

Windows 8

Google API

Facebook API

Twitter API

Android Programming

iPhone/iPad Programming

Windows Phone Programming

Json

Sencha-Touch

Follow Us

Advertise with Us

Article

Forum

Blog

Quiz

Beginner

Careers

Contact

Home

Product

Services

About Us

Interview

DeveloperSection

Submit Question

Interview

Home >> MSSQL Server 2000/2005/2008

Interview Question	Answer	Posted On
What is Non Clustered Index?	1	2013/06/15
What is Clustered Index?	1	2013/06/15
What are the different modes of firing triggers?	1	2013/06/15
What are the steps to partition a non partitioned or existing table?	1	2013/06/15
What is the syntax to create partition function?	1	2013/06/15
What is partitioning in SQL Server?	1	2013/06/15
What are the different types of Sub-Queries?	1	2013/01/21
What is Normalisation?	1	2013/01/21
Difference between TRUNCATE and DELETE commands?	2	2013/01/21
Can you explain architecture of SSIS (SQL Server integration services)?	1	2012/12/15
Which system table contains information on constraints on all the tables created?	2	2012/03/24
What the difference between UNION and UNIONALL?	2	2012/03/24
How to use while loop in sql server?	1	2012/01/19
What are different types of Collation Sensitivity?	1	2011/11/04
Which TCP/IP port does SQL Server run on? How can it be changed?	1	2011/11/04
How will you copy the structure of a table without copying the data?	1	2011/09/17
Difference between a "where" clause and a "having" clause.	1	2011/09/13
What are the different types of Indexes available in SQL Server?	1	2011/08/12
What is the default Port No on which SQL Server listens?	1	2011/08/12
What is Identity?	2	2011/08/12
How to read excel data directly into SQL server 2005?	1	2011/08/12
How to create sequence in oracle?	1	2011/08/12
What is denormalization and when would you go for it?	1	2011/05/20
What is PIVOT and UNPIVOT?	1	2011/05/11
What is CTE?	1	2011/05/11
What is Service Broker?	1	2011/05/11
What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?	1	2011/05/11
What is SQL Server Agent?	1	2011/05/11
Which TCP/IP port does SQL Server run on? How can it be changed?	1	2011/05/11
What is a Linked Server?	1	2011/05/11
Which virtual table does a trigger use?	1	2011/05/11
How to get list of all objects in database.	1	2011/05/11
What is a Scheduled Jobs or What is a Scheduled Tasks?	1	2011/05/11
How to get @@error and @@rowcount at the same time?	1	2011/05/11
How do you load large data to the SqlServer database?	1	2011/05/11
What are Checkpoints in SqlServer?	1	2011/05/11
Write some disadvantage of Cursor?	1	2011/05/11
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?	1	2011/05/03
What is the purpose of using COLLATE in a query?	3	2011/05/03
What command do we use to rename a db?	1	2011/05/03
What is the use of DBCC commands?	1	2011/05/03
What are the types of indexes available with SQL Server?	1	2011/05/03
What is cursors?	1	2011/05/03
What is Row_Number()?	1	2011/04/28
What is Catalog Views?	1	2011/04/28
What is Data Compression?	1	2011/04/28
what is union in sql server?	1	2011/04/28
What are instances ? Explain each one of them ?	1	2011/03/28
What do “jobs” and “alerts” mean in SQL Server ?	1	2011/03/28
Which are the different services in SQL Server ? How do you manage them ?	1	2011/03/28
First 1 2 Last

Report Abuse Form
Reason:

Total Online Users: 2695

Advertise with Us