Planning for disaster recovery in SQL Server Analysis Services can be tricky. Fortunately SQL Server 2005 introduces the concept of a database synchronization, allowing you to transfer information and meta data from one server to another. Yaniv Mor brings us a look at this feature.
2007-05-02
4,432 reads
Analysis Services and business intelligence are new structures for most of the SQL Server world. BI expert Yaniv Mor brings us another article on Analysis Services, this time explaining the various different options for storing your cube data.
2006-10-31
7,290 reads
For those of you using Analysis Services, Yaniv Mor takes a look at some of the manageablity tools with SQL Server 2005. The way you work with Analysis Services and your cubes has changed dramatically and this is a good overview to get you started.
2006-06-07
6,146 reads
One of the difficult parts of developing anaylsis services cubes is determining which aggregations should be chosen. Yaniv Mor brings us the second part of his series and examines using Usage Based Optimization in SQL Server 2005.
2006-05-30
8,057 reads
Analysis Services 2005 seems like it receives much less notice than most of the other features in the latest version of SQL Server. However it is becoming more widely used in more and more companies. One of the features that can prove useful is the logging of queries. New author Yaniv Mor brings us a look at how this has changed in 2005.
2006-05-16
8,580 reads
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
Hi All, I am currently testing the Table Partitioning to implement in SQL server...
Comments posted to this topic are about the item STRING_AGG's behavior
Comments posted to this topic are about the item The Role of Databases in...
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOselect STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;