Forum Replies Created

Viewing 15 posts - 2,011 through 2,025 (of 2,647 total)

  • RE: Split Function - Comma and/or Space Delimited

    Cadavre (1/4/2012)

    Jeff Moden wrote an excellent article on splitters here[/url].

    Thanks for that, but what I am really trying to get at in this post is not an actual delimited string,...

    Jared
    CE - Microsoft

    January 4, 2012 at 10:22 am

    #1428504

  • RE: How SQL uses Memory

    Ninja's_RGR'us (1/3/2012)

    GilaMonster (1/3/2012)

    Ninja's_RGR'us (1/3/2012)

    Yes, read the book!

    She's not lazy, it's not something she can answer in 2 words.

    Just to put things in perspective, the chapter that I'm referring you to...

    Jared
    CE - Microsoft

    January 3, 2012 at 9:56 am

    #1427843

  • RE: Pay Ranges

    Jeff Moden (12/23/2011)

    SQLKnowItAll (12/22/2011)

    It is just a selling point for me that helps me negotiate since I cannot use years of experience. I have only been a DBA for 3...

    Jared
    CE - Microsoft

    December 24, 2011 at 5:41 am

    #1425328

  • RE: Pay Ranges

    krowley (12/23/2011)

    Let's rephrase the question, if I were planning to hire a DBA etc... What salary range should I be planning to budget for.

    Well... Where is the job? Chicago would...

    Jared
    CE - Microsoft

    December 23, 2011 at 10:22 am

    #1425225

  • RE: Database Designing issue

    there are a lot of popular data warehousing techniques that are plain wrong.

    This is a very dangerous statement. There are very few things in our area that are "just...

    Jared
    CE - Microsoft

    December 23, 2011 at 7:27 am

    #1425168

  • RE: Pay Ranges

    Dev (12/23/2011)

    In my case I also have 2 post-graduate degrees, one of which pertains managing a business and understanding these types of things. Like a techy MBA :)...

    Jared
    CE - Microsoft

    December 23, 2011 at 6:16 am

    #1425131

  • RE: Random Slowness in Insert statment

    Jeff Moden (12/22/2011)

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

    Jeff Moden (12/21/2011)

    Aspet Golestanian Namagerdi (12/21/2011)

    Actually I stopped the Log shipping Backup job and also I disable the replication jobs but still every 10 minutes,slowness happens...

    Jared
    CE - Microsoft

    December 23, 2011 at 6:06 am

    #1425123

  • RE: Database Designing issue

    GilaMonster (12/23/2011)

    dilipd006 (12/23/2011)

    I decided to go for seperate tables, as it would be easy to maintain.

    Easier to maintain maybe, probably easier to query, likely better performance and far less chance...

    Jared
    CE - Microsoft

    December 23, 2011 at 6:03 am

    #1425122

  • RE: Pay Ranges

    GSquared (12/22/2011)

    David Moutray (12/22/2011)

    GSquared (12/22/2011)

    And I dropped out of both kindergarden and college! But I've got a well-paid DBA job anyway.

    Heh. I'm glad I'm not the only one!...

    Jared
    CE - Microsoft

    December 22, 2011 at 5:01 pm

    #1424991

  • RE: Random Slowness in Insert statment

    I like how you say this is random slowness, when in fact it is every 10 minutes 🙂 Is it possible for you to run a server-side trace to see...

    Jared
    CE - Microsoft

    December 22, 2011 at 10:59 am

    #1424889

  • RE: Database Designing issue

    I would store the common information for the products in 1 table. Almost like a header table. Then store the details for a specific product in their own tables. For...

    Jared
    CE - Microsoft

    December 22, 2011 at 10:50 am

    #1424886

  • RE: Pay Ranges

    David Moutray (12/22/2011)

    MysteryJimbo (12/21/2011)Generally I've found DBA's get paid around 15-20% more than developers in the same company and around the same as Development management.

    Does it seem wrong to anyone...

    Jared
    CE - Microsoft

    December 22, 2011 at 10:41 am

    #1424883

  • RE: Date with Time

    VIG (12/21/2011)

    select cast(CAST(getdate() as DATE) as datetime)

    results of running Jeff Moden's script on my 2008R2 with additional cast/cast convertion

    (1000000 row(s) affected)

    --===== DATEADD/DATEDIFF =============================================

    SQL Server Execution Times:

    ...

    Jared
    CE - Microsoft

    December 21, 2011 at 5:28 am

    #1424153

  • RE: Date with Time

    Well then, it was not an article, but your test. Thanks for posting again! Would you mind if I mentioned this test in my blog and cited you for...

    Jared
    CE - Microsoft

    December 20, 2011 at 8:33 pm

    #1423988

  • RE: Date with Time

    Faster:

    SELECT CAST(DATEDIFF(d,0,GETDATE()) AS DATETIME)

    Can't find the article offhand that proves this, but I will continue to look. Could it be one of Jeff's?

    Jared
    CE - Microsoft

    December 20, 2011 at 3:00 pm

    #1423937

Viewing 15 posts - 2,011 through 2,025 (of 2,647 total)