Forum Replies Created

Viewing 15 posts - 29,476 through 29,490 (of 49,552 total)

  • RE: Script runs on 2000 but not any other.

    Because the error is a parse-time error (missing columns) and occurs before any execution has even begin.

    If you want to do this you'll need dynamic SQL, because that's the only...

    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

    November 8, 2010 at 12:59 pm

    #1247848

  • RE: SQl Service licensing question

    I suggest that you have a chat with someone at Microsoft licensing on this.

    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

    November 8, 2010 at 12:06 pm

    #1247825

  • RE: Are the posted questions getting worse?

    Craig Farrell (11/8/2010)

    GilaMonster (11/8/2010)

    Does this count? http://www.sqlservercentral.com/Forums/Topic1017255-1292-1.aspx

    Been guilty of that a few times myself. Service Broker was my last occurence of that.

    I did much the same with service broker....

    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

    November 8, 2010 at 12:00 pm

    #1247823

  • RE: Are the posted questions getting worse?

    GabyYYZ (11/8/2010)

    GilaMonster (11/8/2010)

    Does this count? http://www.sqlservercentral.com/Forums/Topic1017255-1292-1.aspx

    Handled with the patience of Job...(or was that resignation).

    The latter.

    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

    November 8, 2010 at 11:50 am

    #1247819

  • RE: SQl Service licensing question

    amns (11/8/2010)

    Since it is only used one user in several computers to access the DB, can just we buy 1

    No. The end consumers of the web service are considered...

    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

    November 8, 2010 at 10:36 am

    #1247770

  • RE: Are the posted questions getting worse?

    Does this count? http://www.sqlservercentral.com/Forums/Topic1017255-1292-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

    November 8, 2010 at 9:42 am

    #1247738

  • RE: 2005 instance on 2008 Front end

    goodguy (11/8/2010)

    For what?

    I don't know, but because you wondered aloud where it would be installed.

    No I did not. I said I don't know where it will appear in 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

    November 8, 2010 at 9:40 am

    #1247736

  • RE: Errors in Updatestore proc

    Don't move it. Remove the comma before it.

    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

    November 8, 2010 at 9:37 am

    #1247733

  • RE: Errors in Updatestore proc

    And your new fixed code code looks like .... ???

    Your original code has an extra comma, right before the AS. If you haven't fixed that, remove it.

    btw, you do know...

    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

    November 8, 2010 at 9:32 am

    #1247728

  • RE: How to analyze trace file

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    November 8, 2010 at 9:32 am

    #1247727

  • RE: Errors in Updatestore proc

    remove the square brackets from around the variable names.

    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

    November 8, 2010 at 9:15 am

    #1247715

  • RE: 2005 instance on 2008 Front end

    goodguy (11/8/2010)

    But, I can dig deep inside the C:\ Program Files filesystem to check, it is not a problem.

    For what?

    So, now I can port all my databases to 2008...

    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

    November 8, 2010 at 8:05 am

    #1247673

  • RE: why is this taking ages?

    Very likely exactly the same.

    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

    November 8, 2010 at 7:58 am

    #1247669

  • RE: Database refresh date

    Depends. What do you mean by 'refresh'?

    If you mean restored from backup, George's query will work. If you mean something else, it won't.

    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

    November 8, 2010 at 7:55 am

    #1247667

  • RE: Rebulid Index is failing with error

    Free space = total size of the index, at least. Check that the file's autogrow doesn't have a set limit.

    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

    November 8, 2010 at 7:44 am

    #1247661

Viewing 15 posts - 29,476 through 29,490 (of 49,552 total)