Mention a few common trace flags used with sql server?
- 1 Answers
- 1010 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rohit Kumar Kushwaha
1. Trace Flag 3604: This trace flag improves the performance of sort operations.
2. Trace Flag 8608: This trace flag provides memory-granular dump files for troubleshooting memory leaks.
3. Trace Flag 1204: This trace flag increases the size of the plan cache to improve query performance.
4. Trace Flag 908: This trace flag improves the performance of queries with temporary tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert numeric expression data types using the cast() function?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How efficient you are in oracle and SQL server?
Can we do dml on views?
What kind of problems occurs if we do not implement proper locking strategy?
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
Where can you add custom error messages to sql server?
How can we solve concurrency problems?
When should you use an instead of trigger?
do you know how to configure db2 side of the application? : Sql server database administration
List out the different types of locks available in sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is sql server query analyzer?
How to connect php with different port numbers?
What are the kinds of subquery?
