Forum Replies Created

Viewing 15 posts - 38,146 through 38,160 (of 49,552 total)

  • RE: WHERE ... IN versus WHERE ... =

    Identical. In fact, if you look at the exec plan, you'll see that the plans are the same and that SQL has converted the IN into a series 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

    June 26, 2009 at 7:39 am

    #1016019

  • RE: Temp Table error

    Paul White (6/26/2009)

    #temp3 is a local temporary table - it is private to the session that created it.

    Dynamic SQL runs in a separate context, so it cannot see the private...

    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

    June 26, 2009 at 7:20 am

    #1016008

  • RE: Temp Table error

    Can you post the full code including where the temp table is created please?

    Are you sure that the column 'Car_ID' exists in that table because the error indicates that it...

    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

    June 26, 2009 at 7:16 am

    #1016002

  • RE: Confused about sys.dm_exec_query_stats results

    mazzz (6/26/2009)

    I've been vaguely planning to set up a db in which to store historical DMV data, might make a starty on that this afternoon, as there's a bit 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

    June 26, 2009 at 7:13 am

    #1015999

  • RE: help me

    Start SQL Agent?

    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

    June 26, 2009 at 6:27 am

    #1015961

  • RE: Server Crashed How best to recover?

    sureshrajan (6/26/2009)

    If you know the logical file name then create a blank database. Detach it and while attaching the DB refer the mdf and ldf file.

    Shouldn't be necessary. That's generally...

    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

    June 26, 2009 at 6:25 am

    #1015959

  • RE: ETL and other processes spike CPU 90% - need options to cluster/VMWare/more resources!

    I'd start by trying to optimise the ETL process. It's possible that there's no more that can be done, but it's unlikely.

    If that gives no joy, then spreading the work...

    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

    June 26, 2009 at 5:45 am

    #1015932

  • RE: Performance comparison of using WHILE and CURSOR

    yaya1899 (6/26/2009)

    Hi GilaMonster,

    Basically I have few tables to store system data of application, and those data maybe added/updated from time to time. Thus, I have a master script to store...

    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

    June 26, 2009 at 5:24 am

    #1015921

  • RE: Confused about sys.dm_exec_query_stats results

    mazzz (6/26/2009)

    I should have surmised this from BOL myself, actually *blush*, I don't know why that didn't make sense when I read it earlier.

    When I started playing with these...

    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

    June 26, 2009 at 5:21 am

    #1015919

  • RE: Confused about sys.dm_exec_query_stats results

    mazzz (6/26/2009)

    The "duplicate" rows returned from the DMV have the same qs.text, the same plan_handle, the same sql_handle, but different statement_start_offset and statement_end_offset. Some of these rows have the same...

    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

    June 26, 2009 at 4:55 am

    #1015910

  • RE: Performance comparison of using WHILE and CURSOR

    yaya1899 (6/26/2009)

    Recently I learned about CURSOR and I found most experts advise not to use it due to performance issue. However, I found using CURSOR is much faster than using...

    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

    June 26, 2009 at 4:53 am

    #1015908

  • RE: Which is Better

    Eswin (6/26/2009)

    Will using SELECT statement that assigns values to a variables and then using "while @@row_count 0" allow me to fetch one row at a time and perform queries...

    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

    June 26, 2009 at 3:32 am

    #1015861

  • RE: Which is Better

    Eswin (6/26/2009)

    are both same.

    can you give me some example.

    Maybe if you could explain what the innards of that cursor are supposed to do, someone can help. It's rather hard...

    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

    June 26, 2009 at 2:23 am

    #1015840

  • RE: ETL and other processes spike CPU 90% - need options to cluster/VMWare/more resources!

    Maxer (6/25/2009)

    2. Maybe bypass that and look at setting up an SQL cluster.... benefits?

    SQL clustering is purely high availability. There's no load balancing or scale-out capabilities within it.

    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

    June 26, 2009 at 1:55 am

    #1015825

  • RE: Sql Server 2008 Enterprise Evaluation Edition Expired!!

    compass2k (6/25/2009)

    Another sloppy MS gotcha was they turned IP connections off again so I had to use config manager and restart server to connect from

    sql client or application.

    Question MS -...

    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

    June 26, 2009 at 1:55 am

    #1015824

Viewing 15 posts - 38,146 through 38,160 (of 49,552 total)