Forum Replies Created

Viewing 15 posts - 3,181 through 3,195 (of 5,678 total)

  • RE: holy slow query batman!

    Donalith (5/18/2011)


    Ok, someone tell me there's a faster way to do this. I have a table with 37k string fields (open ended question responses) and I'm trying to extract words...


    - 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

  • RE: Asynchronous Procesing with Service Broker

    ningaraju.n (5/17/2011)


    Hi,

    we have stored procedure which process the responses from student once the student submit the test,And this stored procedure consuming time and hence hindering the concurrency.

    I wouldn't usually start...


    - 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

  • RE: Asynchronous Procesing with Service Broker

    Hey Gary, a nice lab and an excellent approach to simplifying the concepts of a messaging queue. The devil is in the details in SB, but it's still an...


    - 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

  • RE: Bad habit #2: Prod data -->> dev, test databases

    RyderD (5/17/2011)


    Eeep. I just saw how old this thread is. Zombie thread! YEAH!

    Sorry 'bout that. And thank you for having the conversation.

    Bah, no worries...


    - 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

  • RE: Bad habit #2: Prod data -->> dev, test databases

    RyderD (5/17/2011)


    And a full database restore in the middle of a development cycle wouldn't throw things off? I can't tell you how many times I've lost users, roles &...


    - 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

  • RE: Bad habit #2: Prod data -->> dev, test databases

    RyderD (5/17/2011)


    I'm not actually disagreeing that developers who are supporting production enviornments need access to a version of production data. Of course they do - there, in fact, is...


    - 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

  • RE: Bad habit #2: Prod data -->> dev, test databases

    RyderD (5/17/2011)


    I realize I don't post here, and perhaps I'm missing the point. But how can people reconcile this type of response (which I don't disagree with AT ALL)...


    - 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

  • RE: Working Long or Working Hard?

    I'm kind of a catch-22 when it comes to this, because I can get pretty dang paranoid about my production systems. Depends on the system, though. Some 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

  • RE: Best method for moving constant flow of data into SQL

    Drammy,

    From this:

    1, Extraction of everything from source database into text files.

    2, Analysis of text files, reading metadata -> creation of a .sql file containing T-SQL to drop and recreate 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

  • RE: Is it necessary to manually start the full-text index population after creating the index with auto-tracking?

    You're correct, the second step is unnecessary.

    See this article: http://msdn.microsoft.com/en-us/library/ms187317.aspx, in particular in the remarks section for when you have to manually start a population. If WITH NO POPULATION...


    - 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

  • RE: how to check if my database triggers and other objects are invoking tables that it's not exist

    The advertising above has been reported. Now, to the OP's question...

    Earl Downs (5/16/2011)


    Hello, I'm trying to know how to check if my database triggers and other objects are...


    - 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

  • RE: Are the posted questions getting worse?

    Trey Staker (5/16/2011)


    Craig Farrell (5/16/2011)


    Trey Staker (5/16/2011)


    All the US cities are in warm climates (usually) so I'd probably go to any of them. I wanted to go to Orlando...


    - 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

  • RE: Best method for moving constant flow of data into SQL

    I have a few other questions about what you're dealing with here, and to clarify I understand your process.

    Let's start with the staging table. It's a bulk drop 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

  • RE: Are the posted questions getting worse?

    Trey Staker (5/16/2011)


    All the US cities are in warm climates (usually) so I'd probably go to any of them. I wanted to go to Orlando but the timing wasn't...


    - 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

  • RE: Looking for Work in SQL Server

    Rahul The Dba (5/13/2011)


    Hi nice article, can you help me.....???

    I have done DBA cerification in SQL 2005 in 2009, my bachelor degree will be done by june of this year,...


    - 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

Viewing 15 posts - 3,181 through 3,195 (of 5,678 total)