Forum Replies Created

Viewing 15 posts - 286 through 300 (of 471 total)

  • RE: Auditing Foundation

    OCTom (7/23/2010)

    Ninja's_RGR'us (7/23/2010)

    What the heck is sql traps :w00t:???

    They catch the rodents running around the database. You have your choice of humane live traps, which became available in SQL Server...

    July 23, 2010 at 7:34 am

    #1197501

  • RE: Are we in all these cities?

    Dave62 (7/13/2010)

    Hugo Kornelis (7/13/2010)

    ...

    I hope the author will stop by and tell us what he/she was trying to teach us with this question. Maybe I missed the deeper issue here.

    I...

    July 13, 2010 at 8:59 am

    #1192096

  • RE: Table Variable :Doesn't care

    Duncan Pryde (7/7/2010)

    Of course, one place this behaviour comes in useful is if you want to store the values from an output clause when rolling back a transaction. Just store...

    July 7, 2010 at 8:09 am

    #1189631

  • RE: T-SQL Logic

    ziangij (6/22/2010)

    and database_id < 2

    this was enough to answer the question...:-)

    Yes, if 10 would have been a possible answer it would have forced me to at least look at the...

    June 22, 2010 at 8:55 am

    #1183392

  • RE: Stored Procedure Execution

    UMG Developer (6/9/2010)

    DLathrop (6/9/2010)

    Full three part naming helps the query optimizer recognize and reuse queries in the execution plan cache.

    I understand that you need to use two part naming, but...

    June 9, 2010 at 3:57 pm

    #1178327

  • RE: Stored Procedure Execution

    prashant.bhatt (6/9/2010)

    Very Nice question

    I am not sure but the query is returning me 5....

    I dont have the AdventureWorks db on the server...

    Tried using the test database with dbo schema.... may...

    June 9, 2010 at 8:27 am

    #1177989

  • RE: T-SQL

    tommyh (6/3/2010)

    Okay so now you can use ODBC functions inside SQL. So learnt something new and thus the purpose off the question is fulfilled (now that was a hard word...

    June 4, 2010 at 8:08 am

    #1176537

  • RE: Memory Configuration on SQL Server 2005

    Could be that your conversion from megabytes to gigabytes and kilobytes is incorrect. By setting max server memory to 50000, you are actually configuring the max memory to abut...

    June 2, 2010 at 10:02 am

    #1175399

  • RE: Index Structures

    jts_2003 (5/27/2010)

    A quick search on Microsft's website:

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

    This clearly gives 8, which wasbn't even an option!

    Not my favourite question, although it did make me think a bit more about indexes I...

    May 27, 2010 at 10:32 am

    #1173445

  • RE: Index Structures

    atikdesai (5/21/2010)

    I count 9.

    Clustered, Nonclustered, Unique, Index with included columns, Indexed views, Full-text , Spatial, Filtered, XML

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

    I agree, this was my count also. I guess some of these different...

    May 21, 2010 at 1:25 pm

    #1171073

  • RE: Backup\ Restore completion Status.

    dgabele (5/18/2010)

    Once a job completes (100%), it no longer appears in the dmv right? Am I correct in understanding that the DMV only shows currently executing requests?

    Thanks

    I think had...

    May 18, 2010 at 12:53 pm

    #1169043

  • RE: Clustered indexes

    The Dixie Flatline (5/14/2010)

    Tom.Thomson (5/11/2010)

    Cliff Jones (5/6/2010)

    What threw me off was "All nonclustered indexes include the clustered index columns in their index pages" . I thought this was incorrect...

    May 15, 2010 at 8:37 am

    #1167930

  • RE: Clustered indexes

    Strommy (5/6/2010)

    The part of me ready for trick questions missed the part about NCL having CL pointers in the IX pages. I thought "well, only the leaf level pages...

    May 6, 2010 at 4:07 pm

    #1163677

  • RE: Clustered indexes

    Grant Fritchey (5/6/2010)

    Tom Brown (5/6/2010)

    This question must be clearing up common confusions - only 2% got it right so far - thats the worst ratio of correct answers I've...

    May 6, 2010 at 9:01 am

    #1163306

  • RE: Clustered indexes

    What threw me off was "All nonclustered indexes include the clustered index columns in their index pages" . I thought this was incorrect because the clustered index columns are...

    May 6, 2010 at 8:19 am

    #1163249

Viewing 15 posts - 286 through 300 (of 471 total)