Forum Replies Created

Viewing 15 posts - 16 through 30 (of 215 total)

  • RE: Create Index performance - what am I missing?

    Thanks for the insight, I need to spend more time on this. We are putting in more disk on the SAN tomorrow so we have a bunch of downtime,...

    January 24, 2011 at 4:20 pm

    #1277525

  • RE: Kerberos and NTLM

    The answer was correct but I'm not sure it was to the question asked. Do you want to know whether Windows or SQL Login, or do you want to...

    January 21, 2011 at 6:26 pm

    #1276856

  • RE: Where do you look for DBA's?

    GSquared (1/21/2011)

    Just to beat this dead horse a bit more:

    I have heard two threads in this -- one is "but when will I have time to do both" and "you...

    January 21, 2011 at 7:38 am

    #1276544

  • RE: Where do you look for DBA's?

    Brandie Tarvin (1/20/2011)

    There is a difference between a Jack of All Trades and a Specialist. A multi-talented Specialist is what a lot of people are seeing with this description.

    It's a...

    January 20, 2011 at 6:13 am

    #1275843

  • RE: Where do you look for DBA's?

    Thanks again. Some comments.

    First, I should have posted the job description earlier in the thread. Some forums are very picky about such, was trying to be careful....

    January 20, 2011 at 5:57 am

    #1275834

  • RE: Where do you look for DBA's?

    Craig, thanks.

    A couple of short responses:

    It is senior, not sure where you saw it was not, I did not post the actual position description in full. Should...

    January 19, 2011 at 5:59 pm

    #1275628

  • RE: Where do you look for DBA's?

    GilaMonster (1/19/2011)

    You asked. I'll try and be gentle.

    So in summary you need:

    A database administrator who can monitor and tune a multi TB database while doing all DBA duties including but...

    January 19, 2011 at 1:54 pm

    #1275561

  • RE: Where do you look for DBA's?

    Wow, flurry of info, thanks.

    First, the job descriptions posted were NOT for my job. I was not trying to turn this into a "anyone want a job",...

    January 19, 2011 at 1:24 pm

    #1275545

  • RE: Where do you look for DBA's?

    Ninja's_RGR'us (1/19/2011)

    Technically speaking....

    I have a corporation in Canada. Can't you hire my consulting corporation to contract for you in the states? Or are there laws against that?

    Again technically...

    January 19, 2011 at 9:30 am

    #1275390

  • RE: Where do you look for DBA's?

    Doug Lane (1/19/2011)

    Have you tried announcing it at a local users group meeting? If I needed to hire someone or was looking for a job myself, I'd be sure...

    January 19, 2011 at 9:23 am

    #1275384

  • RE: Create Index performance - what am I missing?

    McSQL (1/19/2011)

    Hmm, personally I would say that 30 minutes to build an index on 280 million rows is not so bad performance at all really, was this for a clustered...

    January 19, 2011 at 6:17 am

    #1275252

  • RE: Triggers, Stored Procedures, & MS Access UI's

    I don't have the energy to work through all the attached code, but the trigger has some conditions in it. How sure are you that those are not failing...

    January 19, 2011 at 6:08 am

    #1275248

  • RE: Best practice for building a SELECT query based on multiple paramters

    Dynamic SQL.

    Despite being politically incorrect (insert long discussion on injection, readability, etc.), if your query runs for a long time, and has a ton of OR's in the predicate to...

    January 19, 2011 at 5:56 am

    #1275243

  • RE: Where do you look for DBA's?

    Henrico: Hey, don't tempt me, but unfortunately no one can deal with the US Government, and we need someone soon.

    Lynn: Thanks. That's more in line with what I was curious...

    January 19, 2011 at 5:51 am

    #1275234

  • RE: Create Index performance - what am I missing?

    McSQL (1/19/2011)

    Creating an index will usually require additional space in the mdf...could be down to autogrowth?

    Or have you set the database to simple recovery model while you're building up the...

    January 19, 2011 at 5:36 am

    #1275226

Viewing 15 posts - 16 through 30 (of 215 total)