Forum Replies Created

Viewing 15 posts - 21,151 through 21,165 (of 49,552 total)

  • RE: Locking

    You can use the applock feature (see Books Online for details), but it still requires some custom code.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2012 at 3:13 am

    #1431663

  • RE: Difference between Partition and index for table

    If you've got the partitioning correct, you can load into a separate table, create indexes then switch that into the partitioned table, same with deletes, switch the partition with...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2012 at 2:28 am

    #1431640

  • RE: Difference between Partition and index for table

    Data loading - inserting data into the table

    Data removal - removing or deleting data from the table.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2012 at 2:11 am

    #1431628

  • RE: Locking

    Suresh B. (1/11/2012)

    You can add a column to the table called Locked with default value N.

    When you read it for monitoring, change the column value to Y.

    If value is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2012 at 2:10 am

    #1431627

  • RE: DB MIRROR Error

    Does that network address exist and can it be reached?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2012 at 1:44 am

    #1431615

  • RE: How does DELETE/SHRINK DATABASE work

    Steve2012 (1/10/2012)

    There is a TSQL-Command like "DBCC SHRINKDATABASE" which is often proposed to be a good choice after deleting many records.

    Basically, it is supposed to reorganize a db. But what...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2012 at 1:12 am

    #1431607

  • RE: Difference between Partition and index for table

    The main advantages of partitioning are around maintenance, data loading and data removal (if the partitioning is done properly)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2012 at 1:00 am

    #1431603

  • RE: Are the posted questions getting worse?

    mtillman-921105 (1/10/2012)

    I guess I'm really the only nerd around here,

    You and me apparently. We'll go be hopeless somewhere...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2012 at 3:40 pm

    #1431475

  • RE: Few tricky Questions about SQL Server 2008 that I came across...

    If I got those from a company prior to an interview, I would think twice (or more) about whether I wanted to work there. Whoever wrote those questions has no...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2012 at 3:34 pm

    #1431472

  • RE: Very Puzzling T-SQL question

    LutzM (1/10/2012)

    GilaMonster (1/10/2012)

    SQLKnowItAll (1/10/2012)

    mdonald 98074 (1/10/2012)

    You guys are right. I will go the route of counting my delimiters and adding 1. Thank you. Sometimes you look at...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2012 at 3:29 pm

    #1431468

  • RE: Question

    nawaz1774 (1/10/2012)

    I read in a book that "Server roles are Static Objects"

    What do Static Objects mean?

    They can't be changed (and in 2008 R2 and below, can't be added to either)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2012 at 3:26 pm

    #1431465

  • RE: Very Puzzling T-SQL question

    SQLKnowItAll (1/10/2012)

    mdonald 98074 (1/10/2012)

    You guys are right. I will go the route of counting my delimiters and adding 1. Thank you. Sometimes you look at something for...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2012 at 3:24 pm

    #1431464

  • RE: Few tricky Questions about SQL Server 2008 that I came across...

    JagWalia (1/10/2012)

    Q: Which of the following allows for the truncation of a transaction log?

    A. Transaction logs are truncated when you use SQL Profiler.

    B. Transaction logs are truncated when you use...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2012 at 3:21 pm

    #1431462

  • RE: Displaying SQL Server Syntax in WordPress

    SyntaxHighlighter plugin.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2012 at 2:04 pm

    #1431404

  • RE: Are the posted questions getting worse?

    WayneS (1/10/2012)

    GilaMonster (1/9/2012)

    mtillman-921105 (1/9/2012)

    Then, thanks to one of Ms. Shaw’s recommended books, now I'm stuck in physics and cosmology. :blink: The book I'm reading now is The Fabric of the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2012 at 12:46 pm

    #1431370

Viewing 15 posts - 21,151 through 21,165 (of 49,552 total)