Forum Replies Created

Viewing 15 posts - 8,236 through 8,250 (of 49,552 total)

  • RE: Research on possibility of RDBMS to have performance benchmarks like no-sql Databases

    ratneshsinghparihar-1130833 (8/6/2014)

    but you can visualize a OLTP completely on MainMemory and other non oltp issues on Datawarehouse (columnar ) then all transaction will be very small and all...

    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

    August 6, 2014 at 3:29 am

    #1735537

  • RE: Same database on multiple cluster nodes for performance?

    No, it is not.

    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

    August 6, 2014 at 3:27 am

    #1735534

  • RE: Corruption from backup/restore but original db check db is fine

    Markus (8/5/2014)

    I backed up a production database from Data Center A, backed it up across the network and restored it to a SQL Server in Data Center B which 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

    August 6, 2014 at 12:06 am

    #1735491

  • RE: normalization estate exercise

    No, you can't have parts of a table in one form and parts in another. Either the table is 3rd normal form or it isn't. You can't say that it's...

    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

    August 5, 2014 at 11:45 pm

    #1735487

  • RE: Optimal settings for DBCC checks

    Grant Fritchey (8/5/2014)

    GilaMonster (8/5/2014)

    Grant Fritchey (8/5/2014)

    sqldriver (8/5/2014)

    Grant Fritchey (8/5/2014)

    Wait a sec, if you're offloading DBCC checks, the one check you can't offload is PHYSICAL_ONLY. That one check must still be...

    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

    August 5, 2014 at 11:43 pm

    #1735485

  • RE: SQL DBA high ended question (5+ years’ experience)

    Luis Cazares (8/5/2014)

    Koen Verbeeck (8/5/2014)

    Grant Fritchey (8/5/2014)

    You get a phone call. The person on the phone says the database is slow. What do you do?

    Migrate from Oracle to SQL Server?...

    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

    August 5, 2014 at 3:36 pm

    #1735411

  • RE: normalization estate exercise

    pietlinden (8/5/2014)

    How can you get to 3NF if you don't go through 1NF and 2NF first?

    You can't. The definition of 3rd normal form goes "To be in 3rd normal...

    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

    August 5, 2014 at 3:36 pm

    #1735410

  • RE: Performance tuning

    Jason Selburg (8/5/2014)

    My first suggestions is to move the #deleteKeys table to the linked server, add a bit column to hold the "CAST(ZipCode)<9999" result. Then run the delete ON 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

    August 5, 2014 at 3:33 pm

    #1735408

  • RE: normalization estate exercise

    You can mail it to me, I'll just delete it. I am not doing your homework for you. I don't need the practice, I don't need the qualification.

    To do 3rd...

    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

    August 5, 2014 at 3:10 pm

    #1735394

  • RE: Reverse Engineer SQL Table

    The one you say is for procedures is actually for procedures, functions and views, but you will get false positives.

    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

    August 5, 2014 at 3:06 pm

    #1735391

  • RE: normalization estate exercise

    Homework?

    What have you got so far and where exactly are you stuck?

    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

    August 5, 2014 at 2:27 pm

    #1735376

  • RE: GREEK

    erika 99577 (8/5/2014)

    Im keep getting the error message below and was told i that:

    "The history pointers must have been corrupted during one of the failed imports. Basically you 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

    August 5, 2014 at 2:17 pm

    #1735373

  • RE: Reverse Engineer SQL Table

    To be blunt, that's a lot of manual work you're going to have to do there. There's no magic spell that will figure it out.

    The SQL Search tool previously mentioned...

    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

    August 5, 2014 at 2:16 pm

    #1735372

  • RE: Covering Index vs Included Columns

    Please note: 6 year old thread.

    Edit:

    Theoretically Covering Index & Included Columns are same.

    No. Definitely not.

    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

    August 5, 2014 at 11:07 am

    #1735325

  • RE: Optimal settings for DBCC checks

    Grant Fritchey (8/5/2014)

    sqldriver (8/5/2014)

    Grant Fritchey (8/5/2014)

    Wait a sec, if you're offloading DBCC checks, the one check you can't offload is PHYSICAL_ONLY. That one check must still be run on 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

    August 5, 2014 at 11:03 am

    #1735321

Viewing 15 posts - 8,236 through 8,250 (of 49,552 total)