(Marco Russo) Often end users use Excel to navigate into the cube. Then they may ask you to produce a report using the same data. It would be useful to get the MDX query used by Excel. Moreover, Excel 2007 offers a good MDX quality of the produced query against Analysis Services 2005 (much better th
Other News
Upcoming IBM Teleconference: WebSphere and DB2 Pooling and Caching… Help with Your Decision
(Willie Favero) This one sounds like a winner. It’s a great topic with an excellent speaker. Even if you are not into WebSphere, I think you can still get a ton of information out of this session. And Maryela really knows her stuff!!!
Using the developerWorks XML validation tools
(Ian Shields) If you can’t find a validating XML editor you like, or prefer not to take the time now to learn how to use one, you can edit the XML for your developerWorks articles and tutorials using your preferred text editor. The author has created some great tools to help you validate, transform,
TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
(Peter Zaitsev) We all know disk based temporary tables are bad and you should try to have implicit temporary tables created in memory where possible, do to it you should increase tmp_table_size to appropriate value and avoid using blob/text columns which force table creation on the disk because MEM
Rule-based vs. cost-based optimization
(Brian Peasland) Please tell me the difference between rule-based and cost-based optimization of SQL queries, in detail. Thank you. (R)
32 bit tools on a x64 server
(Louis Davidson) Ok, I readily admit I don’t know everything about SQL Server. But today I learned something that I would have thought I would have seen somewhere. I was having issues getting an SSIS package to build some offline cubes (on my 32 bit workstation, and tested initially on a 32 bit se
ASP.NET Tip: ASP.NET 2.0 Introduces FileUpload Control
(Eric Smith) One of the things that always baffles me about ASP.NET is why some HTML controls (such as text boxes and images) have ASP.NET equivalents and others (such as the file upload control) don’t. ASP.NET 2.0 rectifies this situation with the new FileUpload control, which is designed to replac
How to Use Oracle Java XQuery API
(Anghel Leonard) This code outlines the main steps involved in using the Oracle Java XQuery API (OJXQI). If you are familiar with the DataDirectXQuery – XQuery for Java (DDXQ-XQJ), you may notice a some similarities.
Loading XSLT stylesheets embedded into an assembly – the right way
(Oleg Tkachenko) Everybody knows that XSLT stylesheet can be embedded into an assembly by setting in Visual Studio its “BuildAction” property to “Embedded Resource”. Such stylesheet then can be loaded using Assembly.GetManifestResourceStream() method.
Stored procedures: Balance network loads — part 1
(Ron Turull) SQL (Structured Query Language) stored procedures are a great feature. They provide an excellent tool to help optimize client/server applications. By shifting key portions of the processing onto the server, network data flows can be reduced substantially. All this without bogging down t