SQL Server Interview Questions
Questions Answers Views Company eMail

CREATE a table from another table

2 2594

Get Current System Date Time

2 2414

What is a SQL Server Temporary Table?

Wipro,

1 4136




what is the difference between delete,drop and truncate

2 3038

ehat is the default port no of sql 2000?

IBM,

2 2726

what is Full Text Search ?

TCS,

1 3511

New concepts of sql server 2005 use in your project.

TCS,

1235

default databases available in sql server and there uses ?

TCS,

4 3845




what is statistics

1 2002

query processing

1000

sql server architecture ?

1214

explain query execution plan

1 2850

how can ur insert the emp table

Wipro,

3 3764

SQL Server Architecture ?

IBM, Sapient,

1133

Diffrence between DTS vs SSIS

Infosys, IBM,

2 4929


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How much memory that we are using in Logshipping Concept?

704


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

595


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

847


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

881


What is Lock table in SQL?

265






whats new about truncate in sql server 2008?

1310


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

852


What is the difference between online clustering and Offline clustering?

1227


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?

947


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1040


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

1399


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.

1263


How we create SQL Server 2005 Reporting Services ? Give me Sample

920


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

940


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?

781