Forum Replies Created

Viewing 15 posts - 34,516 through 34,530 (of 49,552 total)

  • RE: Best Overall Certification Right Now

    Jeff Moden (1/21/2010)

    Heh... wow! You can get a degree for less. :hehe:

    You can studying here, not sure about the USA. (That 7.5-to-1 exchange rate really messes things up)

    See why...

    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 22, 2010 at 2:13 am

    #1107171

  • RE: Sql server computed field

    What do you mean by 'cannot work'? Is it giving an error? Is it not giving the values you want? Something else?

    Calculated columns are not stored, they're calculated when 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

    January 22, 2010 at 2:12 am

    #1107170

  • RE: Sql server computed field

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic851782-391-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

    January 22, 2010 at 2:11 am

    #1107169

  • RE: Parameter Sniffing

    Silaphet Mounkhaty (1/21/2010)

    Also, I cloned this production database to our Test server two months ago and I had a user ran a few searches on our test box and 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

    January 22, 2010 at 2:11 am

    #1107167

  • RE: DBCC shrink file error

    Can you try shrinking in smaller chunks?

    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 22, 2010 at 2:08 am

    #1107165

  • RE: Is it possible to keep my database in RAM????

    Saravanan T (1/21/2010)

    But still i want to increase the performance.

    Then look at tuning your queries and indexes. That's usually the largest return on time spent

    Is there any way...

    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 22, 2010 at 1:52 am

    #1107155

  • RE: Parameter Sniffing

    Sounds more like stale statistics.

    Does UPDATE STATISTICS <Table Name> WITH FULLSCAN 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

    January 21, 2010 at 1:36 pm

    #1106947

  • RE: Deadlock - How to fix offending code?

    Do you have blocking or deadlocks? Are you seeing error 1205 for either process?

    If deadlocks, switch traceflag 1222 on. That will result in a deadlock graph been written to 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

    January 21, 2010 at 1:33 pm

    #1106945

  • RE: SQL2005 64-BIT Just Installed...now what?

    I've done it on my x64 desktop. Ran a simple update. Everything stopped responding, including OS. Not pretty.

    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 21, 2010 at 12:59 pm

    #1106925

  • RE: DBCC shrink file error

    Run this, post any results.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Also, don't shrink the DB to the minimum size. Leave it some space free. SQL needs some free space in...

    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 21, 2010 at 12:52 pm

    #1106921

  • RE: SQL2005 64-BIT Just Installed...now what?

    Standard edition ignores locked pages if you're below a certain patch level. SP3 + some cumulative update. Can't recall exactly which one (google is your friend here)

    Setting max memory 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 21, 2010 at 12:48 pm

    #1106918

  • RE: Objects are without statistics!!!

    JMSM (1/21/2010)

    We've got a client that detect that in one database three tables are without statistics.

    Q1: My SQL Instance its configured to automatically update statistics so why are not update...

    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 21, 2010 at 11:27 am

    #1106865

  • RE: Error trying to get transaction log shipping to work

    What are the NTFS permissions on the folder? For sharing there must be the share permission and the underlying NTFS file system permissions

    The SQL service account must have read 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

    January 21, 2010 at 10:49 am

    #1106842

  • RE: Clustered and non clustered indexes

    Most likely because it's figured that it will read fewer pages if it scans the nonclustered index. The NC index has the clustering key in it, so it can just...

    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 21, 2010 at 10:48 am

    #1106841

  • RE: Different results from left outer join and an inner join

    To reproduce that in your test example, change your insert into the first temp table as follows:

    INSERT INTO #pool_def VALUES('pool', 'subcmp1')

    INSERT INTO #pool_def VALUES('pool', 'subcmp2')

    INSERT INTO #pool_def VALUES('pool', 'LEADCMP')

    Because there...

    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 21, 2010 at 8:56 am

    #1106765

Viewing 15 posts - 34,516 through 34,530 (of 49,552 total)