Forum Replies Created

Viewing 15 posts - 6,691 through 6,705 (of 49,552 total)

  • RE: Getting an error when trying to duplicate some code off of a website. What have I done wrong?

    Doctor Who 2 (1/26/2015)

    I'm still not sure what sort of data type the @words variable is, though.

    It'll be varchar or nvarchar

    And another question. I've written UDF's before, but they were...

    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 26, 2015 at 7:47 am

    #1773107

  • RE: Are the posted questions getting worse?

    Sean Lange (1/26/2015)

    Jack Corbett (1/26/2015)

    Sean Lange (1/23/2015)

    Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines...

    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 26, 2015 at 7:12 am

    #1773093

  • RE: Getting an error when trying to duplicate some code off of a website. What have I done wrong?

    Probably both VARCHAR(8000) or VARCHAR(Max). There's no 'array' data type in SQL, there's no data type which enforces a particular combination of string contents.

    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 26, 2015 at 6:56 am

    #1773087

  • RE: Which of these indexes should be deleted?

    Phil Parkin (1/26/2015)

    sm_iransoftware (1/26/2015)

    Then what is the best way to get Unused indexes?

    A brief search suggested this[/url].

    And the last sentence of that article is really, really important.

    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 26, 2015 at 6:30 am

    #1773079

  • RE: Can I merge 2 or 3 Indexes that Missing_Index query suggested (in this way) ?

    Yes.

    Before you do so, test and ensure that the index is useful and makes an appreciable improvement in the performance of the queries that it's intended to help.

    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 26, 2015 at 6:29 am

    #1773077

  • RE: Are the posted questions getting worse?

    Gazareth (1/26/2015)

    Brandie Tarvin (1/26/2015)

    GilaMonster (1/26/2015)

    Steve Jones - SSC Editor (1/23/2015)

    Sioban Krzywicki (1/23/2015)

    GilaMonster (1/23/2015)

    I haven't got any clue for a costume. Maybe cheat, buy a green hoodie and go as Arrow...

    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 26, 2015 at 6:24 am

    #1773076

  • RE: Are the posted questions getting worse?

    ChrisM@Work (1/26/2015)

    Grant Fritchey (1/26/2015)

    ChrisM@Work (1/26/2015)

    Your wish etc etc PM me if you're sure and we'll fix it up.

    Thanks! But I've already spent the money to build the other costume. Might...

    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 26, 2015 at 6:23 am

    #1773074

  • RE: Which of these indexes should be deleted?

    No way to answer that. Maybe none of them. All of them are getting used, so unless you're very, very, very certain that there will be no performance degradation as...

    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 26, 2015 at 4:56 am

    #1773041

  • RE: The server principal 'test-login' already exists.

    Raymond van Laake (1/26/2015)

    Then I dropped the login with:

    CREATE LOGIN [test-login]

    Err... CREATE LOGIN doesn't drop logins. Mis-paste?

    Question: is it okay to delete the record in the sys.serverprinciples table? Or 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 26, 2015 at 4:33 am

    #1773032

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/26/2015)

    Well crap. Now I want to go as the Arrow. And I want the 135lb yew with some scary arrows please.

    I think you'd make a very good Arrow....

    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 26, 2015 at 2:14 am

    #1773014

  • RE: Are the posted questions getting worse?

    Sean Lange (1/23/2015)

    Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are almost 200 parameters...

    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 26, 2015 at 2:12 am

    #1773013

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/23/2015)

    Sioban Krzywicki (1/23/2015)

    GilaMonster (1/23/2015)

    I haven't got any clue for a costume. Maybe cheat, buy a green hoodie and go as Arrow (but without a bow...

    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 26, 2015 at 2:11 am

    #1773011

  • RE: login transfer in dbmirroring

    Make sure, when you create the login on the mirror, you specify the SID in the CREATE statement, otherwise it won't match the database user.

    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 26, 2015 at 1:44 am

    #1773006

  • RE: my trigger does not update datetime?

    Don't use the Edit rows window. It's a little twitchy on a good day 🙂

    If you put the trigger back as it was and use an update statement to change...

    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 26, 2015 at 1:38 am

    #1773005

  • RE: Storing a .BAK file in the Database?

    amy26 (1/23/2015)

    I basically am trying to get our backup file off production and onto our local machines to do a refresh of our dev environments. I used to have...

    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 26, 2015 at 1:28 am

    #1773003

Viewing 15 posts - 6,691 through 6,705 (of 49,552 total)