SQL Server Interview Questions
Questions Answers Views Company eMail

CREATE a table from another table

2 2698

Get Current System Date Time

2 2513

What is a SQL Server Temporary Table?

Wipro,

1 4247




what is the difference between delete,drop and truncate

2 3174

ehat is the default port no of sql 2000?

IBM,

2 2828

what is Full Text Search ?

TCS,

1 3589

New concepts of sql server 2005 use in your project.

TCS,

1290

default databases available in sql server and there uses ?

TCS,

4 3954




what is statistics

1 2072

query processing

1064

sql server architecture ?

1265

explain query execution plan

1 2958

how can ur insert the emp table

Wipro,

3 3914

SQL Server Architecture ?

IBM, Sapient,

1191

Diffrence between DTS vs SSIS

IBM, Infosys,

2 5048


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How you trouble shoot when any job fails

754


what is the sql equivaent of the dataset relation object ?

892


If we delete pack Spec what will be the status of pack Body ?

234


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1100


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?

933






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

3598


Does any body please help me what question's have asked for SSRS in the interview?

960


How to trouble shoot if unable to connect SQL Server

833


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.

1406


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

898


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

970


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?

1002


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

676


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

732


How retrieve field names from the table in SQL through JAVA code?

760