Viewing 15 posts - 181 through 195 (of 658 total)
Eric M Russell (5/21/2014)
By default, foreign keys are not indexed, and nor should they generally speaking.
If the table is large and the referenced table allows deletion, then foreign keys...
May 22, 2014 at 3:24 am
Steve Jones - SSC Editor (5/15/2014)
James Lean (5/15/2014)
May 16, 2014 at 1:17 am
TomThomson (5/15/2014)
May 15, 2014 at 8:46 am
Whatever the truth about the trace flags, I disagree with the answer.
In my opinion, the best way to test the behaviour of a particular database version is on a database...
May 15, 2014 at 6:32 am
Nice idea, but there were not enough options. Just looking at the first select gave the answer.
May 12, 2014 at 2:17 am
Hany Helmy (5/3/2014)
You can drag & drop that border line between query pane & result pane to minimize the result pane.
Indeed you can. And then drag and drop it back...
May 6, 2014 at 2:31 am
Thomas Abraham (4/30/2014)
BWFC (4/30/2014)
You can actually go back years and answer old questions if you just want to rack up points.
Some people do. They add extra points by adding a...
May 1, 2014 at 2:44 am
SQLRNNR (4/16/2014)
The [databases] object intended (and therefore meant by the question) was in the sys schema.
No it wasn't. According to the explanation it was in the dbo schema - but...
April 16, 2014 at 6:33 am
SQLRNNR (4/15/2014)
Every system has a sys.databases and that is what the question was referring to.
No it isn't - the question clearly refers to [dbo].[databases]
April 16, 2014 at 2:25 am
I agree with Tom, that None of the Above is probably the best answer (though I went for running in dev).
NOEXEC is definitely not correct though. Just try this
SET NOEXEC...
April 14, 2014 at 6:54 am
Uwe Ricken (4/2/2014)
Now I have the scenario as you have described in your question
No - you have a scenario, not the scenario. You have made an assumption about how the...
April 2, 2014 at 10:39 am
mkeustermans (4/1/2014)
Since king_login has default schema of king_schema and has been assigend the db_owner role and no other, the table will be created as king_schema
Like many, you are getting confused...
April 1, 2014 at 5:17 am
victoria_e_wood (3/31/2014)
March 31, 2014 at 9:32 am
Bobby Russell (3/31/2014)
We cannot assume the user is a sysadmin on the server.
Nor can you assume that they are not (assuming you mean 'login' rather than 'user').
Which is...
March 31, 2014 at 7:52 am
Viewing 15 posts - 181 through 195 (of 658 total)