-
Clearing the SQL Server Analysis Services Cache
Preparing to do some MDX performance testing? Step one for each and every test should be to clear the cache. This will ensure you are seeing the performance results without the benefit of having data already loaded up in memory. How do you empty the MS SQL Analysis Services cache prior to running your query?
-
The Four Database Design Principles You Should Be Using
“Obey the principles without being bound by them.” -Bruce Lee Do you have some guiding principles you use when designing a new feature or when implementing a new requirement? I do. And you should too. I put them to paper a few years ago while we were undergoing a hiring binge and I wanted…
-
Free Zip Code, City, County, State, CSV
Free Download of the zip code CSV file available at the bottom of this post. Why this is so hard to track down I don’t know. We were looking for a comma delimited list which would map zip code to county since county is the lowest grain available in the out of the box SQL…