Next badge 0/1
~13k people reached
- 0 posts edited
- 0 helpful flags
- 7 votes cast
Database starts always in recovery mode
How frequently do you re start? How frequently do you backup the database? I am wondering why you are re starting the server on a regular basis? To be complete, you can manually checkpoint a database (which clears the log) if need be.
Few Questions about SSAS Cubes
You don't say whether you have looked at both possibilities in SQL Server SSAS 2012 - those being either the UDM (OLAP cube) or the BISM (Tabular Model). To get a quick, high-level overview of the differences between the two - read this. After you have decided on one model over another, then you may want to revise your question a bit.