Forum Replies Created

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

  • RE: Initial snapshot for publication is not yet available

    Mohsin Patel (10/27/2008)

    Does this have something to do with replication deciding that the subscription needs to be reinitialised?

    If the subscription gets reinitialised, a new snapshot must be generated. 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

    October 27, 2008 at 11:38 am

    #890153

  • RE: group by

    Try something like this

    SELECT ref, design, armazem, SUM(CASE origem WHEN 'BO' THEN qtt WHEN 'FT' THEN -1*qtt ELSE 0 END) AS sumqtt

    FROM SL

    GROUP BY ref, design, armazem

    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

    October 27, 2008 at 11:27 am

    #890143

  • RE: Why we need to use UPDATE STATISTICS ?

    Lowell (10/27/2008)

    Second, I seem to remember the auto update of the statistics is based on a percentage of changes, i believe, say it's 1 percent of the sample size,

    20%...

    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

    October 27, 2008 at 11:17 am

    #890134

  • RE: Question on SQL2000 to SQL2005 imports

    If you used the import/export wizard, it will just bring the data across and create tables based on that data. No keys, no constraints, no indexes, no defaults, etc

    For 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

    October 27, 2008 at 11:02 am

    #890122

  • RE: Strange situation

    And a SELECT count(*) FROM tbDataList returns 0?

    Is it possible that there are two tables named tbDataList in different schemas?

    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

    October 27, 2008 at 10:58 am

    #890120

  • RE: Case Statement in Where clause

    Can you post table definition (as a create statement), some sample data (as insert statements) and your desired results 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

    October 27, 2008 at 10:54 am

    #890117

  • RE: Strange situation

    Can you post table structure, query and Statistics IO output for running the query? (SET STATISTICS IO ON)

    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

    October 27, 2008 at 10:40 am

    #890108

  • RE: Barriers to Entry, Database Weekly (Oct 27 2008)

    Dan Guzman (10/27/2008)

    And maybe post 5 questions per month for registered users (un limited responses to your own questions) and maybe 5 or 10 respones to other users questions....

    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

    October 27, 2008 at 10:35 am

    #890104

  • RE: Locks held by a deleted log-in

    todd_dawson (10/27/2008)

    I have users trying to run queries, their program is telling them that a user has some rows locked, but the user hasn't been in the system for months....

    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

    October 27, 2008 at 9:48 am

    #890071

  • RE: Log file full

    Great. Now make sure that you have regular log backups scheduled so that this doesn't happen again.

    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

    October 27, 2008 at 9:16 am

    #890051

  • RE: SQL-Server 2005: Change Ordinal Column Position

    baumgaertner (10/27/2008)

    I need a standard approch for "Change Ordinal Column Position" that works on every table independant from PK's, FK's.

    Why? What are you trying to achieve here?

    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

    October 27, 2008 at 9:14 am

    #890049

  • RE: T-SQL Code Optimizers

    rchantler (10/27/2008)

    The optimized view uses specific join algorithms, e.g. loop joins, hash join and merge joins instead of the more generic inner and outer joins used in the original view...

    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

    October 27, 2008 at 8:40 am

    #890024

  • RE: how to remove unwanted columns - easy task - quick points for you

    Chris Morton (10/22/2008)

    How Do I put the result of

    EXECUTE

    ( 'SELECT count(' + @columnname...

    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

    October 27, 2008 at 8:17 am

    #890009

  • RE: Best practice for creating a mask?

    Duplicate post. Please direct replies to http://www.sqlservercentral.com/Forums/Topic592120-373-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

    October 27, 2008 at 8:13 am

    #890005

  • RE: Deadlock exception while using SqlBulkCopy.WriteToServer(DataReader) method

    Jonathan Kehayias (10/27/2008)

    I'll have to go back and look at why I would have been using that flag, and I will definately update the references that I provide...

    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

    October 27, 2008 at 8:01 am

    #889996

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