Viewing 15 posts - 2,161 through 2,175 (of 3,348 total)
Hugo Kornelis (4/13/2012)
Note that the above is my understanding of the documentation; I have not tried the feature yet.
So I decided to test it. Here are my observations.
First, I updated...
April 13, 2012 at 8:13 am
EL Jerry (4/13/2012)
April 13, 2012 at 7:29 am
L' Eomot Inversé (4/13/2012)
If Steve is right about login checking for a login in master first even when the contained database is specified in the connection parameters we certainly can...
April 13, 2012 at 6:06 am
L' Eomot Inversé (4/13/2012)
Anyone think it would be worth raising a connect item on this?
I think you're misunderstanding the process (or I am, obviously).
Let's say I have a partially contained...
April 13, 2012 at 5:59 am
Toreador (4/13/2012)
Hugo Kornelis (4/13/2012)The syntax used in this question is deprecated
Is it definitely deprecated? The help page doesn't say so, just that the parentheses are optional for backward compatibility and...
April 13, 2012 at 2:34 am
danielfountain (4/13/2012)
How come this is supposed to bring back 6 rows?
select top 5 with ties * from SSCSales order by cMonthSales desc
There are 4 records with 3500. ...
April 13, 2012 at 2:10 am
Good question about some little known features (PERCENT and WITH TIES) of the TOP clause.
Two minor quibbles:
1. It would have been better to present the data ordered by salary. I...
April 13, 2012 at 2:05 am
Cliff Jones (4/12/2012)
Sounds like a good place to keep SQL Server managment data and isolated from my client data. Is that an intended use for Contained Database?
You can already...
April 12, 2012 at 12:42 pm
Thanks for this article, sknox. It's disconcerning to see that, apparently, such grave misconceptions about indexed views exist.
In the introduction, you write that someone told you that NOEXPAND is not...
April 10, 2012 at 1:09 am
EDIT: Jack was faster than me. I did not see his message until after I posted. Sorry for duplicating some of the things he writes.
sknox (4/9/2012)1. If RI enforcement is...
April 9, 2012 at 7:47 am
L' Eomot Inversé (4/7/2012)
Hugo Kornelis (4/6/2012)
L' Eomot Inversé (4/6/2012)
people have complained that questions don't specify "sql 2008 or later" even though there is no other supported release of sql server
Officially,...
April 7, 2012 at 3:23 pm
L' Eomot Inversé (4/6/2012)
people have complained that questions don't specify "sql 2008 or later" even though there is no other supported release of sql server
Officially, SQL Server 2008R2 is a...
April 6, 2012 at 2:31 pm
Sean Lange (4/6/2012)
April 6, 2012 at 8:24 am
I flipped a coin and ended up lucky. Two answers can both be considered correct.
No, a foreign key constraint can not be created across databases. If you refer to the...
April 6, 2012 at 3:13 am
I'm a bit surprised to see the question asking for two answers (one about step 2, one about step 4), and only one answer option for step 2. Why not...
April 4, 2012 at 4:30 am
Viewing 15 posts - 2,161 through 2,175 (of 3,348 total)