Forum Replies Created

Viewing 15 posts - 3,916 through 3,930 (of 5,678 total)

  • RE: Trigger help

    tkacyndra (2/22/2011)

    i have the following trigger.

    basically, anytime i update a table, i need to copy the row to a history table and then do the update on the main...

    - 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

    February 22, 2011 at 12:41 pm

    #1290049

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (2/22/2011)

    On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles of encrypting? Not...

    - 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

    February 22, 2011 at 12:35 pm

    #1290046

  • RE: SSIS - I put a resultSet in a variable. How do I select from that resltset variable from a different Execute SQL Task

    Koen Verbeeck (2/22/2011)

    Craig Farrell (2/22/2011)

    Koen Verbeeck (2/22/2011)

    Craig Farrell (2/22/2011)

    I assume you've dropped it to a Recordset Destination? The short answer is: you can't, not easily.

    You create a foreach loop...

    - 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

    February 22, 2011 at 12:27 pm

    #1290040

  • RE: MAXDOP setting ignored

    ken.trock (2/22/2011)

    Select * From vExecutiveSummary, not that I'd ever do that :-D. Looks like the waittypes are CXPACKET. I'll get a better idea when some heavy user reports are run.

    select...

    - 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

    February 22, 2011 at 12:26 pm

    #1290037

  • RE: SSIS - I put a resultSet in a variable. How do I select from that resltset variable from a different Execute SQL Task

    Koen Verbeeck (2/22/2011)

    Craig Farrell (2/22/2011)

    I assume you've dropped it to a Recordset Destination? The short answer is: you can't, not easily.

    You create a foreach loop (the way that's built...

    - 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

    February 22, 2011 at 11:58 am

    #1290019

  • RE: SSIS - I put a resultSet in a variable. How do I select from that resltset variable from a different Execute SQL Task

    I assume you've dropped it to a Recordset Destination? The short answer is: you can't, not easily.

    You create a foreach loop (the way that's built in to work with...

    - 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

    February 22, 2011 at 11:48 am

    #1290010

  • RE: RAID & Filegroup Stategy for a new SQL Server 2005 system

    Rich Yarger (2/22/2011)

    Let me clarify further - here is what I am thinking from your suggestion:

    - min server memory / max server memory = 4gb

    - Virtual Memory Partition...

    - 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

    February 22, 2011 at 11:44 am

    #1290007

  • RE: MAXDOP setting ignored

    MAXDOP set at the server is the default, not an override.

    How are the problem queries being called, do you know the specific calls causing the issue (DBCC INPUTBUFFER), what 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

    February 22, 2011 at 11:16 am

    #1289993

  • RE: drop temp table in dynamic SQL

    Jeff Moden (2/21/2011)

    Umm... nope... I believe that's a problem, as well.

    <snip proof>

    The only way to do this using the same Temp Table name is with dynamic SQL.

    Dangit, you're right. ...

    - 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

    February 21, 2011 at 5:19 pm

    #1289656

  • RE: Enough memory to load entire DB?

    coder_t2 (2/21/2011)

    Hey guys, I am interested in upgrading my current server's memory to 16GB and trying to load the entire DB into it. The database is currently about 16GB in...

    - 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

    February 21, 2011 at 2:19 pm

    #1289616

  • RE: How to code this

    Ever notice as soon as you close a window and start looking as something else little things seem to come back to you?

    I believe this is what you're looking for...

    - 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

    February 21, 2011 at 1:19 pm

    #1289590

  • RE: How to code this

    Mike, I think you might have oversimplified your examples.

    I'm assuming the real code doesn't PRINT the results, but does something with them. What would that be?

    - 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

    February 21, 2011 at 1:12 pm

    #1289586

  • RE: drop temp table in dynamic SQL

    Deeby, can you post your actual code? It may have to do with your methodology.

    If I'm right, you're getting something like the results of this:

    SELECT 'abc' AS txt INTO...

    - 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

    February 21, 2011 at 1:09 pm

    #1289585

  • RE: How to tune text queries

    AJ-636201 (2/21/2011)

    Hey Thanks Creig,

    So such a query can not be improved, there will always be an index scan.

    So i think i got my answer:crying:

    Thanks

    Well, that's a new spelling... 🙂 ...

    - 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

    February 21, 2011 at 1:03 pm

    #1289582

  • RE: How to tune text queries

    AJ-636201 (2/21/2011)

    I have created only one clustered index and that is on FirstName column, and no other index has been created not even any non clustered index.

    So is there...

    - 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

    February 21, 2011 at 12:30 pm

    #1289563

Viewing 15 posts - 3,916 through 3,930 (of 5,678 total)