Let's suppose I have one dimension [Dim] with 4 Attributes Attr1,Attr2,Attr3,Attr4. And of course 4 attribute Hierarchies [Dim].[Attr1],...
I have a cube with two partitions ( over time ). One with recent data and one with older. Processing the two partitions takes 1 second for one and 4...
I've a huge #temp_________[number] table in the temp database. I don't know if it is due to a explicit temp table creation or a subquery or another...
Is there a way to "capture" inside a calculated member the "current slice" ( whether it is a member or an agreggate of several members) ?<br /><br...
SQL 2005 x64 setup files ? I've got Windows Server2003 R2 Enterprise x64 edition installed. It's a Xeon Server. I've installed SQL 2005, but it...
It seems that OLAP treats nulls as 0 for the purpose of min/max aggregate. KB Q 244650 If I define a Measure which uses min, the null values become...
I'm trying to create a trigger (without synamic sql) inside a DDL trigger. Something along the lines of this (so you get the idea, of course it...
I've made this question once. I'll make it again, maybe I'll have more luck this time. The problem is with simple queries against linked servers...
Quick question. Using the hint with(nolock) inside an after trigger is pointless, right ? Because the whole thing is inside a transaction, so every...
Hi there. I was planning to migrate some triggers from T-SQL into .NET embedded code. Is there any comparison between T-SQL vs .NET embedded code ?...
Today I was wondering this simple thing. If I have a database in recovery model simple, how the transactional replication works ? If every time I...
Hi there. I'm performing an automatic OLAP DB backup with msmdarch.exe. Everything is going well, but what I'm trying to do is to just archive the...
Hi there. I need to develop some kind of trigger that somehow sends all deleted rows to some kind of "recycle bin" to possible recover them and/or...
Yesterday I got a problem with a 2 node cluster with yukon beta 2 up an running well. There was a loss of electrical power and node 1 which was up...
I'm testing new OLAP / Analisys Services of SQL 2005 beta2. I'm trying to get a grasp of all the new options that I got,like Data Source Views, the...
Hi there. I'm testing a couple of pages we have. .NET Framework v1.1. And after a lot of response.write, I found out that there is almost 1 second...
Hi. I'm doing a simple remote select and I can't seem to get it done (the filter) in the remote server. For example : select * from...
I have a table like this declare @tbl table ( a int , b char(1) ) insert into @tbl values (1,'a') insert into @tbl values (1,'b') insert into @tbl...
I have a couple of tables that should be kept sincronized between 2 SQL servers.<br /><br />There's no much movement in those tables.<br />Let's say...
Sorry about reposting this here as a new thread, but maybe the post was so deep in the thread that nobody pay attention to it. Here it goes again....
Separate names with a comma.
