Forum Replies Created

Viewing 15 posts - 28,711 through 28,725 (of 49,552 total)

  • RE: is it junk mail or virus

    Steve Jones - SSC Editor (12/30/2010)

    Was this a PM or email from the SSC system? If so, please send me the account name.

    See The Thread. Several people have received PMs...

    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

    December 30, 2010 at 11:28 am

    #1267836

  • RE: Repetitive Indexes

    Stefan Krzywicki (12/30/2010)

    PosNumber is a subset of CafeNumber and is tightly linked to it.

    I'm thinking I can just make one Index with the fields

    BusinessDate, CafeNumber, PosNumber, DField

    and be done with...

    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

    December 30, 2010 at 11:28 am

    #1267834

  • RE: report optimization

    koolme_85 (12/30/2010)

    just checked the execution plan and it seems like "clusterd index scan cost = 0%" and "table scan is 94%"

    Can you post the plan please, along with the table...

    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

    December 30, 2010 at 7:51 am

    #1267689

  • RE: Reset identity value

    What error does it give you?

    If you want a check for empty table, just add an IF @@RowCount > 0 before the CheckIdent.

    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

    December 30, 2010 at 7:01 am

    #1267664

  • RE: Count query help required

    joshtheflame (12/30/2010)

    1. If all trans_status value = 0 status would be "Incomplete'

    2. If all trans_status value = 1 status would be "Complete'

    3. if trans_Status value ha some 0's 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

    December 30, 2010 at 6:54 am

    #1267660

  • RE: Are the posted questions getting worse?

    Grant Fritchey (12/30/2010)

    Craig Farrell (12/29/2010)

    Hey guys. Blogging/articles and the like are relatively new to me, so I'd like your educated opinions on how I should look at this:

    http://balapalani.blogspot.com/2010_12_01_archive.html

    It's roughly...

    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

    December 30, 2010 at 6:39 am

    #1267650

  • RE: User details need to transfer

    If you've copied the databases over, the users will go along, they're in the DB, they're copied with the DB.

    For the logins, the link Marco provided should give you what...

    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

    December 30, 2010 at 3:18 am

    #1267593

  • RE: Difference of Rights for SA user and Other users with SA privileges

    ankur_libra (12/30/2010)

    Sometimes our clients are resisting to provide us the SA user password

    Good for them. That's exactly what they should be doing. You shouldn't even be asking for the sa...

    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

    December 30, 2010 at 3:17 am

    #1267591

  • RE: Update order of a table with a clustered index

    Langston Montgomery (12/29/2010)

    (since, as we know, the data is physically stored in the same order as the clustered index)?

    Myth, not true.

    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

    December 30, 2010 at 2:15 am

    #1267572

  • RE: Blocking in SQL Server 2008

    sporoy (12/30/2010)

    But there are no running or waiting queries, so there should be no query running at the time, problem is transactions not committing for hours, probably due to a...

    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

    December 30, 2010 at 2:05 am

    #1267568

  • RE: User details need to transfer

    There is no such thing as a database-level login.

    Logins are server-wide, stored in the master database and allow connection to the server.

    Users are stored per-database, mapped to logins and have...

    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

    December 30, 2010 at 2:03 am

    #1267567

  • RE: Are the posted questions getting worse?

    Lynn Pettis (12/29/2010)

    Didn't get permission to copy his work. Makes it plagarism even though he cited his source.

    No, makes it copyright violation.

    Plagarism is taking someone else's work and presenting...

    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

    December 30, 2010 at 2:02 am

    #1267566

  • RE: SQL Server High Avilabilty Solutions

    Have you considered one of the snapshot isolation levels?

    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

    December 29, 2010 at 2:15 pm

    #1267433

  • RE: Date error

    Oracle or SQL Server backend for the report? Your earlier post (http://www.sqlservercentral.com/Forums/Topic1040466-392-1.aspx) was for Oracle.

    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

    December 29, 2010 at 2:03 pm

    #1267427

  • RE: report optimization

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    December 29, 2010 at 1:24 pm

    #1267413

Viewing 15 posts - 28,711 through 28,725 (of 49,552 total)