Forum Replies Created

Viewing 15 posts - 2,566 through 2,580 (of 5,678 total)

  • RE: SSIS Vs sql import export performance

    <Answer moved>

    - 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

    September 22, 2011 at 2:27 pm

    #1385445

  • RE: 2 distinct instances of SQL Server 2005 - One jerks the other

    8GB for two instances is VERY small. You need at least 2gb for the OS, or you starve it and it has to go to the pagefile. As...

    - 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

    September 22, 2011 at 2:18 pm

    #1385436

  • RE: Best Practices for Scripting in SQL Server

    waseem.shahzad 45937 (9/22/2011)

    There is also an option that you can select in SSMS to include this if you are auto-generating the scripts

    How? Pls share.

    Change that to TRUE.

    - 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

    September 22, 2011 at 2:14 pm

    #1385432

  • RE: Best Practices for Scripting in SQL Server

    By preference for version rollouts I never use 'if exists'. In particular to catch those moments of human error. I don't want to see the same version script...

    - 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

    September 22, 2011 at 2:12 pm

    #1385430

  • RE: Are the posted questions getting worse?

    Kiara (9/22/2011)

    L' Eomot Inversé (9/22/2011)

    You can get some mileage (but not much) on some Gaelic from Google Translate by telling it it's Irish; but because the Irish turned their 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

    September 22, 2011 at 2:06 pm

    #1385426

  • RE: Free as in Beer

    Marlboro, while I agree in theory, it's not just the work that is causing the failure, it's the poor testing methods that the university who handed out the degree has...

    - 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

    September 21, 2011 at 6:03 pm

    #1384905

  • RE: Subquery returned more than 1 value.

    Glad I could help... if a bit from the side-like. 🙂

    - 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

    September 21, 2011 at 5:39 pm

    #1384901

  • RE: Subquery returned more than 1 value.

    duanecwilson (9/21/2011)

    I get this error when trying to run this query:

    Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >,...

    - 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

    September 21, 2011 at 3:10 pm

    #1384839

  • RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

    *claps* Rock on ya old whitebeard! Us younguns are still learnin' every day from ya! 😀

    - 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

    September 21, 2011 at 3:06 pm

    #1384835

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (9/21/2011)

    Evil Kraig F (9/21/2011)

    Ninja's_RGR'us (9/21/2011)

    Literally before I was born.

    Unlike a few others around here :Whistling:

    *puts fresh tennis balls on his walker for better movement* Stay stiiiillll...

    - 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

    September 21, 2011 at 2:59 pm

    #1384831

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (9/21/2011)

    Literally before I was born.

    Unlike a few others around here :Whistling:

    *puts fresh tennis balls on his walker for better movement* Stay stiiiillll there sonny... I'ma gonna...

    - 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

    September 21, 2011 at 1:42 pm

    #1384771

  • RE: Are the posted questions getting worse?

    Remi, I'd say you need a hobby, but apparently you already had one... Poor Lowell.

    What will Lowell ever do with himself now?! Shame on you, Remi. You've stolen...

    - 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

    September 20, 2011 at 3:38 pm

    #1384224

  • RE: Adding a null column and setting it to a default value of 0

    Need to include "WITH VALUES" on the default add.

    Section 'H' at this link: http://msdn.microsoft.com/en-us/library/ms190273.aspx

    - 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

    September 19, 2011 at 4:47 pm

    #1383578

  • RE: SSIS using variable as connection strings

    sqlfriends (9/19/2011)

    when I create a connection in connection manager, I would like to use expression that uses the user variable as connection , but is there a way to...

    - 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

    September 19, 2011 at 3:56 pm

    #1383543

  • RE: How to categorize patient encounters based on procedures done.

    ajenawsu (9/19/2011)

    Hi all,

    I have a table that holds patient encounters in it, and another table that holds all of the patient procedures that were done (each encounter can have one...

    - 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

    September 19, 2011 at 3:53 pm

    #1383542

Viewing 15 posts - 2,566 through 2,580 (of 5,678 total)