Viewing 15 posts - 796 through 810 (of 1,034 total)
Can anybody at least point me to a tutorial on creating calculated dimensions?
So far I've got a calculated dimension that looks like this.
IIF(ISEMPTY([Measures].[Screen Views Count]),0,
((
...
September 1, 2009 at 12:47 pm
I have to agree...
respective to the first answer, the second has a lower order of precedence for both answer 1, and 2... because user defined is the top... and...
August 24, 2009 at 10:45 am
I agree... I got this one right, but I was torn between the equivacy of answer 1 and 2.
1 makes no mention of row 1, hence it is left alone.
2...
August 21, 2009 at 8:30 am
Patricia Johnson (8/12/2009)
I looked and the resources are online.
I just want to confirm that all the resources are online?
In my case when I went to do the install,...
August 13, 2009 at 7:48 am
select
a.[name]
from
sys.columns a join sys.tables b on
a.object_id = b.object_id
where
b.[name] = ''
August 12, 2009 at 3:38 pm
Patricia Johnson (8/12/2009)
August 12, 2009 at 3:19 pm
I remember seeing this...
Do you have any offline storage resources in your cluster groups? I had this exact problem when I had an offline disk that I had no...
August 12, 2009 at 3:04 pm
rja.carnegie (8/12/2009)
I will say that I for one wouldn't write 20 tips for better SQL without doing some research to make sure that all 20 were valid for all versions...
August 12, 2009 at 10:00 am
Lynn Pettis (8/11/2009)
Not all posts are related to the article itself. That is one of the benefits of this community and where you actually learn new things or ideas.
And...
August 12, 2009 at 7:45 am
Jeff Moden (8/11/2009)
Heh... by the way, Lynn... I love your new avatar... it's exactly the same as the old one except you have pink skin this time. 😛
Yours is pretty...
August 11, 2009 at 10:33 am
Lynn Pettis (8/10/2009)
mtassin (8/10/2009)
I'm sure she wasn't hinting at you. I am pretty sure I have an idea or two who she was thinking about as she wrote this...
August 11, 2009 at 8:10 am
GilaMonster (8/10/2009)
mtassin (8/10/2009)
And who determines who should be in the group? If it's forum ranking alone, there are several people (who shall remain unnamed) with over 1000 points and (based...
August 10, 2009 at 3:41 pm
steve_melchert (8/10/2009)
August 10, 2009 at 3:17 pm
GilaMonster (8/10/2009)
yadavmanoj (8/10/2009)
What about NO LOCK in the Select?Only if you like your data dirty.
See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Some days it's a choice between that and query timeout.
We've got a ton of...
August 10, 2009 at 12:51 pm
ta.bu.shi.da.yu (8/10/2009)
vetri (8/10/2009)
I tried with these two statements but the second one is not get executing and it says "Incorrect syntax near the keyword 'exists'." What wrong...
August 10, 2009 at 7:48 am
Viewing 15 posts - 796 through 810 (of 1,034 total)