Forum Replies Created

Viewing 15 posts - 4,786 through 4,800 (of 5,678 total)

  • RE: get the name of the bit column set to 1

    Design question: Why would you use this approach?

    If each of the ten indicators are mutually exclusive, they should be listed in a single field as a status flag or something....


    - 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: Commit unending on empty updates

    Tony++ (11/29/2010)


    * I've made the change for select rather than update, thanks for the pointer on that. I can't say that I understand why the select IX should 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

  • RE: Needed SQL DBA's (multiple positions contract/Full Time)

    WayneS (11/29/2010)


    CirquedeSQLeil (11/29/2010)


    GilaMonster (11/29/2010)


    Not quite sure how to take that. I'm 34 in a week and a day's time. 1994 was my final year of school.

    Well, 92 was my final...


    - 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: High CPU on SQL 2008 64BIT

    Direct quote from here: http://sqlblogcasts.com/blogs/christian/archive/2008/06.aspx

    The first interesting ones I’ve looked at are the new PREEMPTIVE wait types. Any code that needs to execute outside SQL Server has to go...


    - 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: Importing from Excel file with lots of tabs and merged cells

    Kit G (11/29/2010)


    I tried importing using the Import/Export wizard, but that crashed and burned without really telling me why. But I figure it is because there are merged cells...


    - 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: Commit unending on empty updates

    Tony++ (11/29/2010)


    This article describes exactly what the code is trying to do (get an IX lock via an empty update), and may have been where the idea came from. ...


    - 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: What is Timeout?

    kcinman11358 (11/29/2010)


    A very simple answer to this is if you are connected online, you could have lost your connection briefly and when it sent a signal, it didn't receive anything...


    - 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: Pattern help in SQL

    You'll pardon me if I'm inaccurate, but this is similar to a classic homework problem.

    Please show what work you've done and we'll help you get unstuck. Check the first...


    - 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 SQL Server Central

    Nah, of course not... It runs on Oracle. 😛

    Yes, afaik SSC runs on SQL Server, 2k8 if memory serves.


    - 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: Needed SQL DBA's (multiple positions contract/Full Time)

    Well, you can get by pretty damned well in the states at $100/hour, so perhaps it's time to look into grabbing a visa? 😀

    Side bonus, better internet!

    On a comment you...


    - 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: Ideal/Top companies/Work Environments a DBA should aim for

    allin1 (11/29/2010)


    I am at teh start of my career as DB Dev/DBA (2 yrs). I am in a small company with no challenging work. I was wondering what would 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

  • RE: SQL Server Collation question

    You have to specify the code page, 1252.

    See here:

    http://msdn.microsoft.com/en-us/library/ms180175.aspx

    Future note, easily located via google. Search sql server collation CP1. 🙂


    - 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: Needed SQL DBA's (multiple positions contract/Full Time)

    Ninja's_RGR'us (11/29/2010)


    1 bazillion years of experience is going to cost you, period. We just happen to love sharing with people which makes useven stronger DBAs, but I'm...


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

    Side note, I live in a desert, in a place called 'Valley of the Sun'.

    Global warming my arse. I think I just frosted my toes off having a smoke.

    http://www.google.com/#sclient=psy&hl=en&q=phoenix+weather&aq=f&aqi=&aql=&oq=&gs_rfai=&pbx=1&fp=567204dc07534ddc


    - 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: Needed SQL DBA's (multiple positions contract/Full Time)

    GilaMonster (11/29/2010)


    Craig Farrell (11/29/2010)


    Contracting usually tops out between $60-$75/hour (for the consultant via a consulting firm, corp to corp independents are a whole different set of rules)

    I bill $100/hour,...


    - 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 - 4,786 through 4,800 (of 5,678 total)