What is stretch database in sql server?



What is stretch database in sql server?..

Answer / Rani Katare

Stretch Database is a feature in SQL Server that allows for storage of large tables with both hot and cold data. Cold data (infrequently accessed) is moved to Azure storage, reducing the size and cost of on-premises storage. Stretch Database improves query performance by automatically moving hot data back to on-premises storage.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the different sql server versions?

1 Answers  


How does index makes search faster?

1 Answers   QuestPond,


How to retrieve error messages using mssql_get_last_message()?

1 Answers  


How to create prepared statements using odbc_prepare()?

1 Answers  


What does it mean to be in union?

1 Answers  


How raid can influence database performance?

0 Answers  


What is a data collection table?

1 Answers  


Difference between Function and Procedure-in general?

6 Answers  


can an order by clause be used in a creation of a view?

1 Answers  


Repair mdf file

2 Answers  


Which index created when Create Index on table(col), Why

2 Answers   CGI,


What is the difference function and stored procedure?

1 Answers  


Categories