Answer Posted / 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 View All Answers
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is acid mean in sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
List the ways in which dynamic sql can be executed?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is sql or structured query language?
How to convert numeric expression data types using the cast() function?
What is a coalesce function?
What are the different SQL Server Versions you have worked on?
What is the primary use of the model database?
What are the different types of subquery?
How to provide default values to function parameters?
What are the source of constraints?
Where can you add custom error messages to sql server?
