Forum Replies Created

Viewing 15 posts - 136 through 150 (of 5,678 total)

  • RE: Troubleshooting\Tuning sql query taking more than 40 secs

    GilaMonster (8/9/2014)

    Remember the optimiser is NEVER looking for the best plan, it's looking for a good plan fast. In one case if found a good plan that was actually crap,...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 9, 2014 at 2:54 pm

    #1736635

  • RE: Troubleshooting\Tuning sql query taking more than 40 secs

    GilaMonster (8/9/2014)

    faisalfarouqi (8/9/2014)

    I would also request that if some suggestions around refactoring or maybe reordering of joins could be made to retrieve data quickly.

    Reordering of joins won't do a thing,...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 9, 2014 at 2:01 pm

    #1736630

  • RE: Ugh. SSIS Connection Manager Woes!

    Wait, when you say proxy, what exactly do you mean? Do you mean they setup a proxy on the server like in the node below?

    If so, you set that...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 5:20 pm

    #1736574

  • RE: db owner

    It depends on your security expectations. Typically, a login from an application doesn't have read/write, they ONLY have execute permissions to procedures, and inherit what they need from the...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 3:31 pm

    #1736560

  • RE: Titles Matter

    Regarding the Article, a thought provoking editorial, thanks for writing it.

    jboc (8/8/2014)

    You must be truthful on your resume but you can define yourself.

    Omission is always allowed (and legal) on a...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 2:52 pm

    #1736553

  • RE: How to Create a Corrupt SQL Server Database

    Nice article Perry. Simple and effective techniques. Thank you.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 2:37 pm

    #1736551

  • RE: Create Clustered Index on a Very Large Table (500 GB)

    TheSQLGuru (8/8/2014)

    Evil Kraig F (8/8/2014)

    TheSQLGuru (8/7/2014)

    I think this is slightly mis-stated Jeff. While you may not get fragmentation from end-of-index inserts, you certainly can get page LATCH contention, which...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 2:35 pm

    #1736550

  • RE: Create Clustered Index on a Very Large Table (500 GB)

    TheSQLGuru (8/7/2014)

    I think this is slightly mis-stated Jeff. While you may not get fragmentation from end-of-index inserts, you certainly can get page LATCH contention, which can be a significant...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 1:49 pm

    #1736543

  • RE: Consecutive streak excluding weekends

    I would recommend you start with something like this:

    http://www.brianshowalter.com/calendar_tables

    Just the first one that came up on google, and it looks reasonable.

    Using a table like this you can filter, control, and...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 1:42 pm

    #1736542

  • RE: advice for questions to ask regarding new database for 3rd party application

    JeepHound (8/8/2014)

    Thanks for the flame, now I know why they call you evil:-D

    Now now, not exactly a flame. 😛 Certainly not aimed at any one of the...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 12:31 pm

    #1736526

  • RE: Ugh. SSIS Connection Manager Woes!

    autoexcrement (8/8/2014)

    If IT has set up a "Proxy Account" for me, how can I set up my SSIS package to use Windows Authentication but use that Proxy Account, instead of...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 12:23 pm

    #1736525

  • RE: Consecutive streak excluding weekends

    Currently working in finance, there's additional days you need to kick out, which are the holidays for the different markets. Assuming you're only working against NYSE, NASDAQ, and OTC,...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 12:08 pm

    #1736519

  • RE: XML Query Nodes - Sequence ID

    Vince Poirier (8/8/2014)

    The ROW_NUMBER() windowed function needs a ORDER BY clause that I can't provide.

    Does this help your concern?

    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 11:06 am

    #1736505

  • RE: Werid error in SSIS package executing proc

    Phil Parkin (8/8/2014)

    This behaviour (selecting from temp tables) changed in SSIS 2012. Rather than declaring dummy metadata in your proc, you should use the WITH RESULT SETS option when you...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 8, 2014 at 10:23 am

    #1736493

  • RE: Compare Rows in the same Table

    bpowers (8/7/2014)

    Attached is an image of our table. The LINE_CHANGE_DOC_NO is an identity column and the PO number is the primary key on the table we are tracking.

    Here I...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 7, 2014 at 6:24 pm

    #1736258

Viewing 15 posts - 136 through 150 (of 5,678 total)