SQL Server Interview Questions
Questions Answers Views Company eMail

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 8016

What is difference between restoration and recovery in SQLServer?

Microsoft,

3 7963

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

Microsoft,

2 4137




What is difference between process and thread? Explain lazy writer funcationality.

Microsoft,

2 5295

What is live lock and deadlock? what is Lock escalation?

Microsoft,

2 5636

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

RBS,

1 2555

What is Primary key and foreign key? Give an example

TCS,

4 5999

How to connect PK and FK?

2 3569




What is the SQL?????????????????????????????

CMS,

5 3796

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

HP,

752

what is an sql server?

1 2255

find 2nd highest salary of person using cursor concept?

HCL,

6 5587

how to find the second salary?

HCL, Prithvi,

10 6230

How to swap the data of two columns in a table. both the columns containing varchar values.

9 10831

What are the steps need to be take improve the speed of a SQLDATA Server?

IBM,

2 2815


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Issues related in upgrading SQL Server 2000 to 2005 / 2008

720


This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

1185


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.

1526


SQL Server Architecture ?

1080


your distribution database is full what will u do

907






What is RMS migrations?

902


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

616


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?

817


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1195


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

611


Comment,Datatypes are unlimited

871


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.

1305


Why do you want to join software field as you have done your BE in Electronics?

972


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

781


What is Lock table in SQL?

199