SQL Server Interview Questions
Questions Answers Views Company eMail

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 8541

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 2815

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 3699




There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 2532

What is the system function to get the current user's user id?

TCS,

3 6337

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 2806

What's the difference between a primary key and a unique key?

Wipro,

10 11208

What are the steps you will take to improve performance of a poor performing query?

HCL,

1 8072




What are the steps you will take, if you are tasked with securing an SQL Server?

HCL,

1 5545

What is blocking and how would you troubleshoot it?

HCL,

3 4591

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

HCL,

3 7653

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

HCL,

1 6038

What are statistics, under what circumstances they go out of date, how do you update them?

HCL,

2 6096

What are the different ways of moving data/databases between servers and databases in SQL Server?

HCL,

3 11389

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

HCL,

2 7382


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Call by value and call by reference in procedure and function, with NOCOPY.

184


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

892


If a stored procedure is taking a table data type, how it looks?

4724


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.

1620


How do use Having,Group by,Group function in SQL?

705






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?

1294


role of sql sever 2005 in database rather than any other database

907


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?

1279


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

884


What is best institute to Learn DotNET And SQL in chennai?

1004


How can we call UDF(User Define Function) using C# code in ASP.net ?

4758


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

1053


what is the sql equivaent of the dataset relation object ?

875


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1527


How to restore performance issues and how to check?

883