Answer Posted / Pramod Kumar Jaiswal
Analysis Services Repository (ASR) in SQL Server is an XML-based internal metadata storage for Analysis Services objects, such as cubes, dimensions, and measures. The ASR stores all the relationships between these objects and can be used to design, build, and maintain complex data models.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does view occupy space?
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?
How efficient you are in oracle and SQL server?
Why and when do stored procedure recompile?
What is acid mean in sql server?
What is sql server query analyzer?
What is a scheduled job or what is a scheduled task?
How can we solve concurrency problems?
What is self contained sub query?
What are different types of constraints?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How do I create a trace in sql server?
How to connect php with different port numbers?
Can sql servers link to other servers like oracle?
List out the different types of locks available in sql server?