Forum Replies Created

Viewing 15 posts - 3,826 through 3,840 (of 49,552 total)

  • RE: Tempdb configuration best practices

    Hugo Kornelis (1/18/2016)

    For recoverability, I do recommend strongly against combining data file and transaction log for the same database on the same (physical) disk. If a disk is lost and...

    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 18, 2016 at 6:15 am

    #1852493

  • RE: which one is better, Char and More Pages Or Varchar and High Fragmentation ?

    Pick the correct data type for the data, have a FillFactor that's not 100%, and make sure that you don't have the coding pattern of inserting 'empty' rows and then...

    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 18, 2016 at 2:47 am

    #1852459

  • RE: locking down schema from users

    No.

    A sysadmin has all rights within an instance and cannot be stopped from doing anything they want. If you want to restrict access, host the DB yourself and give out...

    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 18, 2016 at 2:13 am

    #1852454

  • RE: Auto Increment INT, overflow or limit exceeds - possible??

    I had that question in a class I was teaching last week. Even with an Integer, you can insert 1 row a second, every second, for 81 years before you'll...

    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 16, 2016 at 10:05 am

    #1852384

  • RE: Permission Error when enable DDL Trigger (Database Level)

    Here it is, was easy enough to find from google with the title.

    https://msdn.microsoft.com/en-us/library/bb283630.aspx

    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 16, 2016 at 3:33 am

    #1852360

  • RE: What Maintenance task am I missing?

    You don't need to update statistics. A freshly built index will have up to date stats already.

    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 15, 2016 at 4:16 am

    #1852206

  • RE: change dinamically value of parameters inside stored procedure

    Changing parameter values within a procedure is a really bad idea.

    https://www.simple-talk.com/content/article.aspx?article=2280

    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 15, 2016 at 3:05 am

    #1852191

  • RE: Clustered and NonClustered Index

    deroby (1/15/2016)

    So, in a way this means there is no such a thing as a non-unique index then? =)

    http://sqlinthewild.co.za/index.php/2009/02/09/all-indexes-are-unique/

    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 15, 2016 at 2:15 am

    #1852179

  • RE: Insert a suffix to the values

    guy 1966 (1/14/2016)

    If a need to remove the '.gif' for all the field on the table....

    I already answered that

    GilaMonster (1/14/2016)

    find whatever MySQL function lets you take substrings and 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 15, 2016 at 12:49 am

    #1852167

  • RE: Result set should return all values inspite of a "Where clause"

    sqlnewbie17 (1/14/2016)

    Ex:Col A ,col B,col C,col D,col E,col F,col G....... col J

    Col A > 10

    Col B > 100

    col C < 20

    CASE WHEN <Condition 1> AND <Condition 2> AND <Condition 3>......

    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 15, 2016 at 12:48 am

    #1852166

  • RE: A weird thing with DBCC CHECKDB

    Go into the maintenance plan/job and enable detailed logging. All you're showing are high level messages and none say anything useful.

    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 15, 2016 at 12:45 am

    #1852165

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/14/2016)

    GilaMonster (1/14/2016)

    Alvin Ramard (1/14/2016)

    GilaMonster (1/14/2016)

    He's asking MySQL questions on a SQL Server site and appears to be about at the level of spelling 'SQL'. I won't be surprised if...

    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 15, 2016 at 12:44 am

    #1852164

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/14/2016)

    GilaMonster (1/14/2016)

    He's asking MySQL questions on a SQL Server site and appears to be about at the level of spelling 'SQL'. I won't be surprised if he asks...

    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 14, 2016 at 2:38 pm

    #1852102

  • RE: Are the posted questions getting worse?

    He's asking MySQL questions on a SQL Server site and appears to be about at the level of spelling 'SQL'. I won't be surprised if he asks "What's a backup?"

    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 14, 2016 at 2:31 pm

    #1852095

  • RE: Insert a suffix to the values

    Restore a backup you took before the update.

    Or, find whatever MySQL function lets you take substrings and use that to remove the last 4 characters.

    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 14, 2016 at 2:14 pm

    #1852087

Viewing 15 posts - 3,826 through 3,840 (of 49,552 total)