Forum Replies Created

Viewing 15 posts - 13,336 through 13,350 (of 49,552 total)

  • RE: SQL 2008 Express

    Post a screenshot please (save as jpg, attach to your 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

    April 25, 2013 at 10:29 am

    #1610032

  • RE: Are the posted questions getting worse?

    Does whoever has my crystal ball want to give this a try? http://www.sqlservercentral.com/Forums/Topic1446457-392-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 25, 2013 at 8:06 am

    #1609955

  • RE: Sum ??

    Need more information. At least the error message, preferably also the table definitions and some sample data. Read this to see the best way to post this to get quick...

    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 25, 2013 at 7:35 am

    #1609939

  • RE: SQL 2008 Express

    Not an error, just a warning. Click the 'run anyway' button (or whatever it says). At worst you'll need to apply a service pack after installing SQL.

    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 25, 2013 at 7:22 am

    #1609927

  • RE: queries on Logins

    You'll probably have to set up a login trigger, record when people log in into some table and use that table to determine what code to run.

    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 25, 2013 at 7:18 am

    #1609925

  • RE: how pick value from database on sql server2000?

    I have absolutely no idea what you're trying to do, what the problem is, where the data is, or anything in fact.

    Look at what you've written, would you understand 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

    April 25, 2013 at 7:10 am

    #1609923

  • RE: how pick value from database on sql server2000?

    We're going to need a little more information 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

    April 25, 2013 at 6:33 am

    #1609905

  • RE: Query is still taking same time.

    Could be anything, and without more information there's no way that anyone's going to be able to offer useful help.

    To start with, what's the wait types the query gets? What'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 25, 2013 at 6:17 am

    #1609899

  • RE: Fragmentation

    Not worth while, mostly a waste of time. Fragmentation affects large range scans, you can't have large range scan on a table with 100 pages.

    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 25, 2013 at 4:42 am

    #1609862

  • RE: Fragmentation

    m.rajesh.uk (4/25/2013)

    I found there was fragmentation in my server and i rebuild the indexes to remove fragmentation. But even after rebuilding the indexes the fragmentation is still there. How to...

    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 25, 2013 at 2:23 am

    #1609817

  • RE: Read transaction log file

    vinu512 (4/25/2013)

    One small doubt that is still bugging me is that when i see the size of the log, of the newly restored db, it still shows 17 GB.....if 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

    April 25, 2013 at 2:21 am

    #1609815

  • RE: Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log

    Paul Brewer (4/24/2013)

    WRITE_LOG operations, as a percentage of overall wait time statistics, went from 20% to 50% as a result of re-enabling SAN replication. There's a battery backed write 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 24, 2013 at 4:05 pm

    #1609745

  • RE: What is "cost"?

    A unitless number that is solely useful in comparing one plan to another. It's also estimated, so can be wrong.

    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 24, 2013 at 11:43 am

    #1609654

  • RE: possible corruption due to i/o device error

    rajeshwaran2k6 (4/24/2013)

    Failed:(-1073548784) Executing the query "BACKUP DATABASE [JLConcpetsProduction] TO DISK = ..." failed with the following error: "Read on "G:\\SQL Database JLCONCEPTS\\JLConcpetsProduction.ldf" failed: 1117(The request could not be performed...

    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 24, 2013 at 11:23 am

    #1609642

  • RE: OPtimization Skills

    Practice, practice, practice and a hell of a lot of reading.

    Start with you basic skills in writing queries. If you don't know how to write queries well, you won't be...

    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 24, 2013 at 8:55 am

    #1609558

Viewing 15 posts - 13,336 through 13,350 (of 49,552 total)