SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Sherry Li's BI Corner

Always wanting to publish novels, but having the fortune to work in the data warehouse corner of technology, Sherry Li started to write the mysteries of the Microsoft Business Intelligence. She writes everything from T-SQL to MDX, ETL to Expressions to Scripting, Reporting to Cubes. You can find her writings at bisherryli.wordpress.com.

Archives: September 2013

MDX+SSRS #31– Query Designer in SSRS only allows the Measures dimension in the first axis

In Chapter 1 of the book MDX with SSAS 2012 Cookbook, in the first recipe “Putting data on x and y axes”, I have given a simple example to show how easy it is to use the CROSSJOIN function to "combine" more than one hierarchy into the COLUMNS and… Read more

0 comments, 3,672 reads

Posted in Sherry Li's BI Corner on 28 September 2013

MDX #30 – Get The Book: MDX with SSAS 2012 Cookbook

MDX with SSAS 2012 Cookbook

by Sherry Li and Tomislav Piasevoli

Packt Publishing 2013

The book is now available in both paperback and eBook format. You can order copies from Amazon, Barnes & Nobel, Packt Publishing. It is also available on Safari Books Online.

Hope you will find the book… Read more

0 comments, 1,282 reads

Posted in Sherry Li's BI Corner on 22 September 2013

SQL #50–Deleting or updating data from a table of 20+ GB

I don’t have a definition of what is considered a large SQL table. I am pretty sure, however, that a table with 20+ GB data plus another 20+ GB for a few indices is not a small table anymore.

Although this article The Data Loading Performance Guide was written for… Read more

1 comments, 4,802 reads

Posted in Sherry Li's BI Corner on 22 September 2013