Forum Replies Created

Viewing 15 posts - 1 through 15 (of 95 total)

  • RE: Do Interviews Work?

    jfogel (5/17/2012)

    "It depends on some good senior people in your own organization, and their willingness to assess the candidates without involving themselves in a competition of sorts with the interviewee"

    Never...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    May 17, 2012 at 8:11 am

    #1489041

  • RE: Run SQL Server Scripts using C#

    I wouldn't use this for a backup specifically however it will be very useful in updating the hundreds to thousands of databases in our multitenant environment with the latest dacpac...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    April 27, 2012 at 7:28 am

    #1480394

  • RE: Would You Rather Work for a Strong or Weak Manager?

    I find it less important whether the manager 'gets the concepts' than whether she recognizes that she doesn't get them. I have had good managers who had no concept...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    August 26, 2011 at 8:45 am

    #1373812

  • RE: We Need a DBA Boot Camp

    1) No military boot camp for me, but my summer field geology course was a mini-geology boot camp. Just more fun and with better food.

    2) I think...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    July 6, 2011 at 7:47 am

    #1348964

  • RE: 100 Years Ago, What Would You Be?

    There weren't a whole lot of options for women back then - teacher, nanny, scullery maid, wife/mother.

    I think it would have depended on whether my family was rich or poor....

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    October 29, 2010 at 8:58 am

    #1244255

  • RE: Cheap Fun

    Last year my honey bought me a Kindle with his holiday bonus from work. (This wasn't the cheap part.)

    Since then I've spent countless hours reading the books available for...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    October 21, 2010 at 7:56 am

    #1240329

  • RE: Looking for best way to do a very large update

    Here's the showplan (sorry for the crappy formatting:

    update top(100000) MainTable set IntFK7=@tagid, ChangedBy=@userid, ChangedDate=@date from MainTable M inner join TempTableeead95e8x75a5x4f42xb639xbe56e74bd752 T on M.Pkey=T.Pkey where M.IntFK7 <> @tagid option(recompile)440NULLNULL4NULL90000NULLNULLNULL88.34656NULLNULLUPDATE0NULL

    ...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    July 14, 2010 at 8:22 am

    #1192850

  • RE: Looking for best way to do a very large update

    doobya (7/13/2010)

    use tablockx

    create index on temp table

    update statistics before update

    check index condition before and after update

    adjust fillfactor, padindex accordingly

    ensure logs are on separate drives to data

    ensure data and log files...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    July 14, 2010 at 8:22 am

    #1192849

  • RE: Brainstorming on strategies for a database with some data warehouse characteristics but with some updating required

    lloyd-236007 (7/14/2010)

    Anye Mercy (7/13/2010)

    Each job has its own database. The schema of an individual job database is about 98% the same between jobs, with a couple of tables that...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    July 14, 2010 at 7:37 am

    #1192806

  • RE: Looking for best way to do a very large update

    Good catch - I do actually have option(recompile) at the end of the query, but forgot to type it in the window here. I don't think I ever ran...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    July 13, 2010 at 5:08 pm

    #1192415

  • RE: Looking for best way to do a very large update

    Hm.. I don't know if that would be a good fit here. The update is performed based on something the user is doing in the application - and it...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    July 13, 2010 at 4:07 pm

    #1192391

  • RE: Slow simple query problem

    I think you are right on both counts - at first glance it appeared that the contents of the Query fields in database B were about the same size but...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    June 18, 2010 at 12:45 pm

    #1182318

  • RE: Paging and Versioning Using ROW_NUMBER()

    Ok, I dug it up (or dug up something else that was related) and I apparently misread it -- the article I read says that the CTE is executed the...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    June 15, 2010 at 8:07 am

    #1180437

  • RE: Paging and Versioning Using ROW_NUMBER()

    Hi Lawrence, I have spent quite a bit of time recently using Row_Number() with CTEs for paging purposes and have tried to gauge how to get the best performance possible...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    June 15, 2010 at 6:57 am

    #1180363

  • RE: Limited Features or Limited Time?

    When I am evaluating software for work, I absolutely want full-featured, for a limited time. Usually vendors are willing to give you extra time if you need it, especially...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

    June 3, 2010 at 9:42 pm

    #1176294

Viewing 15 posts - 1 through 15 (of 95 total)