Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
3
Newest
 Supporter
Impact
~14k people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Sep
3
comment 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.
Jul
2
comment 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.