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 |
What are the different sql server versions?
How does index makes search faster?
How to retrieve error messages using mssql_get_last_message()?
How to create prepared statements using odbc_prepare()?
What does it mean to be in union?
How raid can influence database performance?
What is a data collection table?
Difference between Function and Procedure-in general?
can an order by clause be used in a creation of a view?
Repair mdf file
Which index created when Create Index on table(col), Why
What is the difference function and stored procedure?
Oracle (3253)
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)