What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
1043What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
1258After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
952
Why truncate is ddl?
How to transfer data from a cursor to variables with a "fetch" statement?
What is thr feature of change data capture?
Why we should not use triggers?
What is the default value of an integer data type in sql server 2005?
Explain about analysis services?
what is the main function of a query parameter?
What is the cartesian product of the table?
What are difference between Cluster index and Non-Cluster index?
Write SQL queries on Self Join and Inner Join.
in the physical file layout, where should the transaction log be stored in relation to the data file?
Are semicolons required at the end of sql statements in sql server 2005?
What does dml stand for?
Can select statements be used on views in ms sql server?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?