Do you know what is a trace frag? Where do we use it?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  


Write an sql query for deleting duplicate rows?

0 Answers  


Do you know what is a with(nolock)?

0 Answers  


What is Right Outer Join?

2 Answers  


what is lazy writer?

1 Answers   Wipro,






How do I install only the client tools of sql server 2000?

0 Answers  


Why transaction is important?

0 Answers  


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 Answers   HCL,


What is difference between rollback immediate and with no_wait during alter database?

0 Answers  


How can change procedure in sql server?

0 Answers  


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,


What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,


Categories