1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How can you set the threshold at which sql server will generate keysets asynchronously?

Question Posted / rajani sachan


How can you set the threshold at which sql server will generate keysets asynchronously?..

Answer / Rajeev Yadav

You can set the threshold for asynchronous key generation in SQL Server by using the OPTIMIZE FOR UNKNOWN option when creating a clustered columnstore index. The default threshold is 200,000 rows.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1 Answers  

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

Explain what are magic tables in sql server?

1 Answers  

What is scheduled job and how to create it?

1 Answers  

Is it safe to delete log files?

1 Answers  

How to create a user name in a database?

1 Answers  

What are the purpose of Normalisation?

1 Answers   HCL,

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

1 Answers  

difference between sql server2000 and sql server2005

1 Answers   KPMG,

Define left outer join in sql server joins?

1 Answers  

What is the difference between SQL notification and SQL invalidation?

1 Answers   MindCracker,

What is clustered index

0 Answers  

For more SQL Server Interview Questions Click Here
Categories