Forum Replies Created

Viewing 15 posts - 14,971 through 14,985 (of 49,552 total)

  • RE: Performance issue due to high memory usage

    SQLCrazyCertified (1/4/2013)

    You mentioned that SQL using all of it's memory which is allocated to it is a normal behavior, if this is true, when does the SQL release the memory?

    When...

    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 5, 2013 at 1:46 am

    #1574025

  • RE: Dynamic SQL - which would you use?

    CELKO (1/4/2013)

    3) Why would you have a design so bad that you need dynamic SQL? Are data element names changing at run time? Is the name of the procedure “No_Idea_What_I_Am...

    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 4, 2013 at 3:35 pm

    #1573984

  • RE: is there such a thing as a primary key alias

    rightfield (1/4/2013)

    I am trying to write a generic trigger that I can add to tables in my database (if they follow the rule of having a primary key as column...

    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 4, 2013 at 2:37 pm

    #1573968

  • RE: Shrink database

    lsalih (1/4/2013)

    you mentioned that by just rebuilding the indexes, that should help...

    I never said, suggested or implied that index rebuild would shrink a database file. I said that index rebuilds...

    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 4, 2013 at 2:30 pm

    #1573963

  • RE: shrinking multiple datafiles

    Better, no. Easier, yes.

    Shrinkdatabase gives you no control over the free space left in each file, just in the DB as a whole, plus it shrinks the log file...

    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 4, 2013 at 2:29 pm

    #1573962

  • RE: shrinking multiple datafiles

    DBCC ShrinkFile on each file. Once you've done that, rebuild all indexes. Don't shrink as small as possible, leave some free space in the files

    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 4, 2013 at 1:56 pm

    #1573947

  • RE: New in this world.. no experience and no knowledge

    You can. The cert's aimed at people with 2-3 years of experience though.

    I'd start by asking your boss what resources he's willing to provide for you to learn SQL, since...

    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 4, 2013 at 9:26 am

    #1573819

  • RE: Performance issue due to high memory usage

    It could be anything. Shotgun tuning however won't help.

    Chapter 1: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Identify the problem, then consider what the potential solution is.

    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 4, 2013 at 9:24 am

    #1573817

  • RE: Dynamic SQL - which would you use?

    wolfkillj (1/4/2013)

    IIRC, SQL Server can auto-parameterize a dynamic T-SQL query and cache the execution plan like any other.

    It'll always cache the plan, parameterised or not. Only very simple queries (no...

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

    #1573760

  • RE: Shrink database

    Terrie (1/4/2013)

    So a shrink with no_truncate would improve performance?

    No.

    No, a shrink (even a 'properly performed' one) will not improve SQL performance. The index rebuild and stats update they recommend 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

    January 4, 2013 at 6:54 am

    #1573730

  • RE: Speed up a database shrink

    Please post new questions in a new thread. Thanks

    LOB data makes shrinks very slow, as does heaps. Shrink in smaller chunks, not all at once.

    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 4, 2013 at 5:58 am

    #1573708

  • RE: Difference between Data Fragmentation & Index Fragmentation

    Shadab Shah (1/4/2013)

    Now what about the column other than the clustered index. They too might have fragmentation. Does this means Table Fragmentation.

    No. Fragmentation is something that indexes have, not tables.

    Fragmentation...

    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 4, 2013 at 5:21 am

    #1573700

  • RE: Logical consistency error

    devanandiiway (1/4/2013)

    Do you mean that I need to move all the mdf from that drive?

    Unless you are happy that the databases on there may potentially become corrupted, yes. That's like...

    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 4, 2013 at 5:12 am

    #1573696

  • RE: Performance issue due to high memory usage

    SQLCrazyCertified (1/3/2013)

    We have some performance issue..SQL server is running very slow due to high memory usage.

    Are you sure that high memory usage is causing SQL to run slow? Cause, not...

    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 4, 2013 at 2:24 am

    #1573645

  • RE: awe_allocated_kb in SQL 2012

    Ramdas Baghel (1/3/2013)

    Now SQL 2012 any memory allocation will be allocated by single_memory_allocation (there is no MultipageAllocation). So if I enabled LPIM, how SQL server know from where he should...

    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 4, 2013 at 2:20 am

    #1573643

Viewing 15 posts - 14,971 through 14,985 (of 49,552 total)