It seems that I’ve missed a basic concept concerning SQL Server query optimization. The query optimizer can choose to use the indexed view, even when the indexed view isn’t referenced...

What I don’t understand is how the SSAS processing engine could get knowledge of the presence of the indexed view. Well, I do, but only by changing the dimensional model....

Perhaps I should explain a bit more why I’m confused about the example.

In the abovementioned SSAS Operations Guide, the chapter deals with dimension processing and optimizing the relational engine by...

I’ve spent quit a few hours studying something comparable. I ended up writing an vb.net assembly. This assembly accepts an xml variable and writes a windows-1252 encoded xml file to...

There's so much information to be found on the Internet. And sometimes it took some time before a real guru pointed me in the right direction. That's the way I...

Hello,

I've done this once, moving from an Access 2003 frontend/backend to an Access 2003 frontend/SQL backend. And I just started testing the vba-code in the frontend on sql server. ...

As far as I know your url's are right. I've managed to deploy reports and datasource tot a SS document library in this way with VS2005. But I'm facing all...