Forum Replies Created

Viewing 15 posts - 9,991 through 10,005 (of 49,552 total)

  • RE: Backups failing - SQL Server 2008 R2

    Phil4860 (2/18/2014)

    It had changed itself to Restricted File Growth (MB) 2,097,152.

    I changed this again to Unrestricted and it resets itself to the Restricted File Growth (MB) settings above.

    That's normal, That's...

    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

    February 18, 2014 at 4:13 am

    #1689805

  • RE: Are the posted questions getting worse?

    rodjkidd (2/18/2014)

    Also SQLbits "Is very close" to being announced. Apparently some last minute hitches - all very Prophet Zarquon! Again no idea what that really means though. Simon was just...

    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

    February 18, 2014 at 4:12 am

    #1689803

  • RE: SQL for adding flags depending on criteria

    Client tool is irrelevant, we need to know what version of the database engine you are using to suggest code that has a hope in hell of doing what you...

    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

    February 17, 2014 at 9:16 am

    #1689581

  • RE: SQL for adding flags depending on criteria

    What version of SQL Server are you using?

    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

    February 17, 2014 at 8:19 am

    #1689540

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (2/17/2014)

    Cody K (2/17/2014)

    GilaMonster (2/17/2014)

    A little. As questions go, that's a relatively decent one.

    "the file is there. I tried with extensions also like sample.csv and all but no luck....

    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

    February 17, 2014 at 8:17 am

    #1689539

  • RE: SQL Training

    Luis Cazares (2/17/2014)

    You could also invest and buy a book as many people like to do. I haven't bought one for T-SQL, so I'm not sure which one I could...

    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

    February 17, 2014 at 8:14 am

    #1689537

  • RE: Apply Unique constraints on existing database

    Yes.

    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

    February 17, 2014 at 7:13 am

    #1689504

  • RE: Are the posted questions getting worse?

    Cody K (2/17/2014)

    GilaMonster (2/17/2014)

    Can anyone pick this one up please?

    I'm glad we're not allowed guns in Australia. Or am I going overboard?

    A little. As questions go, that's a relatively decent...

    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

    February 17, 2014 at 7:13 am

    #1689503

  • RE: Reg - Log table data

    Duplicate. No replies to this please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1542092-391-1.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

    February 17, 2014 at 6:58 am

    #1689490

  • RE: Apply Unique constraints on existing database

    With a hell of a lot of difficulty (and a computed column). The filtered index is 2008 and above, which since this was posted in the SQL 2008 forum we...

    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

    February 17, 2014 at 6:55 am

    #1689487

  • RE: Are the posted questions getting worse?

    Can anyone pick this one up please? http://www.sqlservercentral.com/Forums/FindPost1542024.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

    February 17, 2014 at 6:51 am

    #1689485

  • RE: Are the posted questions getting worse?

    Cody K (2/17/2014)

    Most stuff gets passed over without anyone even seeing it.

    Probably not. I think most of the regular posters just use the Recent Posts menu and ignore the forums...

    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

    February 17, 2014 at 6:49 am

    #1689484

  • RE: cannot bulk load

    That could be part of the problem.

    First, have you logged on to the server and checked exactly what that file's name and extension 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

    February 17, 2014 at 4:07 am

    #1689437

  • RE: cannot bulk load

    Not asking about the login you are using to SQL Server. Asking about the account that SQL Server runs under.

    The file name you're specifying has no extension. Go to that...

    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

    February 17, 2014 at 3:48 am

    #1689431

  • RE: SQL for adding flags depending on criteria

    What error?

    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

    February 17, 2014 at 3:22 am

    #1689427

Viewing 15 posts - 9,991 through 10,005 (of 49,552 total)