Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (9/21/2010)


    Solo Cerveza, por favor.

    They come in ONES?? :w00t:

    Yep, and alone, too. 🙂


    - 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: Big Data and SQL

    Eric Russell 13013 (9/21/2010)


    Nevyn (9/21/2010)

    Not true, lazy people can totally learn proper SQL.

    Just , you know, um, later.

    Hey, all the developer needs to do is make sure his SQL basically...


    - 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: Error on DROP TABLE line in stored procedure defintion

    Remove the GO in the middle of the procedure after DROP TABLE dbo.TempML;


    - 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: Northwind and AdventureWorks a security risk?

    Sounds like someone else read an article and freaked. The question is, is this a hill worth fighting for? I'm dealing with that a bit myself at 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: Are the posted questions getting worse?

    Steve Jones - Editor (9/21/2010)


    Keep up the bad jokes and we'll likely get 30 a day 🙂

    Well, either 2 or 200... either enough facepalming noone can reach the keyboard... or...


    - 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: Datafile increased due to DBCC

    GilaMonster (9/21/2010)


    Craig Farrell (9/21/2010)


    That's part of the minimally built database I've seen mention of that builds at 64kb or something similar?

    Huh?

    CheckDB snapshot is created when checkDB starts and dropped 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

  • RE: Trace Data from major blocking incident

    David O (9/21/2010)


    The spid 94 query takes almost 4.5 minutes to run on it by itself and pulls back about 800K records. The vendor doesn't seem to see...


    - 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?

    Alvin Ramard (9/21/2010)


    Steve Jones - Editor (9/21/2010)


    Alvin Ramard (9/21/2010)


    Steve Jones - Editor (9/21/2010)


    Alvin Ramard (9/21/2010)


    I'm not impressed by anyone trying to look more important by using foreign words.

    Dees margarita ees...


    - 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: Datafile increased due to DBCC

    GilaMonster (9/21/2010)


    If you're interested, the snapshot is created using the NTFS alternate stream feature, and is created as an alternate stream of the data files, hence same drive and same...


    - 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: Race to post 1,000,000

    I'm gonna bet on the field. 😉


    - 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: Datafile increased due to DBCC

    GilaMonster (9/21/2010)


    Um, sorry, no.

    CheckDB uses a hidden database snapshot. It doesn't take copies of tables within the DB its working on.

    Because there's no way I'm gonna disagree with you until...


    - 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: Trace Data from major blocking incident

    GilaMonster (9/21/2010)


    Craig Farrell (9/20/2010)


    Edit: Alternate option if you can't run this in a new db... use the (NOLOCK) hint on the sql call for both tables, at the very least...


    - 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: Repeatative data

    You're looking for the HAVING clause

    SELECT name,Age,empcode FROM tbl GROUP BY name, age, empcode HAVING count(*) > 1


    - 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: select query with all values

    ColdCoffee (9/21/2010)


    Craig and Vekatraman, With all due respect to your wonderful attempts, both of your queries are not what the OP is expecting..

    Hm, Coffee, you have a valid point. ...


    - 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: Tempdb MDF - shrinking

    chrisjkelly (9/21/2010)


    Chaps - I thoroughly appreciate your help. I've restarted the service (not the agent this time (Doh!) and its cleared the space issues. I cant beleive how...


    - 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 - 5,461 through 5,475 (of 5,678 total)