Forum Replies Created

Viewing 15 posts - 91 through 105 (of 521 total)

  • RE: Know Your SQL Objects

    Steve Jones - SSC Editor (5/13/2011)

    Comments encouraged on the changes.

    As mentioned above, the answer for

    Text Data is stored on data pages

    is "it depends".

    Either that Text part of the...

    May 13, 2011 at 9:15 am

    #1324380

  • RE: Know Your SQL Objects

    I got caught by the wording of Extents can be owned by only one object as well.

    Maybe a language issue, but I interpreted it as the complementary answer to Extents...

    May 13, 2011 at 5:42 am

    #1324209

  • RE: Performance Counters

    Steve Jones - SSC Editor (5/9/2011)

    Christian Buettner-167247 (5/9/2011)

    The answer does not sound right to me.

    For heaps, there are no page splits, therefore the only counter that gives me the answer...

    May 10, 2011 at 1:41 am

    #1322130

  • RE: Performance Counters

    The answer does not sound right to me.

    For heaps, there are no page splits, therefore the only counter that gives me the answer for both, indexes & heaps, is the...

    May 9, 2011 at 1:59 am

    #1321569

  • RE: Operators

    paul.james 64212 (3/28/2011)

    OK, can somebody suggest why this returns "Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '='." on my 9.0.4207 SQL server?

    declare @i tinyint

    SELECT...

    March 28, 2011 at 2:56 am

    #1304222

  • RE: Operators

    Tom.Thomson (3/27/2011)

    One comment though: depending on settings of ARITHABORT and ANSI WARNINGS, it is quite possible that none of the answer options will result, because the batch is terminated before...

    March 28, 2011 at 2:55 am

    #1304220

  • RE: Scaled-down SQL

    Very good question, indeed. +++

    March 21, 2011 at 1:53 am

    #1301132

  • RE: Resource Governer

    CirquedeSQLeil (3/2/2011)

    Are we sure about that answer?

    http://msdn.microsoft.com/en-us/library/bb934013.aspx States:

    " Disabling Resource Governor has the following results:

    All existing workload group and resource pool settings are reset to their default values.

    "

    The default values...

    March 2, 2011 at 1:22 am

    #1293373

  • RE: Heaps

    Got the question right, but why is a page full with 4 rows á 1000 bytes?

    March 1, 2011 at 1:54 am

    #1292752

  • RE: Valentines Day

    What? Only 4 points for this tough question? You must be kiddin' me!:-P

    February 14, 2011 at 3:10 am

    #1286350

  • RE: SQL CLR App Domains

    Good one.

    This explanation here is a little more detailed:

    Application Domains and CLR Integration Security

    http://msdn.microsoft.com/en-us/library/ms345100.aspx

    February 9, 2011 at 2:00 am

    #1284264

  • RE: Automated Trigger To Require a WHERE Clause

    luciano furlan (2/7/2011)

    Christian Buettner-167247 (2/7/2011)

    luciano furlan (2/7/2011)

    We need an improvement over Sql language, that doesn't allow writing statements without the where clause.

    No, we don't. Why would I write a where...

    February 7, 2011 at 1:20 am

    #1282966

  • RE: Automated Trigger To Require a WHERE Clause

    luciano furlan (2/7/2011)

    We need an improvement over Sql language, that doesn't allow writing statements without the where clause.

    No, we don't. Why would I write a where clause when I want...

    February 7, 2011 at 12:55 am

    #1282956

  • RE: sp_spaceused without VIEW DATABASE STATE permission

    Hi Mohammed,

    thank you for responding, but I think you may have misunderstood my question.

    But I woke up now anyways. The explanation is simple: Ownership chains.

    http://msdn.microsoft.com/en-us/library/ms188676.aspx

    February 3, 2011 at 2:19 am

    #1281765

  • RE: Corruption Detection

    Oh, is it groundhog day already?

    January 31, 2011 at 12:42 am

    #1280264

Viewing 15 posts - 91 through 105 (of 521 total)