Viewing 15 posts - 1 through 15 (of 25 total)
The main problem was that mapping the user in the contained database to an SQL Server login was not an option, it had to be contained as well. Meanwhile, I...
March 27, 2017 at 7:56 am
I can't remember anything we did to fix that but after a quick check the issue isn't present anymore, so someone obviously did manage to put things right.
September 8, 2014 at 2:43 am
Thanks for the thorough explanation, Paul. Finally, we've got an answer for both 'where' and 'why'. As this is only used in a development tool and it's quite salient when...
May 18, 2012 at 1:42 pm
Bill Wehnert (5/18/2012)
Table 3 doesn't get created because there is no PK defined on Table2, you can't reference another table without their being a PK.
It does not have to be...
May 18, 2012 at 7:23 am
Yes, it's not the ordering that fails here. Barry clarified quite a few things that was unknown for me but he wasn't saying he is addressing that part of the...
May 18, 2012 at 2:24 am
Yeah, tricky question that bled me to death 🙂 I knew that creation of the third table would have some issues but I still voted for three being created and...
May 18, 2012 at 12:59 am
Yes, a few things got clear! I've learnt many things today 😎 I'm glad I asked 🙂
May 17, 2012 at 4:26 pm
Though the intended use might not be that way, the article doesn't deny it either. Nevertheless, I hope you agree that this undocumented function is useful and that it should...
May 17, 2012 at 11:33 am
And the rest of us will just sit back and watch you fencing 🙂 And drink to knowledge you spill 😉
May 17, 2012 at 10:49 am
That's what I had in mind to try. You spared me some typing, Mike, thank you very much 😉
May 17, 2012 at 8:29 am
HowardW (5/17/2012)
May 17, 2012 at 8:01 am
HowardW (5/17/2012)
There's absolutely no guarantee that the variable assignment will occur in...
May 17, 2012 at 6:05 am
michael vessey (5/17/2012)
how did you come to the step of using TOP 1000000?
Yes, I compared the exec plan as well, but I did not find anything meaningful. Tried a few...
May 17, 2012 at 5:52 am
srikant maurya (5/17/2012)
Can you tell me what is use of statmentRANK() OVER( PARTITION BY t.[name] ORDER BY c.column_id DESC ) = 1
Sure. This query is a part of a...
May 17, 2012 at 5:40 am
michael vessey (5/17/2012)
i took the data from the query into a temp table and then did theselect @sql=@sql+mytext from #res
print @sql
works fine
I'll implement that as...
May 17, 2012 at 5:02 am
Viewing 15 posts - 1 through 15 (of 25 total)