SSAS cube processing can kill running queries. That's right, it may kill queries in order to commit changes to the cube.
Here is what happens during SSAS cube processing. (more...)
Archive for May, 2009
How SSAS Cube Processing Affects Running Queries
Friday, May 29th, 2009Execution Plan of Frequent Queries
Friday, May 29th, 2009Bill Galashan, DBA of bet365 sent over the following query that lists the execution plan of the 10 most frequently executed queries.
He writes:
We got into this due to different query plans coming from a VB or a web app than what was seen when running the same query from Management Studio. Eventually tracked this down to a difference in the set options predominatley whether Arithabort was on or off.
Read more to see his query. (more...)
GWT is Flexible — an iPhone Demo
Monday, May 25th, 2009GWT is a very flexible environment that allows you to write a web application in Java and compile it to Javascript -- even for the iPhone.
A number of people have fears with GWT, for instance
- (not true) GWT isn't flexible which will lead developers down a dead-end path.
- (not true) GWT is ugly, and can't be used to make "gucci" UIs.
This post will show that these are just myths. (more...)