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?


1 4247

what is the difference between delete,drop and truncate

2 3174

ehat is the default port no of sql 2000?


2 2828

what is Full Text Search ?


1 3589

New concepts of sql server 2005 use in your project.



default databases available in sql server and there uses ?


4 3954

what is statistics

1 2072

query processing


sql server architecture ?


explain query execution plan

1 2958

how can ur insert the emp table


3 3914

SQL Server Architecture ?

IBM, Sapient,


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


what is the sql equivaent of the dataset relation object ?


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


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?


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 many no of arguments can be passed in procedures and functions


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


How to trouble shoot if unable to connect SQL Server


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.


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


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


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?


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?


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


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