Adding PerformancePoint Dashboard Content to SharePoint
Microsoft SharePoint Server 2010 provides several options for creating Dashboards using PerformancePoint content.
The first option is to implement the...
2013-02-11
3,575 reads
Salvo(z) SQL
SQL Server Analysis Services Tabular KPIs
A few weeks ago, I wrote a blog post that discusses implementing KPIs in SQL Server Analysis Services Multidimensional. For...
2013-02-04
2,628 reads
Currency Conversion in Tabular Model Using DAX
Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the...
2013-01-28
3,878 reads
Re-writing MDX calculated members as DAX measures
I have been working on re-creating some logic in a tabular cube that was originally implemented in multidimensional. This involved...
2013-01-21
1,365 reads
SQL Server Analysis Services KPIs
Key Performance Indicators (KPIs) are measurements used to gauge business performance against quantifiable goals. SQL Server Analysis Services provides functionality...
2013-01-15 (first published: 2013-01-14)
6,584 reads
Querying and Optimizing DAX
Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit. One of the presentations I...
2013-01-02
3,998 reads
Optimizing Your BI Semantic Model for Performance and Scale
Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented...
2012-12-11
3,023 reads
SSIS: Character Replacement Using the Script Component
When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or...
2012-12-08
1,762 reads
T-SQL Tuesday: What Does the SQL Community Mean to You?
Today is T-SQL Tuesday #36, hosted by Chris Yates (B | T). The topic this month is ‘What Does the SQL...
2012-11-13
794 reads
Book Review: SQL Server 2012 Analysis Services The BISM Tabular Model
I will start off by saying, whenever I see the names Marco Russo, Alberto Ferrari and Chris Webb on a...
2012-11-12
1,898 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Forums
ALAMAT BCA KCU SCBD Telp/Wa:0821-8200-233
Tlp Cs Bca 08218200233 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...
Alamat BCA KCP Mayestik Telp/Wa:0821-8200-2031
Phone Cs 08218200203 Jl. Kyai Maja No.77, RT.12/RW.3, Gunung, Kec. Kby. Baru, Kota Jakarta...
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers