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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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 
What is a Trace frag?Where can we use this?
 Question Submitted By :: Vamsimadineni
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is a Trace frag?Where can we use this?
Answer
# 1		 
A Trace Flag (not Trace Frag) is used inorder to 
activate/suppress a certain behaviour of the SQL Server.

You need to restart the SQL Server after adding the Trace 
Flag.

Thanks,
Bru Medishetty
www.LearnSQLWithBru.com
 
Is This Answer Correct ?    1 Yes 0 No
Bru Medishetty
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
how can i store resumes in database? HCL2
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz... Value-Labs5
wht's the differece between sqlserver05 and sqlserver2000  3
Difference between Function and Procedure-in general?  3
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)  1
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
what is physical sort data and logical sort data in index?  2
What is a table called, if it does not have neither Cluster nor Non-cluster Index?  1
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  3
What is Peer to peer Replication? HCL1
what is normalization? what is denormalization? Satyam5
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?  2
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju  3
Explain fundamentals of Data ware housing & OLAP?  1
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000  11
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj IBM7
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha  4
What are the different types of backup avaible in SQL SErver Emphasis5
The Difference between 'Count' and 'Count(*)'  12
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)? Marlabs8
 
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