SQL Server Interview Questions
Questions Answers Views Company eMail

What is a trigger?

4 4012

What is a view?

6 4943

What is an Index?

Yardi Software,

3 5620




What are the types of indexes available with SQL Server?

Standard Bank,

2 4981

What is the basic difference between clustered and a non-clustered index?

9 30891

What are cursors?

8 5322

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 14155

Which TCP/IP port does SQL Server run on?

2 7577




From where can you change the default port?

3 4338

Can you tell me the difference between DELETE & TRUNCATE commands?

15 14775

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

Shriram,

2 6835

What is the use of DBCC commands?

4 5601

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.

iSoft,

1321

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 2468

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

Yardi Software, World Tech,

11 20613


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

4627


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

914


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

641


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?

1213


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

790






sql database suspect We have a sql database that is showing as suspect. How can we recover?

687


How to restore performance issues and how to check?

813


How much memory that we are using in Logshipping Concept?

674


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

122


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

848


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

911


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

4174


application server is slow what may be the problem

1065


ow to bring suspect mode datbase online from scratch

662


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

899