What is a Trace frag?Where can we use this?
Answer / bru medishetty
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 ? | 3 Yes | 0 No |
What are the common performance issues in sql server?
hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq
How can you list all the columns in a database?
What do you understand by physical_only option in dbcc checkdb?
What is difference between count (*) and count 1?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
sql server architecture ?
What is DAC? what is the use of it?
Explain about protocol layer present in SQL server?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What is a not null constraint?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)