Forum Replies Created

Viewing 15 posts - 19,066 through 19,080 (of 49,552 total)

  • RE: SQL Server uses almost 100% CPU

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    Also

    Chapter 3: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-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

    April 16, 2012 at 7:31 am

    #1474022

  • RE: how to enable clr in sqls 2008

    sturner (4/16/2012)

    The only other option you have on a database level is the trustworthy option. If trustworthy=OFF then CLR assemblies marked unsafe or external access will not run.

    Trustworthy doesn't remove...

    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 16, 2012 at 7:30 am

    #1474021

  • RE: how to enable clr in sqls 2008

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1284070-386-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 16, 2012 at 7:29 am

    #1474019

  • RE: Multiple files for tempdb

    9 files? That's an odd number.

    You have 9, 18, 27 or 36 (or some other multiple of 9) processor cores?

    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 16, 2012 at 7:10 am

    #1474006

  • RE: enable clr on database level

    No, that's how you enable CLR.

    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 16, 2012 at 7:08 am

    #1474005

  • RE: CAREER ADVICE: Applying for DBA Jobs?

    mtassin (4/16/2012)

    So when I see you throw out a question like this... I'd expect that you'd expect a Sr DBA to work on these sorts of things.

    No, I don't. 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

    April 16, 2012 at 6:54 am

    #1473994

  • RE: Question related to NOLOCK

    Eugene Elutin (4/16/2012)

    ... If there are no changes then there will be no locks ...

    Does not SELECT puts a Shared Lock on a table?

    I agree that placing the lock itself...

    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 16, 2012 at 4:46 am

    #1473930

  • RE: Question related to NOLOCK

    Eugene Elutin (4/16/2012)

    2. ETL to upload datawarehouse, where you know that the source tables do not experience any modifications during the load.

    3. And the most common one: reporting based...

    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 16, 2012 at 4:18 am

    #1473921

  • RE: Single role for all databases

    Execute is a database level permission, so you'll have to create database level role for it.

    Additionally, you cannot create server-level roles in SQL 2008.

    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 16, 2012 at 3:51 am

    #1473908

  • RE: Compatibility level

    Yup. Mostly. There maybe things that won't work on compat mode 90 that will on 100 because of syntax rules, but it won't be a case where all 2008 features...

    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 16, 2012 at 3:47 am

    #1473906

  • RE: Question related to NOLOCK

    It's probably worth mentioning that locking hints are not the way to solve blocking problems in a database.

    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 16, 2012 at 3:39 am

    #1473904

  • RE: lookig for professional trainers

    Spam. Reported. No replies please.

    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 16, 2012 at 3:23 am

    #1473898

  • RE: Business objects technical online , in house , corporate training

    Spam. Reported. No replies please.

    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 16, 2012 at 3:23 am

    #1473897

  • RE: lookig for professional trainers

    Spam. Reported. No replies please.

    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 16, 2012 at 3:19 am

    #1473895

  • RE: lookig for professional trainers

    Spam. Reported. No replies please.

    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 16, 2012 at 3:19 am

    #1473894

Viewing 15 posts - 19,066 through 19,080 (of 49,552 total)