Forum Replies Created

Viewing 15 posts - 16 through 30 (of 49 total)

  • RE: A Questionable Trigger

    Tricky again :doze: Some important information missing

    4 obvious choices and then you have to :Whistling: guess which one of remaining correct options was taken for the right one :pinch:

    April 2, 2014 at 1:10 am

    #1702344

  • RE: Replication between SQL Server versions

    SQLDCH (3/19/2014)

    Indeed, the context of the question is between 2008R2 and 2005. The answers were poorly worded, but were taken in context of the versions.

    Considering the context there is...

    March 20, 2014 at 1:51 am

    #1698580

  • RE: UNIQUE constraint

    BTW found this request for unique constraint ANSI compliance regarding multiple null values

    December 20, 2012 at 1:15 am

    #1570438

  • RE: UNIQUE constraint

    SQLRNNR (12/20/2012)

    dawryn (12/20/2012)

    SQLRNNR (12/20/2012)

    I don't disagree with the correct answer. I disagree with the explanation. I also do disagree with many of the complaints thus far about the...

    December 20, 2012 at 1:11 am

    #1570436

  • RE: UNIQUE constraint

    SQLRNNR (12/20/2012)

    I don't disagree with the correct answer. I disagree with the explanation. I also do disagree with many of the complaints thus far about the question. ...

    December 20, 2012 at 12:41 am

    #1570429

  • RE: UNIQUE constraint

    Got it wrong for the same reason. I thought about unique filtered indexes but that is not the same as unique constraints which allow one null only.

    December 20, 2012 at 12:33 am

    #1570423

  • RE: Index Types

    Sorry - you were wrong

    :w00t::exclamationmark:

    10, 12

    :ermm::sick::blink::crazy:

    :pinch::doze::blush::rolleyes::hehe::laugh::smooooth:

    July 5, 2012 at 1:17 am

    #1508944

  • RE: SQL Server Agent Proxies

    Anyone remembers SQL2000 Enterprise Manager? It is visible there (with Jobs only). I had that in mind and missed :blush:

    May 15, 2012 at 8:11 am

    #1487723

  • RE: Sequences II

    tommyh (4/23/2012)

    Startvalue will be MinValue (since its not given).

    Check reference again. Start value is different whether sequence is ascending or descending.

    April 24, 2012 at 12:51 am

    #1477927

  • RE: Contained Databases

    Hugo Kornelis (3/28/2012)

    Good question - but what's up with the word "other" in the question?

    It guided me to exclude Contained for an answer :hehe:

    I looked up for documentation and one...

    March 29, 2012 at 2:12 am

    #1466221

  • RE: VIEWS 3

    Koen Verbeeck (3/20/2012)

    It takes minimal space, but space is space. And it ain't only the CREATE VIEW statement...

    I agree any metadata takes space, there is no question about it. Everything...

    March 20, 2012 at 5:50 am

    #1461544

  • RE: VIEWS 3

    Koen Verbeeck (3/20/2012)

    That is the space for the CREATE VIEW statement. That is stored in the sys.sql_modules catalog view. What I'm going after is that extra information is also stored...

    March 20, 2012 at 5:40 am

    #1461534

  • RE: VIEWS 3

    Koen Verbeeck (3/20/2012)

    According to CREATE VIEW (Transact-SQL):

    When a view is created, information about the view is storedin the following catalog views: sys.views, sys.columns, and sys.sql_expression_dependencies.

    Information that is stored in system...

    March 20, 2012 at 2:16 am

    #1461481

  • RE: Model Database

    bitbucket-25253 (2/22/2012)

    Please note that it does not say how to set the model db to read only.

    Is it meant:

    a) Will all new databases …

    b) Will any of new databases …

    This...

    February 22, 2012 at 6:48 am

    #1450236

  • RE: Model Database

    cengland0 (2/22/2012)

    Except for the fact that this question is about 2008 R2 which apparently works differently than 2005 or 2008.

    Tried it on 2005 and 2008 as well and it worked...

    February 22, 2012 at 6:34 am

    #1450219

Viewing 15 posts - 16 through 30 (of 49 total)