Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 5,678 total)

  • RE: SQL Server support options

    river1 (11/22/2011)


    For my SQL Server 2000 databases the extended support has ended. Can i get more paying? or i need to migrate?

    Call Microsoft, that's the only answer I can give...


    - 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: Today's Random Word!

    SQLRNNR (11/22/2011)


    riddle

    Question Mark


    - 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: Excute SP in Access 2007 Database

    tuhlig (11/22/2011)


    I have an Access 2007 database that kicks off a sql stored procedure. The SP kicks off an email program. Runs fine most of the time. ...


    - 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 support options

    river1 (11/22/2011)


    Hi Guys,

    I know that SQL Server as two types of support. the first one will end in 5 years and there is other support that only ends after several...


    - 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: Processor license of SQL server

    GilaMonster (11/22/2011)


    Licensing for virtuals is now a hell of a lot easier. Before, say I have a virtual server with 6 virtual CPUs. How many socket licenses do I need...


    - 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: Processor license of SQL server

    sqlfriends (11/22/2011)


    Licensing for virtuals is now a hell of a lot easier. Before, say I have a virtual server with 6 virtual CPUs. How many socket licenses do I need...


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

    Koen Verbeeck (11/22/2011)


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


    ...

    I like your signature by the way. One of those universal truths 😀

    Pourquoi contredire une femme ? Il est tellement plus simple d'attendre qu'elle change...


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

    SQLRNNR (11/22/2011)


    Stefan Krzywicki (11/22/2011)


    Ninja's_RGR'us (11/22/2011)


    Stefan Krzywicki (11/22/2011)


    Koen Verbeeck (11/22/2011)


    Ninja's_RGR'us (11/22/2011)


    What do you guys think of this as a first house?

    http://passerelle.centris.ca/Redirect2.aspx?CodeDest=I2V&NoMls=MT8619554&Source=

    In Belgium, that would be a cheap house :blink:

    It certainly looks...


    - 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: Trying to determine fraudulent activity based on numbers dialed

    You're going to find this a little odd but what it will do is give you indicators if those types of dialers are found. First, we need a little...


    - 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: Unable to retrieve column information from the data source Error msg SSIS

    Confirm the metadata on the view is refreshed since the last changes. sp_refreshview


    - 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: Agregate join

    An example of the equivalency of the statements on a max compare vs. a cross apply. Adjust as needed.

    This is a pared down testbed I use for this example....


    - 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: View Execution Plans

    Stefan Krzywicki (11/22/2011)


    Anyone have a good way to view and compare execution plans? The display in SSMS is small and I can't view them side by side. Is there 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

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (11/22/2011)


    You're an opinionated bunch here, I'd appreciate hearing your opinions on Execution Plan viewing

    Go opinionate! (Please) :w00t:

    Opinion opinion... opinion... opt opt.... opinion! Onionate! Unionate! Unify...


    - 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: Calculating Percentage using a CTE Or with a COUNT(*) OVER Clause

    Going to need to back this up a bit. How do you know if something became a sale from the raw data?

    Or are you looking for an in-line percentage...


    - 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's the best way to get an entry level job on SQL server?

    tfifield (11/22/2011)


    There has been lots of very good advice already posted. Craig's article is one of the best I've seen on the subject.

    One of the main points you have...


    - 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,251 through 2,265 (of 5,678 total)