The year 2014 was amazing and I had a great time learning and sharing knowledge. I must thank you my dear readers for your constant support and motivation. I have been blogging every single day for over 8 years and this is only possible because of your help. Today is the last day of the year and from tomorrow we will start strong and will have a new year. Many will make resolutions and many resolutions will break. Here is what I have learned about resolutions – it is hard to keep them up most of the time. Anyway, I just wanted to thank you for amazing Year 2014.
Here are a five videos from my SQL in Sixty Seconds Series. Let me know which one is your favorite.
We will continue our journey in blogging in the year 2015.
Reference: Pinal Dave (https://blog.sqlauthority.com)
Your consistency is inspirational…A lot to learn from you. Happy New Year to you!
SQL Server 2014 Live Plan for Query
when i execute the job for cube refreshment,sometimes it is executing successfully,but sometimes it is getting failed with below error
Started: 4:08:08 AM Error: 2015-01-14 04:55:21.03 Code: 0xC11D0005 Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Transaction errors: The lock operation ended unsuccessfully because of deadlock. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:08:08 AM Finished: 4:55:21 AM Elapsed: 2832.18 seconds. The package execution failed. The step failed.
If any find the solution please post on it.
Looks like that’s SSAS package. I would suggest to post on MSDN SQL forums.