ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How do you know which index a table is using?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do you know which index a table is using?
Answer
# 1
sp_helpindex command gives the information of the indexes 
on the table
 
Is This Answer Correct ?    2 Yes 0 No
Chandra Rekha
 
  Re: How do you know which index a table is using?
Answer
# 2
dbcc traceon 302
 
Is This Answer Correct ?    0 Yes 1 No
Vimal
 
 
 
  Re: How do you know which index a table is using?
Answer
# 3
sp_helpindex tabelname
 
Is This Answer Correct ?    2 Yes 0 No
Hari
 
  Re: How do you know which index a table is using?
Answer
# 4
sp_help <tablename>
sp_helpindex <tablename>
 
Is This Answer Correct ?    1 Yes 1 No
Visala
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
from the table display the 2nd highest salary? and also the least 2nd salay?  3
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan? HCL2
what is the purpose of creating view is sql server 2000 Wipro7
What is RAID and what are different types of RAID configurations? Wipro5
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  2
how many type of subquery?  2
What is a join and their types? Challenger-Financial2
what are batch in sql server? Satyam2
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com Symphony21
select empid empname from employee What is the result for the about query?  3
IN Vs OR operator which is best to use sql server.  3
What is the difference between IN and EXISTS operators in SQL Server? Intelligroup3
can we call functions from stored procedure in SQL Server 2005 ? How?  2
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
How do we rollback the table data in SQL Server  3
write query for fourth maximum salary from employee table Mind-Tree5
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...  2
What's the difference between a primary key and a unique key?  4
What are constraints? Explain different types of constraints?  5
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds4
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com