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

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

What are the restraints imposed on the table design by a merge replication?

1 Answers  

What are the purpose of Normalisation?

1 Answers   HCL,

How to define output parameters in stored procedures?

1 Answers  

Determine when an index is appropriate?

1 Answers  

Explain what is dbcc?

1 Answers  

What is isolation levels?

1 Answers  

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

What is row by row processing ?

2 Answers  

What is the parse query button used for?

1 Answers  

Explain the first normal form(1nf)?

1 Answers  

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1 Answers  

For more SQL Server Interview Questions Click Here
Categories