Forum Replies Created

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

  • RE: Variable Array Table

    Hugo Kornelis (10/12/2010)

    lukus_g (10/12/2010)

    so, does the transaction actually run and get rolled back?

    No.

    The author of the question uses a long explanation to expand on how usefull the possibility to use...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 12, 2011 at 12:16 am

    #1367722

  • RE: Printing Lengths

    Thanks for the question! Learned something today. I knew about the default length for char/varchar, but not the convert issue. An important sample to show why you shouldn't omit default...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 11, 2011 at 12:55 am

    #1367068

  • RE: Shrink Database

    SanDroid (8/10/2011)

    hakan.winther (8/10/2011)

    SanDroid (8/10/2011)

    SQLRNNR (8/10/2011)

    I think this is a great question.

    As would I if the error in the script did not cause the wrong result.

    It seems incorrect to give a...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 11, 2011 at 12:36 am

    #1367063

  • RE: Shrink Database

    OzYbOi d(-_-)b (8/10/2011)

    great question. hope that the lesson isn't lost in all the kerfuffle... 😀 :hehe:

    I agree with you! There are so many databases with performance issues and...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 11, 2011 at 12:29 am

    #1367062

  • RE: Shrink Database

    SanDroid (8/10/2011)

    SQLRNNR (8/10/2011)

    I think this is a great question.

    As would I if the error in the script did not cause the wrong result.

    It seems incorrect to give a point to...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 10, 2011 at 10:52 am

    #1366743

  • RE: Fun(?) with DATETIME2

    I expected it to work and it did ( as it should in most countries except in brittain ) 🙁

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 10, 2011 at 5:40 am

    #1366480

  • RE: Shrink Database

    j_baldwinson (8/10/2011)

    I was expecting the fragmentation to grow on the basis that pages at the end of a database file get moved to empty pages earlier during a shrink.

    When i...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 10, 2011 at 5:24 am

    #1366470

  • RE: Shrink Database

    I am surprised that 60% thought it wouldn't increase! Shrinking a databases is like the opposite of defragmentation! I have seen some terrible examples at some clients using "auto shrink"...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 10, 2011 at 2:12 am

    #1366417

  • RE: Computed Column Divide by Zero?

    Good question, i thought it would happen upon insert, but I didn't realize that it was not persisted.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 9, 2011 at 6:58 am

    #1365860

  • RE: What's the best way to count?

    You can read another discussion about row count at :

    http://ask.sqlservercentral.com/questions/1980/how-do-i-get-a-list-of-sql-server-tables-and-their-row-counts?page=1#1983

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 9, 2011 at 6:51 am

    #1365854

  • RE: Can the Secondary files in a database be taken offline?

    Good question! I also want to recommend everyone to create one or more filegroup for user objects (like tables and indexes) and never place any user object in primary filegroup....

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 9, 2011 at 2:10 am

    #1365662

  • RE: Page Compression in Heaps

    Tanks for the question, I learned something today.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 9, 2011 at 1:26 am

    #1365643

  • RE: TRUNCATE in TRANSACTION

    Thanks for the trick question, I am glad someone dares to post questions to QotD.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 9, 2011 at 12:58 am

    #1365636

  • RE: SELECT TOP

    The correct answer should be "it depends". As already stated, there are no guarantees even it seem to work in some cases, but with larger tables, parallell plans, many users...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 8, 2011 at 7:14 am

    #1365194

  • RE: Table Design

    Excellent question, I guessed the right answer, but I definitely learned something.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

    August 8, 2011 at 6:05 am

    #1365130

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