Forum Replies Created

Viewing 15 posts - 3,496 through 3,510 (of 5,685 total)

  • RE: How to identify obsolete objects...

    Steve Jones - SSC Editor (4/4/2011)


    Don't forget to think about running this for a year to catch those once a year processes.

    If you think about removing anything, make sure you...

  • RE: SQL Statement Insert..

    davidfoley84 (4/4/2011)


    well just on how i get 100/day into Customer,

    I never did Index before. and from their i'll be able to figure the rest out.

    The question is not about how...

  • RE: SQL Server running incredibly slow since Friday...

    MyDoggieJessie (4/4/2011)


    Which performance object is that in? Not really sure on how to check and see if the servers swapping files...

    Swapfile: It's under memory, Hard Page Faults/sec or Page...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/4/2011)


    I like Craig's advice, but Michael's is probably where I'd start. Usually shrinkage affects inventory, so I'd compare ordering with sales and look for discrepancies....

  • RE: SQL Server running incredibly slow since Friday...

    Get someone to check the physical server and see if one of your Memory Chips bit the dust. While they're doing that...

    Get yourself a perfmon open and check for...

  • RE: SQL Statement Insert..

    davidfoley84 (4/4/2011)


    For the following tables and SQL statements, select indexes that balance retrieval and update requirements. For each table, justify your choice using the rules discussed in Section 8.5.3.

    Um, this...

  • RE: Flat File Destination Issue

    copett86 (4/4/2011)


    and it displays that for every record. I believe the Amount and Data field get populated because the data type for numeric and date is easy to define....

  • RE: Help!!!

    Ninja's_RGR'us (4/4/2011)


    I'm 99.999999999999% sure it can be done. The missing decimal is that I don't have the data in front of me. It looks like denormalized table, so...

  • RE: SQL Statement Insert..

    davidfoley84 (4/4/2011)


    Well, what i should say is that i dont know what to put into it. to allow me to add 100 a day

    :ermm: Huh? You've declared a...

  • RE: Query Performance Tuning

    Grubb (4/4/2011)


    I like what you are saying, Grant.

    I'm not familiar with the term "wait state" info. Is this something out of MSSQL, or from Perfmon or something?

    Thanks!

    SELECT * FROM...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (4/4/2011)


    That is one of the areas I'm looking for guidance. What kinds of patterns should I be looking for? I don't think they currently do detect it other...

  • RE: Help!!!

    Ninja's_RGR'us (4/1/2011)


    I'm not kidding. He's using the same base table for all 4-5 selects. I don't see why I he can't do a single scan (or big range...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (4/4/2011)


    Not just looking for unreported or under-reported sales, but also looking for extra sales of merchandise that doesn't exist or patterns of sales that are unusual, etc...

    Most of...

  • RE: DBAs on ACID

    It's not Agile itself that I personally am against, though the methodology doesn't allow for significant testing unless you've already got recursion test scripts in place and an environment that...

  • RE: How to monitor disk perfrmance o mounted disks volume

    Don't try to look at the disk stats directly, go with communication speeds. Non-dedicated spindles along with SAN cache's will mess with you.

    What you'll want to monitor is avg...

Viewing 15 posts - 3,496 through 3,510 (of 5,685 total)