Ever get a timeout error when using the “View History” for a SQL Server Agent job? I find this happens when you have a lot of rows of job history and/or the SQL Server box is getting hit hard. So, … Continue reading →
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up a SSAS project created in VS 2008 to see the new features that were available in VS 2010. So I copied … Continue reading →
Every couple of weeks I see this SSAS error when processing one of my cubes: Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element. An error occurred while parsing the ‘StorageMode’ element at … Continue reading →
A quick tip for you: Ever get some SQL or MDX sent to you in an email, or copied from a website, or pulled from SQL Profiler, that is difficult to understand because it’s not formatted? Well, there are a couple … Continue reading →
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever to count all the rows in a table? I had this problem when I would sometimes run counts on a … Continue reading →