Forum Replies Created

Viewing 15 posts - 10,456 through 10,470 (of 49,552 total)

  • RE: Newbie Question On How to Ensure a Report DB has the most up to date/ realtime data

    Merge is for lots of sources and a destination where the destination needs the merged set of changes from all sources and those merged changes may get pushed back out...

    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 10, 2014 at 7:11 am

    #1679149

  • RE: Are the posted questions getting worse?

    BWFC (1/10/2014)

    There is a philosophical question, often kicked around our office, about what happens when two people who know everything have an argument.

    I'm sure I've seen that on gaming forums....

    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 10, 2014 at 6:55 am

    #1679140

  • RE: Are the posted questions getting worse?

    Ed Wagner (1/10/2014)

    I've met people like that. Eventually, she should figure out that if things are quieter all around her, she should lower her own volume. If she...

    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 10, 2014 at 6:03 am

    #1679122

  • RE: how to deal with growing tempdb data and log files

    Then you need to:

    Figure out what cause TempDB to grow (see Grant's post)

    Determine if what caused it to grow is normal or was is a once-off operation, a broken query...

    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 10, 2014 at 5:59 am

    #1679119

  • RE: Are the posted questions getting worse?

    Yay, a gaggle of new graduates at the office (new employees, busy with our basic training course) and one near me seems to think that higher volume makes her opinion...

    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 10, 2014 at 5:41 am

    #1679110

  • RE: sa removal

    Please note: 5 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

    January 10, 2014 at 5:39 am

    #1679109

  • RE: how to deal with growing tempdb data and log files

    Why are you trying to shrink it? Surely if the database is 95% full (there's almost no free space left), you'd be looking to grow the database (make more free...

    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 10, 2014 at 4:23 am

    #1679095

  • RE: Newbie Question On How to Ensure a Report DB has the most up to date/ realtime data

    Possible, yes. Good idea, probably not. Why re-implement your own transactional replication?

    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 10, 2014 at 4:05 am

    #1679085

  • RE: Max memory on SQL Server

    Set max server memory to a sensible value

    Chapter 4 http://www.red-gate.com/community/books/accidental-dba

    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 10, 2014 at 12:41 am

    #1679048

  • RE: SQL 2000 Database Availabily

    SELECT DATABASEPROPERTYEX .... FROM sysdatabases

    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 9, 2014 at 5:51 am

    #1678746

  • RE: DIFFERENCE BETWEEN NOLOCK VS WITH(NOLOCK) IN SQL SERVER 2008

    Why is a hint that will sooner or later result in incorrect results 'mandatory'? Do the people you're writing that query for realise that from time to time their 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

    January 9, 2014 at 4:25 am

    #1678731

  • RE: DIFFERENCE BETWEEN NOLOCK VS WITH(NOLOCK) IN SQL SERVER 2008

    The first is deprecated, the second is not, both can result in incorrect results, duplicate rows and missing rows, so neither is the best to use. Best is to write...

    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 9, 2014 at 3:57 am

    #1678726

  • RE: SQL 2000 Database Availabily

    Availability, yes, you'll need to decode the status and status2 columns in sysdatabases. Should be info in Books Online. As for when the status last changed, not unless you're tracking...

    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 9, 2014 at 2:43 am

    #1678709

  • RE: Log space

    karthik babu (1/8/2014)

    Those DBs aren't offline.

    No, but they're shut down. That's what 'is_cleanly_shutdown' means, the database is closed, not in use. Probably they have auto_close enabled.

    It's not a mystery,...

    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 9, 2014 at 2:00 am

    #1678696

  • RE: Problem with a database snapshot script

    You can't use variables for file names. You need to build up the command as a string and execute it - dynamic SQL.

    This is not allowed

    NAME= [@DBName],

    FILENAME= [@Filename]

    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

    January 9, 2014 at 1:53 am

    #1678694

Viewing 15 posts - 10,456 through 10,470 (of 49,552 total)