Forum Replies Created

Viewing 15 posts - 7,456 through 7,470 (of 18,926 total)

  • RE: Drop all temp tables one time

    GSquared (12/10/2010)

    Then you'll need to drop them explicitly.

    Well you could always reboot the server between runs :hehe:.

    Pls don't try this at home folks!

    December 10, 2010 at 7:08 am

    #1261025

  • RE: Build date table

    Hugo Kornelis (12/9/2010)

    kevin.l.williams (12/9/2010)

    By the way, how many of you read the forum comments and stop after you get to Hugo's? 🙂

    :laugh:

    If that number is significantly large, I'll have to...

    December 9, 2010 at 11:55 am

    #1260718

  • RE: Build date table

    Nils Gustav Stråbø (12/9/2010)

    I don't like questions like this, and not because I got it wrong.

    It teaches me nothing about Sql Server or T-SQL (except debugging peculiar T-SQL), and to...

    December 9, 2010 at 10:26 am

    #1260666

  • RE: SSMS & Database snapshot

    janki (12/3/2010)

    I too Choose "It Depends" Answer and got it wrong

    Me 2... it depends on the sql server version as well which was not specified in the question. ...

    December 3, 2010 at 5:47 am

    #1258329

  • RE: temp table usage

    Jeff Moden (12/2/2010)

    Ninja's_RGR'us (12/1/2010)

    pspeagle (12/1/2010)

    I have read that using the SELECT column list INTO #tablename syntax to create temp tables holds locks in tempdb (create object locks) for the entire...

    December 3, 2010 at 5:29 am

    #1258323

  • RE: Unique constraint on a nullable column

    johnf_amic (12/2/2010)

    Ninja's_RGR'us (12/2/2010)

    97% wrong answers??? Maybe there's something not quite correct with the question.

    A 'correct' answer is one that matches the exact set of correct choices. No partial credit,...

    December 2, 2010 at 8:55 am

    #1257948

  • RE: Unique constraint on a nullable column

    Christian Buettner-167247 (12/2/2010)

    jeff.mason (12/2/2010)

    sjimmo (12/2/2010)

    But once you give out INSERT permission, you lose control over INSERT statements.

    It is not only that. Constraints should prevent invalid data updates no matter where...

    December 2, 2010 at 8:03 am

    #1257905

  • RE: Unique constraint on a nullable column

    jeff.mason (12/2/2010)

    sjimmo (12/2/2010)

    Why would you want to use a where clause to enforce uniqueness? That one stumps me.

    It stumps you because you wouldn't want to do that. Pure...

    December 2, 2010 at 7:39 am

    #1257891

  • RE: Unique constraint on a nullable column

    pjdiller (12/2/2010)

    Very interesting information, and I appreciate it. Way too many answers for this early in the morning though 🙂 Is that 1/256 statistically?

    Yup, but without factoring for...

    December 2, 2010 at 6:45 am

    #1257838

  • RE: DROP Index problem

    I'm not sure you guys are talking about the same thing :

    Rebuild is used to make a copy of the index and drop the old one (which 100% defrags...

    December 2, 2010 at 6:09 am

    #1257820

  • RE: Unique constraint on a nullable column

    97% wrong answers??? Maybe there's something not quite correct with the question.

    More to the point. If my column needs to contain NULL, I'm not going to fiddle around...

    December 2, 2010 at 5:25 am

    #1257801

  • RE: DROP Index problem

    Please post the create statement for both the table and indexes and the drop statement you are trying to execute.

    December 2, 2010 at 5:13 am

    #1257796

  • RE: temp table usage

    pspeagle (12/1/2010)

    I have read that using the SELECT column list INTO #tablename syntax to create temp tables holds locks in tempdb (create object locks) for the entire duration of the...

    December 1, 2010 at 4:42 pm

    #1257675

  • RE: sys.syscomments

    Shawn Melton (12/1/2010)

    I don't see the confusion on why the only acceptable answer would be the 3rd option. Of course I might think differently than others.

    1) Retrieves the name of...

    December 1, 2010 at 4:40 pm

    #1257674

  • RE: Install/move reporting service

    Ann Cao (12/1/2010)

    And Ninja's_RGR'us, could you tell me a little bit what problem you have when you applying service pack to SSRS?

    I never have an experience of applying sp to...

    December 1, 2010 at 2:02 pm

    #1257614

Viewing 15 posts - 7,456 through 7,470 (of 18,926 total)