Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: October 2013

MDX #32 – Vincent Rainardi’s blog

I came across Vincent Rainardi’s blog, and thought I’d share it with the readers.

Sherry Li and Tomislav’s 2012 MDX Cook Book

I’d also like to thank Vincent for writing up the review so quickly.

I browsed through Vincent’s blog, and found that he authored this book:

Building a Data… Read more

0 comments, 284 reads

Posted in Sherry Li's BI Corner on 24 October 2013

SQL #52 – set statistics xml on

When tuning SQL queries, I find that I use the following three SET options quite often. 

set showplan_xml on

When showplan_xml option is ON for a session, the execution of SQL queries in the same session will only show the estimated execution plan. No query results will be generated.

Here… Read more

0 comments, 319 reads

Posted in Sherry Li's BI Corner on 24 October 2013

SQL #51 – Timeout when updating a big table

A co-worker recently asked me why she would get timeout when updating a column in a big table. This column will be updated to 0 (zero) because a default value of 0 (zero) constrain is now added to the table.

The table has over 40 million records. Although I didn’t… Read more

2 comments, 1,775 reads

Posted in Sherry Li's BI Corner on 24 October 2013