Forum Replies Created

Viewing 15 posts - 181 through 195 (of 658 total)

  • RE: Running Out Of Foreign Keys

    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...

  • RE: Upgrading cardinality

    Steve Jones - SSC Editor (5/15/2014)


    James Lean (5/15/2014)


    Agree with previous posters, the page referenced in the explanation has the trace flags the wrong way round. A Connect bug has already...

  • RE: Upgrading cardinality

    TomThomson (5/15/2014)


    No, I wont believe 16 and certainly not 6. 5 SQL Server professionals will never all agree on a compromise solution, so the correct answer is not 32, and...

  • RE: Upgrading cardinality

    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...

  • RE: Bean Counting

    Nice idea, but there were not enough options. Just looking at the first select gave the answer.

  • RE: The Results Tab

    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...

  • RE: The Results Tab

    Why the restriction to Grid? The same is true with Text.

  • RE: Alter Column

    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...

  • RE: It's Not All About The Keys

    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...

  • RE: It's Not All About The Keys

    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]

  • RE: Syntax Validation

    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...

  • RE: Default schema

    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...

  • RE: Default schema

    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...

  • RE: Default schema

    victoria_e_wood (3/31/2014)


    In my opinion if the user was in fact a sysadmin why would you assign him or her rights over a database, they would automatically have rights over all...

  • RE: Default schema

    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...

Viewing 15 posts - 181 through 195 (of 658 total)