SSAS 2008 MOLAP Writeback (2)

Introduction

In a recent post, I started investigating around a new Analysis Services 2008 feature: writeback partition with MOLAP storage.

Unfortunately, I got stopped by a bug in SQL Server 2008 CTP 5 which disallowed me from committing my updates.

SQL Server 2008 CTP 6 is now available. I can now continue from where I stopped last time.

Committing updates

After our UPDATE CUBE MDX command from SSMS, let’s run a COMMIT TRAN statement to validate our transaction.

This step works perfectly with CTP 6. We can see records inserted by SSAS into the writeback table.

What’s behind the scene?

Processing

When we fully process a MOLAP writeback partition, we notice an extra item (compared to when processing a ROLAP one) in the Process Progress dialog box. This item shows the SQL query to the writeback table used to feed MOLAP writeback partition.

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SSAS2008MOLAPWriteback/Picture04.png

Profiling

If we activate SQL Server Profiler during COMMIT TRAN operation, we can see the following actions.

With ROLAP writeback:

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SSAS2008MOLAPWriteback/Picture06-ROLAP.png

With MOLAP writeback:

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SSAS2008MOLAPWriteback/Picture05-MOLAP.png

Extra WriteData events are issued, notifying SSAS 2008 feed of the MOLAP partition with writeback table data. This incremental feeding seems to be done by processing a temporary partition (named here WriteTable_Budget_INCR_UPDATE_TEMP_epn1o_), then merging it with the writeback partition.

A very interesting point is that if we profile relational database during commit operation, we can see the INSERT BULK T-SQL statement into writeback table, but no SQL query for processing temporary incremental writeback partition. It seems that SSAS takes in memory session updates and "Direct data load" them in this partition, as SQL Server Integration Services (SSIS) does with Partition Processing Data Flow items.

Performance gain

What improvement can we expect from a MOLAP writeback partition?

Test 1 (query)

To apprehend performance gain, we can do a simple test: in both cases (ROLAP and MOLAP), query the same cell, and see what’s being done in SQL Server Profiler.

Test sequence:

  1. Clear cube cache.
  2. Query cell.
  3. Query cell again (to check cache effect).

First query: data is read from measure group partition. With the ROLAP writeback partition, an extra ExecuteSQL event is triggered that reads writeback table data for corresponding cell. Data is cached.

Second query reads data from cache

The need to issue a SQL statement at query time makes MDX query processing longer. This extra step will dramatically increase query execution in situations where cube cell reading relies on many other cells (in case of calculations for example).

Test 2 (update)

The second test intends to observe cube cache consistency after committing updates.

Test sequence:

  1. Clear cache.
  2. Query cell twice.
  3. Update cell
  4. Commit transaction.
  5. Query cell.

In ROLAP mode, the UPDATE CUBE statement triggers 2 ExecuteSQL events to read writeback table data. The commit step doesn’t show a big difference between to two modes (see Profiling section earlier in the article).

In both bases, the commit step clears cube cache. As a consequence, the next cell read won’t be able to rely on cube cache.

That would be nice if SSAS could handle 2 caches: one for the fact data, and one for the writeback data. This would reduce the effect of committing updates.

Which method is faster?

I wrote a VB Script (see previous article on performance) that executes steps of update test (test 2).

I have stressed SSAS with this simple benchmark (running it 10 times), for both ROLAP and MOLAP writeback modes.

The results are shown in table below (times are in seconds):

 

ROLAP

MOLAP

Gain

Query

0.625

0.46875

25%

Update

0.203125

0.109375

46.15%

Commit

8.59375

18.09375

-110.55%

Querying and updating is faster with MOLAP writeback (mainly because no ExecuteSQL event is required to query writeback partition).

Committing is much slower with MOLAP writeback (probably because of the time needed to process/merge temporary partition). This shouldn’t be a major issue, as committing is usually done after a series of queries/updates, like saving a document.

Conclusion

MOLAP Writeback is a promising feature for a read/write OLAP context.

In a budgeting application, where users (sometimes called contributors) submit updates (i.e. commit changes) in a cycle way, query performance decreases, as SSAS permanently issues SQL statements to query writeback table. This won’t be the case anymore with MOLAP Writeback. We can expect here a huge performance improvement.

Advertisements
This entry was posted in Analysis Services 2008. Bookmark the permalink.

7 Responses to SSAS 2008 MOLAP Writeback (2)

  1. 旺立 says:

    http://www.batteries-shop.nethttp://www.batterieslaptop.nethttp://www.uk-laptopbattery.comhttp://www.wt-batteries.comhttp://www.cheapteastore.comhttp://www.laptopbatterystore.co.ukhttp://www.batterieslaptop.nethttp://www.batteries-supply.comhttp://www.powertoolsbatteries.co.ukhttp://www.batterygrip.orghttp://www.uk-batteries.co.ukhttp://www.ukbatterystore.co.ukhttp://www.batteries-shop.net/acer-laptop-battery-c-2.htmlhttp://www.batteries-shop.net/apple-laptop-battery-c-3.htmlhttp://www.batteries-shop.net/asus-laptop-battery-c-4.htmlhttp://www.batteries-shop.net/compaq-laptop-battery-c-5.htmlhttp://www.batteries-shop.net/dell-laptop-battery-c-6.htmlhttp://www.batteries-shop.net/fujitsu-laptop-battery-c-7.htmlhttp://www.batteries-shop.net/gateway-laptop-battery-c-8.htmlhttp://www.batteries-shop.net/hp-laptop-battery-c-9.htmlhttp://www.batteries-shop.net/hp-compaq-laptop-battery-c-10.htmlhttp://www.batteries-shop.net/ibm-laptop-battery-c-11.htmlhttp://www.batteries-shop.net/lenovo-laptop-battery-c-12.htmlhttp://www.batteries-shop.net/lg-laptop-battery-c-13.htmlhttp://www.batteries-shop.net/panasonic-laptop-battery-c-14.htmlhttp://www.batteries-shop.net/samsung-laptop-battery-c-15.htmlhttp://www.batteries-shop.net/sony-laptop-battery-c-16.htmlhttp://www.batteries-shop.net/toshiba-laptop-battery-c-17.htmlhttp://www.uk-laptopbattery.com/acer-laptop-battery-c-2.htmlhttp://www.uk-laptopbattery.com/apple-laptop-battery-c-3.htmlhttp://www.uk-laptopbattery.com/asus-laptop-battery-c-4.htmlhttp://www.uk-laptopbattery.com/compaq-laptop-battery-c-5.html

  2. ping says:

    http://www.batterylaptoppower.com/hp/dv2200.htm Hp dv2200 Battery http://www.batterylaptoppower.com/hp/dv4000.htm Hp dv4000 Battery http://www.batterylaptoppower.com/hp/dv6000.htm Hp dv6000 Battery http://www.batterylaptoppower.com/ibm/thinkpad-t40.htm Ibm thinkpad t40 Battery http://www.batterylaptoppower.com/toshiba/satellite-a105.htm Toshiba satellite a105 Battery http://www.batterylaptoppower.com/toshiba/satellite-m45.htm Toshiba satellite m45 Battery http://www.batterylaptoppower.com/toshiba/pa3285u-3bas.htm Toshiba pa3285u-3bas Battery http://www.batterylaptoppower.com/toshiba/pa3395u-1brs.htm Toshiba pa3395u-1brs Battery http://www.batterylaptoppower.com/toshiba/pa3399u-1bas.htm Toshiba pa3399u-1bas Battery http://www.batterylaptoppower.com/toshiba/pa3399u-1brs.htm Toshiba pa3399u-1brs Battery http://www.batterylaptoppower.com/toshiba/pa3399u-2bas.htm Toshiba pa3399u-2bas Battery http://www.batterylaptoppower.com/toshiba/pa3399u-2brs.htm Toshiba pa3399u-2brs Battery http://www.batterylaptoppower.com laptop battery http://www.batterylaptoppower.com laptop batteries http://www.batterylaptoppower.com/toshiba/pa3465u-1brs.htm Toshiba pa3465u-1brs Battery http://www.batterylaptoppower.com/toshiba/pa3534u-1brs.htm Toshiba pa3534u-1brs Battery http://www.batterylaptoppower.com/toshiba/pa3594u-1brs.htm Toshiba pa3594u-1brs Battery http://www.batterylaptoppower.com/uniwill/255-3s4400-g1l1.htm Uniwill 255-3s4400-g1l1 Battery http://www.batterylaptoppower.com/uniwill/258-4s4400-s1p1.htm Uniwill 258-4s4400-s1p1 Battery http://www.batterylaptoppower.com/hp/pavilion-dv9000.htm HP pavilion dv9000 Battery http://www.batterylaptoppower.com/hp/pavilion-dv9700.htm HP pavilion dv9700 Battery http://www.batterylaptoppower.com/hp/pavilion-dv9500.htm HP pavilion dv9500 Battery http://www.batterylaptoppower.com/hp/pavilion-dv9600.htm HP pavilion dv9600 Battery http://www.batterylaptoppower.com/dell/inspiron-b130.htm Dell inspiron b130 Battery http://www.batterylaptoppower.com/dell/inspiron-mini-9.htm Dell inspiron mini 9 Battery http://www.batterylaptoppower.com/hp/nc8230.htm Hp nc8230 Battery http://www.batterylaptoppower.com/hp/nc8430.htm Hp nc8430 Battery http://www.batterylaptoppower.com/hp/nw8000.htm Hp nw8000 Battery http://www.batterylaptoppower.com/hp/nw8200.htm Hp nw8200 Battery http://www.batterylaptoppower.com/hp/nc6000.htm Hp nc6200 Battery http://www.batterylaptoppower.com/hp/nc6100.htm Hp nc6100 Battery http://www.batterylaptoppower.com/hp/nc6120.htm Hp nc6120 Battery http://www.batterylaptoppower.com/hp/nc6400.htm Hp nc6400 Battery http://www.batterylaptoppower.com/hp/pavilion-dv2000.htm Hp pavilion dv2000 Battery http://www.batterylaptoppower.com/hp/pavilion-dv6000.htm Hp pavilion dv6000 Battery http://www.batterylaptoppower.com/hp/pavilion-dv8000.htm Hp pavilion dv8000 Battery http://www.batterylaptoppower.com/hp/pavilion-dv9000.htm Hp pavilion dv9000 Battery http://www.batterylaptoppower.com/hp/pavilion-dv9500.htm Hp pavilion dv9500 Battery http://www.batterylaptoppower.com/hp/pavilion-dv9600.htm Hp pavilion dv9600 Battery http://www.batterylaptoppower.com/hp/pavilion-dv9700.htm Hp pavilion dv9700 Battery http://www.batterylaptoppower.com/laptop-ac-adapter/acer/aspire-5520.htm Acer aspire 5520 Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/acer/aspire-5920.htm Acer aspire 5920 Adapter http://www.batterylaptoppower.com/dell/kd476.htm Dell kd476 Battery http://www.batterylaptoppower.com/dell/kr-onx511.htm Dell kr-onx511 Battery http://www.batterylaptoppower.com/dell/latitude-d620.htm Dell latitude d620 Battery http://www.batterylaptoppower.com/dell/latitude-d630.htm Dell latitude d630 Battery

  3. ping says:

    http://www.batteryfast.com.au/acer/aspire-9300-series.htm Acer aspire 9300 series Battery http://www.batteryfast.com.au/laptop-ac-adapter/ laptop ac adapter http://www.batteryfast.com.au/laptop-ac-adapter/ laptop ac adapters http://www.batteryfast.com.au/apple/a1185.htm Apple a1185 Battery http://www.batteryfast.com.au/apple/a1185-black.htm Apple a1185 black Battery http://www.batteryfast.com.au/apple/a1185-white.htm Apple a1185 white Battery http://www.batteryfast.com.au/asus/a42-a4.htm Asus a42-a4 Battery http://www.batteryfast.com.au/asus/a42-v6.htm Asus a42-v6 Battery http://www.batteryfast.com.au/clevo/d400.htm Clevo d400 Battery http://www.batteryfast.com.au/clevo/d470w.htm Clevo d470w Battery http://www.batteryfast.com.au laptop battery http://www.batteryfast.com.au laptop batteries http://www.batteryfast.com.au/compaq/dv4000.htm Compaq dv4000 Battery http://www.batteryfast.com.au/compaq/dv6000.htm Compaq dv6000 Battery http://www.batteryfast.com.au/compaq/dv6500.htm Compaq dv6500 Battery http://www.batteryfast.com.au/compaq/nc6000.htm Compaq nc6000 Battery http://www.batteryfast.com.au/compaq/nc8000.htm Compaq nc8000 Battery http://www.batteryfast.com.au/compaq/presario-v4000.htm Compaq presario v4000 Battery http://www.batteryfast.com.au/dell/1501.htm Dell 1501 Battery http://www.batteryfast.com.au/dell/6400.htm Dell 6400 Battery http://www.batteryfast.com.au/dell/d620.htm Dell d620 Battery http://www.batteryfast.com.au/dell/d630.htm Dell d630 Battery http://www.batteryfast.com.au/dell/d820.htm Dell d820 Battery http://www.batteryfast.com.au/dell/d830.htm Dell d830 Battery http://www.batteryfast.com.au/dell/e1505.htm Dell e1505 Battery http://www.batteryfast.com.au/dell/gd761.htm Dell gd761 Battery http://www.batteryfast.com.au/dell/gk479.htm Dell gk479 Battery http://www.batteryfast.com.au/dell/inspiron-1000.htm Dell inspiron 1000 Battery http://www.batteryfast.com.au/dell/inspiron-6000.htm Dell inspiron 6000 Battery http://www.batteryfast.com.au/dell/inspiron-6400.htm Dell inspiron 6400 Battery http://www.batteryfast.com.au/dell/inspiron-9300.htm Dell inspiron 9300 Battery http://www.batteryfast.com.au/dell/inspiron-9400.htm Dell inspiron 9400 Battery http://www.batteryfast.com.au/dell/kd476.htm Dell kd476 Battery http://www.batteryfast.com.au/dell/kr-onx511.htm Dell kr-onx511 Battery http://www.batteryfast.com.au/dell/latitude-d620.htm Dell latitude d620 Battery http://www.batteryfast.com.au/dell/latitude-d630.htm Dell latitude d630 Battery http://www.batteryfast.com.au/dell/latitude-d810.htm Dell latitude d810 Battery http://www.batteryfast.com.au/dell/latitude-d820.htm Dell latitude d820 Battery http://www.batteryfast.com.au/dell/latitude-d830.htm Dell latitude d830 Battery http://www.batteryfast.com.au/dell/pc764.htm Dell pc764 Battery http://www.batteryfast.com.au/dell/vostro-1000.htm Dell vostro 1000 Battery http://www.batteryfast.com.au/dell/vostro-1500.htm Dell vostro 1500 Battery http://www.batteryfast.com.au/dell/vostro-1700.htm Dell vostro 1700 Battery http://www.batteryfast.com.au/dell/wr050.htm Dell wr050 Battery http://www.batteryfast.com.au/dell/xps-m1210.htm Dell xps m1210 Battery

  4. ping says:

    http://www.batterylaptoppower.com/laptop-ac-adapter/toshiba/toshiba-19V-3.42A-65w-5.5mm-2.5mm.php Toshiba PA3467U PA3396U 19V 3.42A 65W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/toshiba/toshiba-19V-3.42A-65w-5.5mm-2.5mm.php Toshiba PA3467U PA3396U 19V 3.42A 65W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/toshiba/toshiba-19V-4.74A-90w-5.5mm-2.5mm.php Toshiba PA3589U 19V 4.74A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/asus/asus-19v-3.42A-65w-5.5mm-2.5mm.php Asus A2 A3 19V 3.42A 65W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/dell/dell-19.5V-3.34A-65w-7.4mm-5.0mm-with-pin-pa-12.php Dell 6400 D620 19.5V 3.34A 65W 7.4MM*5.0MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/toshiba/toshiba-15V-6A-90w-6.3mm-3.0mm.php Toshiba PA2521U PA3201U-1ACA 15V 6A 90W 6.3MM*3.0MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/toshiba/toshiba-15V-3A-45w-6.3mm-3.0mm.php Toshiba PA2450U PA3241U-1ACA 15V 3A 45W 6.3MM*3.0MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/samsung/samsung-19V-3.16A-60w-5.5mm-3.4mm-pin-inside.php Samsung GT8000 GT8600 19V 3.16A 60W 5.5MM*3.4MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/delta/delta-19V-3.42A-65w-5.5mm-2.5mm.php Delta 1680 19V 3.42A 65W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/hp/hp-18.5V-3.5A-65w-4.8mm-1.7mm.php Hp DV2000 DV6000 DV1000 18.5V 3.5A 65W 4.8MM*1.7MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/hp/hp-18.5V-4.9A-90w-5.5mm-2.5mm.php Hp ZT1000 XT1000 18.5V 4.9A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/hp/hp-19V-4.74A-90w-4.8mm-1.7mm.php Hp NC6000 NC8230 19V 4.74A 90W 4.8MM*1.7MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/hp/hp-19V-4.74A-90w-5.5mm-2.5mm.php Hp DV9000 19V 4.74A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-3.42A-65w-5.5mm-2.5mm-white.php Liteon M320 M680 19V 3.42A 65W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-3.95A-75w-5.5mm-2.5mm.php Liteon 1200 1800 19V 3.95A 75W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-4.74A-90w-5.5mm-1.7mm.php Liteon TravelMate 4200 19V 4.74A 90W 5.5MM*1.7MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-4.74A-90w-5.5mm-2.5mm.php Liteon Satellite 1100 19V 4.74A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-6.3A-120w-4pin-round.php Liteon M3 M5244 19V 6.3A 120W 4 PIN ROUND Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/liteon/liteon-19V-6.3A-120w-5.5mm-2.5mm.php Liteon 2200 R3000 19V 6.3A 120W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/compaq/compaq-18.5V-2.7A-50w-4.8mm-1.7mm.php Compaq NC6000 NC8000 18.5V 2.7A 50W 4.8MM*1.7MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/compaq/compaq-19V-3.16A-60w-5.5mm-2.5mm.php Compaq ZT1000 1200 19V 3.16A 60W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/laptop-ac-adapter/compaq/compaq-19V-4.74A-90w-5.5mm-2.5mm.php Compaq NX9000 DV9000 19V 4.74A 90W 5.5MM*2.5MM Adapter http://www.batterylaptoppower.com/sony/vgp-bpl9.htm sony vgp-bpl9 battery http://www.batterylaptoppower.com/sony/vgp-bps10.htm sony vgp-bps10 battery http://www.batterylaptoppower.com/sony/vgp-bps8.htm sony vgp-bps8 battery http://www.batterylaptoppower.com/sony/vgp-bps8a.htm sony vgp-bps8a battery http://www.batterylaptoppower.com/sony/vgp-bps9.htm sony vgp-bps9 battery http://www.batterylaptoppower.com/acer/aspire-one-zg5.htm Acer aspire one zg5 battery http://www.batterylaptoppower.com/toshiba/pa3399u-1brs.htm Toshiba pa3399u-1brs Battery http://www.batterylaptoppower.com/toshiba/pa3399u-2bas.htm Toshiba pa3399u-2bas Battery http://www.batterylaptoppower.com/toshiba/pa3399u-2brs.htm Toshiba pa3399u-2brs Battery http://www.batterylaptoppower.com/toshiba/pa3465u-1brs.htm Toshiba pa3465u-1brs Battery

  5. 旺立 says:

    http://www.batteries-shop.nethttp://www.batterieslaptop.nethttp://www.uk-laptopbattery.comhttp://www.wt-batteries.comhttp://www.replicawatchesstore.nethttp://www.cheapteastore.comhttp://www.laptopbatterystore.co.ukhttp://www.batterieslaptop.nethttp://www.batteries-supply.comhttp://www.powertoolsbatteries.co.ukhttp://www.batterygrip.orghttp://www.uk-batteries.co.ukhttp://www.ukbatterystore.co.ukhttp://www.topbatteries.co.ukhttp://www.batteries-shop.net/acer-laptop-battery-c-2.htmlhttp://www.batteries-shop.net/apple-laptop-battery-c-3.htmlhttp://www.batteries-shop.net/asus-laptop-battery-c-4.htmlhttp://www.batteries-shop.net/compaq-laptop-battery-c-5.htmlhttp://www.batteries-shop.net/dell-laptop-battery-c-6.htmlhttp://www.batteries-shop.net/fujitsu-laptop-battery-c-7.htmlhttp://www.batteries-shop.net/gateway-laptop-battery-c-8.htmlhttp://www.batteries-shop.net/hp-laptop-battery-c-9.htmlhttp://www.batteries-shop.net/hp-compaq-laptop-battery-c-10.htmlhttp://www.batteries-shop.net/ibm-laptop-battery-c-11.htmlhttp://www.batteries-shop.net/lenovo-laptop-battery-c-12.htmlhttp://www.batteries-shop.net/lg-laptop-battery-c-13.htmlhttp://www.batteries-shop.net/panasonic-laptop-battery-c-14.htmlhttp://www.batteries-shop.net/samsung-laptop-battery-c-15.htmlhttp://www.batteries-shop.net/sony-laptop-battery-c-16.htmlhttp://www.batteries-shop.net/toshiba-laptop-battery-c-17.htmlhttp://www.uk-laptopbattery.com/acer-laptop-battery-c-2.htmlhttp://www.uk-laptopbattery.com/apple-laptop-battery-c-3.htmlhttp://www.uk-laptopbattery.com/asus-laptop-battery-c-4.htmlhttp://www.uk-laptopbattery.com/compaq-laptop-battery-c-5.htmlhttp://www.uk-laptopbattery.com/dell-laptop-battery-c-6.htmlhttp://www.uk-laptopbattery.com/fujitsu-laptop-battery-c-7.htmlhttp://www.uk-laptopbattery.com/gateway-laptop-battery-c-8.htmlhttp://www.uk-laptopbattery.com/hp-laptop-battery-c-9.htmlhttp://www.uk-laptopbattery.com/hp-compaq-laptop-battery-c-10.htmlhttp://www.uk-laptopbattery.com/ibm-laptop-battery-c-11.htmlhttp://www.uk-laptopbattery.com/lenovo-laptop-battery-c-12.htmlhttp://www.uk-laptopbattery.com/lg-laptop-battery-c-13.htmlhttp://www.uk-laptopbattery.com/panasonic-laptop-battery-c-14.htmlhttp://www.uk-laptopbattery.com/samsung-laptop-battery-c-15.htmlhttp://www.uk-laptopbattery.com/sony-laptop-battery-c-16.htmlhttp://www.uk-laptopbattery.com/toshiba-laptop-battery-c-17.htmlhttp://www.topbatteries.co.uk/acer-laptop-battery-c-1.htmlhttp://www.topbatteries.co.uk/hp-laptop-batteries-c-2.htmlhttp://www.topbatteries.co.uk/sony-laptop-battery-c-3.htmlhttp://www.topbatteries.co.uk/dell-laptop-battery-c-4.htmlhttp://www.topbatteries.co.uk/ibm-laptop-battery-c-5.htmlhttp://www.topbatteries.co.uk/compaq-laptop-battery-c-6.htmlhttp://www.topbatteries.co.uk/toshiba-laptop-battery-c-7.htmlhttp://www.topbatteries.co.uk/fujitsu-laptop-battery-c-8.htmlhttp://www.topbatteries.co.uk/apple-laptop-battery-c-9.htmlhttp://www.topbatteries.co.uk/samsung-laptop-battery-c-10.htmlhttp://www.cheapteastore.com/chinese-black-tea-c-3.htmlhttp://www.cheapteastore.com/chinese-herbal-tea-c-7.htmlhttp://www.cheapteastore.com/chinese-oolong-tea-c-2.htmlhttp://www.cheapteastore.com/chinese-puerh-tea-c-4.htmlhttp://www.cheapteastore.com/chinese-white-tea-c-5.htmlhttp://www.cheapteastore.com/chinese-yellow-tea-c-6.htmlhttp://www.cheapteastore.com/tie-guan-yin-c-8.html

  6. Sam Kane says:

    Here are this and some other articles on SSAS Write Back: http://ssas-wiki.com/w/Articles#Write_Back

  7. SQL Lion says:

    All features of SQL Server IDENTITY property of columns. And a handy procedure to monitor all Identity columns. http://www.sqllion.com/2011/08/identity-in-sql/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s