Forum Replies Created

Viewing 15 posts - 27,241 through 27,255 (of 49,552 total)

  • RE: Statistics for temp table

    Ninja's_RGR'us (3/21/2011)

    we need the actual .sqlplan file!

    and the table definitions, query and any index definitions 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

    March 21, 2011 at 7:08 am

    #1301267

  • RE: Statistics for temp table

    sqlchanakya (3/21/2011)

    1. Temp table has 5000 records. It shows no clumn stats in operator. (only for fetching from this table it shows parallelism) and followed by the below

    2. The execution...

    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

    March 21, 2011 at 6:58 am

    #1301258

  • RE: How do you use your iPad?

    Grant Fritchey (3/21/2011)

    I''m going to try using the WordPress app again soon. There have been a couple of updates since my last horrific experience.

    Download BlogPress. Works very well. Some minor...

    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

    March 21, 2011 at 6:34 am

    #1301233

  • RE: Insert random numbers into a column

    Rao.V (3/21/2011)

    you also can use option called "SEQUENCE" for that column so that it generates number automatically when u insert a new row

    Do you mean Identity (which has already been...

    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

    March 21, 2011 at 6:20 am

    #1301223

  • RE: Database in "suspect" mode (SQL Server Management Studio 2005)

    Rao.V (3/21/2011)

    why don't you try to attach the DB only using the data file ".mdf" while trying this it asks for creation of new logfile you can select YES 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

    March 21, 2011 at 6:18 am

    #1301222

  • RE: Statistics for temp table

    Ninja's_RGR'us (3/21/2011)

    Grant Fritchey (3/21/2011)

    If you're getting an index scan, you should try to understand why. Is there something in the code, such as a function on the column, that 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

    March 21, 2011 at 6:14 am

    #1301219

  • RE: IN Clause in SQL Query

    SQL is validating it. The column there is perfectly valid because it's a column from the outer query. Any subquery can reference any column of any table defined in 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

    March 21, 2011 at 3:37 am

    #1301159

  • RE: Statistics for temp table

    Yes, you can create stats manually, though an index should already have statistics on 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

    March 21, 2011 at 3:29 am

    #1301156

  • RE: CPU usage 98 %

    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/

    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

    March 21, 2011 at 2:00 am

    #1301135

  • RE: dump backup for backward compatibility

    The command can still be used (in some versions), it does exactly what backup database does, nothing more.

    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

    March 21, 2011 at 1:59 am

    #1301134

  • RE: distribution db became suspect while replication

    Image IT (3/20/2011)

    Which I/O subsystems you mean?

    The one that the suspect database is stored on.

    Can it be because of the replication configuration?

    Highly unlikely.

    Suspect means SQL encountered data or...

    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

    March 20, 2011 at 3:50 pm

    #1301083

  • RE: distribution db became suspect while replication

    Look in the SQL error log. There will be messages detailing why SQL marked the DB suspect.

    Most common - data corruption caused by IO subsystem problems.

    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

    March 20, 2011 at 3:28 pm

    #1301081

  • RE: 1 quad core processor enough for enterprise 2008?

    Forget TDE, IIS should not share with SQL. Security reasons are the main ones, performance can be handled by throwing more hardware.

    Without testing and benchmarking, there's really nothing useful 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

    March 20, 2011 at 3:22 pm

    #1301080

  • RE: 1 quad core processor enough for enterprise 2008?

    Honestly, there's no way for us to tell, it depends completely on the workload. I've seen servers that ran fine on a single dual-core, I've seen servers stressed and struggling...

    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

    March 20, 2011 at 3:01 pm

    #1301077

  • RE: efficiency of query approaches

    johnsql-193053 (3/20/2011)

    GilaMonster (3/20/2011)

    What does your testing show? Have you looked at the execution plans, duration and IO statistics of each?

    The 4 queries return the same result like:

    SKUGroupIDSKUMain

    S20003120003S200031

    M20003220003S200031

    T20003320003S200031

    A10092110092A100921

    B10092210092A100921

    G30005130005G300051

    Yes, they will.

    You...

    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

    March 20, 2011 at 2:57 pm

    #1301076

Viewing 15 posts - 27,241 through 27,255 (of 49,552 total)