Forum Replies Created

Viewing 15 posts - 26,626 through 26,640 (of 49,552 total)

  • RE: UPDATING QUERY VERY SLOW IN SQL SERVER 2005

    Have you checked for blocking?

    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

    April 19, 2011 at 1:51 am

    #1313202

  • RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

    Please note: 2 year old thread.

    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

    April 19, 2011 at 1:48 am

    #1313198

  • RE: Missing DSN Name in ODBC Connection on Server for SSRS Report

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1095408-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

    April 18, 2011 at 11:38 pm

    #1313176

  • RE: 2 Sessions im considering for PASS

    Craig Farrell (4/18/2011)

    Not sure, honestly, but how many people do you expect to attend PASS that don't know how to remove cursors for speed?

    There will be some, the problem I...

    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

    April 18, 2011 at 3:53 pm

    #1313119

  • RE: Restore transaction log backups on an hourly basis leaving database operational

    Transactional. Snapshot if it's a small DB, some or many tables have no pk and yesterday's data is good enough.

    Merge is for 2-way replication, it's an absolute nightmare to admin...

    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

    April 18, 2011 at 2:26 pm

    #1313081

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/18/2011)

    GilaMonster (4/18/2011)

    CirquedeSQLeil (4/18/2011)

    GilaMonster (4/18/2011)

    London's calling....

    http://bit.ly/gTGBr8

    (and my bank account is crying)

    That would be a nice trip.

    Yup. Booked flights so that I get 4 and a bit days at leisure...

    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

    April 18, 2011 at 2:02 pm

    #1313069

  • RE: Restore transaction log backups on an hourly basis leaving database operational

    There's no way to restore logs, leave the DB operational but still be able to restore more logs. Standby is normally used for read-only access, but as you noticed 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

    April 18, 2011 at 1:46 pm

    #1313056

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/18/2011)

    GilaMonster (4/18/2011)

    London's calling....

    http://bit.ly/gTGBr8

    (and my bank account is crying)

    That would be a nice trip.

    Yup. Booked flights so that I get 4 and a bit days at leisure in the UK...

    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

    April 18, 2011 at 1:43 pm

    #1313052

  • RE: Are the posted questions getting worse?

    London's calling....

    http://bit.ly/gTGBr8

    (and my bank account is crying)

    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

    April 18, 2011 at 1:11 pm

    #1313036

  • RE: Maintenance plan for large databases, how many times?

    There are few general rules in SQL unfortunately.

    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

    April 18, 2011 at 1:10 pm

    #1313035

  • RE: How to find a temporary table in tempdb?

    SQL Guy 1 (4/18/2011)

    I also have to select top 5 largest tables there. But the only problem in my case is that I cannot see local temp tables, 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

    April 18, 2011 at 11:56 am

    #1312995

  • RE: Upgrading 2000 to 2005 - Questions Emerged After Successful Tests

    Geoffrey Wrigg (4/12/2011)

    Follow-up questions to #2: Is there any way to forestall ending up with the database in recovery and/or speed up the process? Or is it just a matter...

    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

    April 18, 2011 at 9:31 am

    #1312894

  • RE: Invalid Column Name error

    Edit->Intellisense->Refresh Local cache

    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

    April 18, 2011 at 9:29 am

    #1312891

  • RE: Decimal with Leading Zero

    Numeric(x, y)

    x indicates the total number of digits that can be stored

    y indicates the number of digits on the right of the decimal place

    So Numeric(5,2) has the form 999.99 (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

    April 18, 2011 at 8:06 am

    #1312810

  • RE: How to find a temporary table in tempdb?

    Ninja's_RGR'us (4/18/2011)

    GilaMonster (4/16/2011)

    Yup, that's pretty much what I was thinking about.

    Just one comment, if the session_id>50 is supposed to filter out system processes, remove it as it won't necessarily do...

    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

    April 18, 2011 at 8:04 am

    #1312809

Viewing 15 posts - 26,626 through 26,640 (of 49,552 total)