Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 5,678 total)

  • RE: Round a number to lower bound

    Look at the function FLOOR()


    - 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: T-SQL Question: Getting different ways to reach from Point A to Point B

    *facepalm* This is not pretty.

    As to your first comment, your first post was at ~1:30 AM, and the next at ~5:45 AM for me. I was asleep while...


    - 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: Data nearing to 4GB. is there is a way to extend size?

    Elliott Whitlow (6/29/2011)


    Craig Farrell (6/29/2011)


    Can someone point me at the 10GB documentation for R2?

    http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

    The line "DB Size" under Free Editions. That is pretty clear to me 10GB..

    CEWII

    Link saved, thank...


    - 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: Data nearing to 4GB. is there is a way to extend size?

    paul.knibbs (6/28/2011)


    Ninja's_RGR'us (6/28/2011)


    Just my 0.02$... MS decided that 1 GB ram and 4 GB data was what they were prepared to give for free.

    10Gb data in SQL Express 2008...


    - 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: Data nearing to 4GB. is there is a way to extend size?

    repicurus (6/29/2011)


    I gave NO legal advice whatsoever - I'm honestly not sure how you could derived such a conclusion.

    There was NO action taken that would result in any legal standing;...


    - 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: Code Ownership - DBA vs. Developer

    Jeff Moden (6/28/2011)


    Craig Farrell (6/28/2011)


    Here's where that concept gets caught. Yes, YOU as a DBA may own your server's code. I know many, including myself depending on the environment, who...


    - 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: Data nearing to 4GB. is there is a way to extend size?

    paul.knibbs (6/28/2011)


    I have a 64-bit R2 Express install on my PC here. Just checked it out, and found the following files:

    License_SqlBrowser.txt

    license_SQLCMD.txt

    License_SQLNCLI_ENU.txt (one of these in both Program Files (x86) 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

  • RE: Data nearing to 4GB. is there is a way to extend size?

    Ninja's_RGR'us (6/28/2011)


    paul.knibbs (6/28/2011)


    Ninja's_RGR'us (6/28/2011)


    Just my 0.02$... MS decided that 1 GB ram and 4 GB data was what they were prepared to give for free.

    10Gb data in SQL Express...


    - 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: Urgent: 8 Consecutive days worked

    Please see the first link in my signature for the best way to setup a sample DDL/dataset and to show what results you're looking for from that dataset.

    It's much easier...


    - 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: Code Ownership - DBA vs. Developer

    Hey Jeff. 🙂

    I'd hoped you'd swing by. I really didn't want to utterly derail the other thread and something like this can take on a life of its...


    - 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: Code Ownership - DBA vs. Developer

    george sibbald (6/27/2011)


    Quick point - is 'bottleneck' the right word?

    It's precisely the right word when you've got 3-4 DBAs supporting 80 developers. They cannot own anything, which is why...


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

    george sibbald (6/27/2011)


    the thread won't die whilst the no. of characters in a 'tweet' is limited.

    Or so I believe. I have never 'tweeted' myself and feel silly just using...


    - 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: Code Ownership - DBA vs. Developer

    george sibbald (6/27/2011)


    Craig Farrell (6/27/2011)


    george sibbald (6/27/2011)


    I think you have to accept that in most shops devs will own the code but not the environment (and certainly not production). 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?

    mtillman-921105 (6/27/2011)


    Craig Farrell (6/27/2011)


    mtillman-921105 (6/27/2011)


    I've never tweeted, but I already have a follower somehow! Here's one of their delightful insights:

    So my nose ring hole got reallly small cause i've...


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

    mtillman-921105 (6/27/2011)


    I've never tweeted, but I already have a follower somehow! Here's one of their delightful insights:

    So my nose ring hole got reallly small cause i've been having 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

Viewing 15 posts - 2,866 through 2,880 (of 5,678 total)