Forum Replies Created

Viewing 15 posts - 11,581 through 11,595 (of 49,552 total)

  • RE: Need to shut down sql instances with out disturbing other instances...

    Go into SQL configuration manager, right click that SQL service and select Stop.

    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

    September 25, 2013 at 4:57 am

    #1653061

  • RE: Create an Alert for ROW Size increase

    stevewes (9/23/2013)

    our Help desk ticketing application gets lots of email request into a particular table and seem to break when it gets to 100 !! so it's so we can...

    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

    September 25, 2013 at 4:53 am

    #1653059

  • RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

    Koen Verbeeck (9/25/2013)

    Sure.

    SELECT 'Nothing' FROM myTable;

    Et voila, the row still has the value A.

    I can simplify 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

    September 25, 2013 at 2:09 am

    #1653000

  • RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

    dastagiri16 (9/25/2013)

    hi,

    any single statement to complete this task

    Um...

    GilaMonster (9/25/2013)

    You can't do it in one statement, because updating a column to one value and then updating it to another require two...

    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

    September 25, 2013 at 2:08 am

    #1652998

  • RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

    So update it, then update it back?

    Update MyTable

    SET City = 'B'

    WHERE City = 'A';

    Update MyTable

    SET City = 'A'

    WHERE City = 'B';

    You can't do it in one statement, because updating a...

    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

    September 25, 2013 at 1:53 am

    #1652991

  • RE: How to search?

    enriquezreyjoseph (9/24/2013)

    But some post say that..Dynamic Sql is a powerful tool...

    Indeed, but you don't use a jackhammer to put a nail in the wall. Powerful tool != use all 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

    September 25, 2013 at 1:45 am

    #1652984

  • RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

    Koen's query will work because SQL does updates in two phases, first where it reads the data second where it changes.

    If it's not doing what you want, please post actual...

    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

    September 25, 2013 at 1:38 am

    #1652982

  • RE: Tempdb data file fills up very often

    Why are you altering model? If you're adding files to TempDB, add the files to TempDB, don't mess with model.

    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

    September 25, 2013 at 1:27 am

    #1652975

  • RE: Max Memory

    You've got the queries from profiler, so that should be enough to get started. If you're still having something outside of SQL allocating memory and forcing SQL to reduce its...

    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

    September 25, 2013 at 1:26 am

    #1652974

  • RE: Max Memory

    You can't.

    Have you found and fixed whatever was allocating memory and forcing SQL to reduce its memory 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

    September 24, 2013 at 5:38 pm

    #1652925

  • RE: Virtual memory

    http://channel9.msdn.com/Events/Speakers/Mark-Russinovich The two Mysteries of Memory Management.

    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

    September 24, 2013 at 3:51 pm

    #1652911

  • RE: Virtual memory

    No.

    Virtual address space is 2GB on 32 bit, many hundreds of TB on 64 bit. Commitable virtual memory is physical memory + page file size.

    It's complex, there's a couple 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

    September 24, 2013 at 2:15 pm

    #1652885

  • RE: Data Corrupt for BLOB objects

    That's not database corruption (you'd get errors from SQL if it was, not adobe)

    Without seeing how you're importing, make sure that nothing's getting truncated anywhere or converted to incorrect data...

    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

    September 24, 2013 at 12:57 pm

    #1652871

  • RE: Data Corrupt for BLOB objects

    How do you know they're corrupt?

    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

    September 24, 2013 at 12:26 pm

    #1652859

  • RE: max server memory configuration

    dan-572483 (9/24/2013)

    On a related note (similar software versions but the opposite range of RAM)

    Windows Server 2003

    SQL Server 2005

    1GB Ram

    How to best divide the 1GB of RAM between the OS and...

    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

    September 24, 2013 at 12:20 pm

    #1652858

Viewing 15 posts - 11,581 through 11,595 (of 49,552 total)