Forum Replies Created

Viewing 15 posts - 601 through 615 (of 18,926 total)

  • RE: How to replace While Loop in place of Cursor

    Lynn Pettis (12/6/2011)

    MSBI Learner (12/6/2011)

    Yeah, I have sent... hope that helps you to work on my issue.

    Please let me know if you need any more information on the same.

    There are...

    December 6, 2011 at 9:14 am

    #1417457

  • RE: Expensive Query and missing indexes

    Can you upload the actual execution plan?

    Along with the current indexe(s) on that table (including keys).

    December 6, 2011 at 9:07 am

    #1417448

  • RE: Optimize hint has huge implications. Why?

    for me to see what the construct of the query's influence would be on the statistics

    Didn't you mean the reverse? The QP has absolutely nothing to do with changing...

    December 6, 2011 at 9:03 am

    #1417445

  • RE: Cannot drop SQL table

    espanolanthony (12/6/2011)

    Hi,

    I tried every possible ways but still cannot drop table.

    That's why Gail, our most expert resident on corruption, TOLD you to export everything you can save.

    If checkdb can't...

    December 6, 2011 at 8:33 am

    #1417423

  • RE: delete .ldf files

    Also worthy to note that logs are use SEQUENTIALLY. So there's no point in having more than 1 log file aside from having the main drive full and needing...

    December 6, 2011 at 7:40 am

    #1417371

  • RE: Slow Running Stored Proceudre

    eseosaoregie (12/6/2011)

    I have opted to create a summary/aggregate table that will store the aggregated fact data. Then I will run the cross tab query of that data. Any advice if...

    December 6, 2011 at 7:20 am

    #1417355

  • RE: CPU and Memory usage

    11.03 as of now.

    http://sqlblog.com/files/default.aspx

    December 6, 2011 at 7:13 am

    #1417344

  • RE: Patch SQL 2005 - SP4?

    SP4 contains all upgrades & patches prior to SP4. So no need to do 5 differents patches.

    That being said, even if the risk on low, you should still do...

    December 6, 2011 at 6:04 am

    #1417289

  • RE: Optimize hint has huge implications. Why?

    Because the table variable is so small, I figured that without the overhead of statistics or minimal disk I/O, I might gain some time. It's an interesting thought, but in...

    December 6, 2011 at 4:47 am

    #1417223

  • RE: Optimize hint has huge implications. Why?

    nico van niekerk (12/5/2011)

    bteraberry (12/5/2011)

    Ninja's_RGR'us (12/5/2011)

    There are probably 1000 myths about @t vs #t.

    The article I linked to list all the pros & cons of each.

    http://www.sqlservercentral.com/articles/Temporary+Tables/66720/

    Good article, but I would...

    December 6, 2011 at 4:36 am

    #1417210

  • RE: Optimize hint has huge implications. Why?

    Grant Fritchey (12/5/2011)

    Ninja's_RGR'us (12/5/2011)

    Grant Fritchey (12/5/2011)

    Ninja's_RGR'us (12/5/2011)

    I'm pretty sure you meant

    I'm NOT trying to fight with you,

    😀

    Ah! the joys of not being f2f :hehe:.

    Oh crap!

    I edited that. Oops. I'm...

    December 5, 2011 at 4:58 pm

    #1417076

  • RE: SQL Code Help

    Evil Kraig F (12/5/2011)

    drew.allen (12/5/2011)

    CELKO (12/5/2011)

    Your approach to SQL is fundamentally wrong.

    Your approach to SQL training is fundamentally wrong. Without specifics on what you think is fundamentally wrong, why...

    December 5, 2011 at 3:14 pm

    #1417059

  • RE: T-SQL code to perform dimension/fact updates

    Read up on not exists, or except.

    Select * FROM dbName.owner.tblname

    Come back with a more specific question when you have it.

    December 5, 2011 at 3:00 pm

    #1417056

  • RE: SQL Code Help

    drew.allen (12/5/2011)

    CELKO (12/5/2011)

    Your approach to SQL is fundamentally wrong.

    Your approach to SQL training is fundamentally wrong. Without specifics on what you think is fundamentally wrong, why you think it...

    December 5, 2011 at 2:55 pm

    #1417053

  • RE: Optimize hint has huge implications. Why?

    Grant Fritchey (12/5/2011)

    Ninja's_RGR'us (12/5/2011)

    I'm pretty sure you meant

    I'm NOT trying to fight with you,

    😀

    Ah! the joys of not being f2f :hehe:.

    Oh crap!

    I edited that. Oops. I'm sure that didn't...

    December 5, 2011 at 2:54 pm

    #1417051

Viewing 15 posts - 601 through 615 (of 18,926 total)