Archive for May, 2009

How SSAS Cube Processing Affects Running Queries

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. Read the rest of this entry »

Tags: ,

No Comments

Execution Plan of Frequent Queries

Bill 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. Read the rest of this entry »

Tags: , , , , ,

No Comments

GWT is Flexible — an iPhone Demo

GWT 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. Read the rest of this entry »

Tags: , ,

10 Comments