Forum Replies Created

Viewing 15 posts - 35,776 through 35,790 (of 49,552 total)

  • RE: How to disable COLLATE in a table?

    John Burgess-239089 (11/17/2009)

    I found a script on a forum that will update the collationid in syscolumns but it is a backdoor method so I will not post it here.

    I would...

    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 17, 2009 at 12:37 pm

    #1080473

  • RE: Transaction Log Shipping and Stored Procedures

    All changes to a database are logged (including schema changes). Since log shipping takes the log backups (which contain all the changes) and restores them on the secondary, all changes...

    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 17, 2009 at 12:32 pm

    #1080469

  • RE: Detach db failed

    Are they all part of the same database? The error says that you've got some files from one database, some files from a different database and you're trying to attach...

    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 17, 2009 at 12:31 pm

    #1080468

  • RE: Insert Issue with Mysql

    lovesky202005 (11/17/2009)

    So, I just thought this would be the right place to ask SQL doubts although the problem is with MySQL.

    This is a Microsoft SQL Server forum. You might get...

    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 17, 2009 at 12:28 pm

    #1080463

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/17/2009)

    ARRRRGGGGGG!!!!

    Anything in particular?

    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 17, 2009 at 12:25 pm

    #1080459

  • RE: Processor Partitioning

    Bru Medishetty (11/17/2009)

    Database partitioning is available in SQL 2005 / 2008, but it does not partition the processor workload.

    Resource Governor a new feature in SQL 2008 can give a similar...

    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 17, 2009 at 12:23 pm

    #1080457

  • RE: What is the BEST way to determine the REAL version of SQL 2000??

    subs99 (11/17/2009)

    I thought by making a really long original post with all the details I was being nice and clear or whatever.

    But it turns out by making a superJumbo-sized post...

    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 17, 2009 at 12:20 pm

    #1080455

  • RE: automatic checkpoint of transaction log

    Odd. You're absolutely sure this database is in simple recovery?

    If you run a manual checkpoint does the log usage drop?

    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 17, 2009 at 12:19 pm

    #1080454

  • RE: Stored Procedure - A better way?

    DISTINCT TOP 100? If run without distinct does it really return duplicates? If so, why are there duplicates? If not, remove that distinct, it's expensive.

    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 17, 2009 at 8:25 am

    #1080296

  • RE: Issue with Table script

    Rookee DBA (11/17/2009)

    Gentlemen, thanks alot for your comments.

    Only one gentleman here, and that's Steve.

    Do you mind sharing the circumstances in which both the index will be required?

    Don't worry about...

    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 17, 2009 at 8:24 am

    #1080294

  • RE: Processor Partitioning

    Processors can only be 'affinitised' per instance. What I would suggest is that you 'encourage' the developer to optimise his queries. Large table does not automatically mean high processor usage....

    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 17, 2009 at 8:23 am

    #1080293

  • RE: automatic checkpoint of transaction log

    DBCC SQLPERF(LogSpace)?

    Checkpoints don't run on a schedule, frequency depends on activity.

    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 17, 2009 at 8:06 am

    #1080275

  • RE: automatic checkpoint of transaction log

    Run DBCC OPENTRAN, post the results

    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 17, 2009 at 7:41 am

    #1080252

  • RE: Search Query

    Elliott W (11/17/2009)

    I got the parameter sniffing vibe off that article..

    It's not so much parameter sniffing. It's that there's no single optimal execution plan for that kind of...

    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 17, 2009 at 7:17 am

    #1080230

  • RE: Clustered Index Key vs Unique Row Identifier

    kwiggans (11/17/2009)

    Then it gives a scenario of a large table with a covering clustered index vs a 4 byte clustered index to compare the space savings.

    Clustered indexes are always...

    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 17, 2009 at 6:28 am

    #1080188

Viewing 15 posts - 35,776 through 35,790 (of 49,552 total)