in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SSAS » Locking (RSS)

Browse by Tags

  • SQL Agent and SSAS Commands

    SQL Agent can be used to execute SSAS commands such as processing of a dimension and i can see that it is useful when you want to quickly schedule an adhoc processing task but there is a major drawback you need to be aware of. You are not able to specify the database to connect to and whilst you may...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Mon, May 30 2011
  • Enter the SSAS server level lock......

    Ok, so your reaction to the title is probably the same as mine when i found out about SSAS server level locks! So, i will give you the scripts to reproduce the server level lock but first lets get down to business…. :) Server locks were introduced in one of the SP2 cumulative updates. At the moment i...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Mon, Nov 23 2009
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems