Viewing 13 posts - 1 through 13 (of 13 total)
I am quite honestly confused 🙁
I simply cannot see, what "implicit transaction option" have to do with the resolution of the problem.
If it was "off" then the delete would...
November 1, 2007 at 2:46 pm
The supplied answer is wrong :angry:
This is WRONG:
"The UDA Terminate method must return the same type of data that the Accumulate method accepts"
There is absolutely no problem in having different...
October 24, 2007 at 7:11 am
Sorry some of my text disappeared presumably because I was using some special characters... Following here is (hopefully :)) the full text...
I assume that you are using Analysis Services -...
October 24, 2007 at 5:02 am
I assume that you are using Analysis Services - otherwise this will not help you at all... 🙂
You can the the boss'es own values by addressing .Datamember and if...
October 24, 2007 at 4:57 am
Hmmmm.... Trick question - didn't see that one coming...
October 22, 2007 at 4:30 am
The question is somewhat ambiguous - it needs an "opposed to what" scenario.
I supposed that it was opposed to "define and calculate it in MDX / the frontend each time...
October 19, 2007 at 2:18 am
Am I missing something here??
SQL2K5 Maint. plans can most certainly have more than one schedule per plan - it can have one schedule per task (or subplan if you will),...
October 17, 2007 at 2:05 pm
Baklabob (4/27/2005)
I'm sorry, but with all due respect, Bob is not correct, and neither are you. I pose this question to you as an example:
Howcould youtravel from Kansas to England?
A....
October 17, 2007 at 2:34 am
I find the question / answer somewhat misleading.
As stated: "if you modify it, you cannot run it or edit it as a maintenance plan." which also can be expressed as...
October 17, 2007 at 2:13 am
If you refer to the fact that scripting the procedure(s!) generates one script with two create statements then that is not really the point (that is just a matter of...
October 15, 2007 at 2:12 am
The supplied answer is simply wrong!
To separate procedures are created.
As Books Online states (about the number "n" that can be supplied when creating a stored procedure):
"Is an optional integer that...
October 12, 2007 at 7:18 am
I find the question / answer somewhat misleading.
The fact is, that even if the default fillfactor value is 0, then the resulting fillfactor of the index is 100.
As the question...
July 17, 2007 at 4:41 am
I know that this is an old QOD, but nevertheless...
The answer is simply wrong - it is in NO WAY necessary to make a full process when redesigning only aggregations, see:
July 9, 2007 at 5:01 am
Viewing 13 posts - 1 through 13 (of 13 total)