Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 6,041 total)

  • RE: delete millions of rows

    4 million rows is actually not a lot, but it depends on the speed of your storage system and whether the table will need to remain online and usable while...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Ignoring Database Version Control

    Even when a VCS has been installed within the organization, I guess some teams are reluctant to checkin code, because they are not sure where exactly where to checkin or...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Impressive Accomplishments

    If a resume that is nothing but a boiler plate cover, a list of past employers and schools I've never heard of, and a tag cloud of unsubstantiated skills, then...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Finding long running query and killing it

    The Dixie Flatline (9/8/2016)


    I agree with Chris and Gail.

    Every one of those emails are going to result in a "WHY DID THEY KILL MY JOB?" scream.

    That's why...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Finding long running query and killing it

    I'm not sure if this approach would be flexible enough for your needs, but it would leverage some built in features of SQL Server, rather than attempting to code your...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: You know what we really need? Better interpersonal communication

    Maybe somtimes veteran forum members make invalid assumptions about the technical expertise of new members, so called "grasshoppers", who quite possible know more in actuality than any of the regulars....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: User (db_datareader) can't see tables in MS; can SELECT data!

    kweiskittel (9/6/2016)


    Eric, Did you see my first post right before yours? How do you explain that? Very odd yes?

    It's the same SQL account; one user can see the tables, the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: You know what we really need? Better interpersonal communication

    Gary Varga (9/8/2016)


    Eric M Russell (9/8/2016)


    I don't know who came up with the idea of adding an 'Edit' button to this forum, but they were spot on. We probably wouldn't...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Separate Staging Tables and Data Warehouse into different Databases.

    Welsh Corgi (3/23/2012)


    Until today I never saw a Database that contained both the Staging Tables and Data Warehouse Tables in the same Database.

    ...

    Until SQL Server 2012, it wasn't an option...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: You know what we really need? Better interpersonal communication

    I don't know who came up with the idea of adding an 'Edit' button to this forum, but they were spot on. We probably wouldn't still be here is it...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: questions about sql

    coool_sweet (8/28/2016)


    i am not finding it anywhere

    yes interview question

    The following website can be used to locate Nolocks in the US.

    http://www.peoplefinders.com/peoplesearch/searchresults?Criteria.search=People&Criteria.fn=&Criteria.mn=&Criteria.ln=nolock

    I'm seeing several in Colorado, Wisconsin, New Jersey, and Michigan.

    Regards

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Who can afford Senior DBA?

    ebooklub (9/7/2016)


    Recently I applied thought recruiting agency as contractor for several DBA positions

    Recruiters agree on asking rate, applications was submitted, few days later recruiters responded that clients looking for intermediate...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Who can afford Senior DBA?

    Some organizations think that a DBA is some dude who sits in a closet full of servers, shuffling tape backups and eating potato chips. That's what they pay for, and...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: SQL Code QA

    Tell your DBA that she get's the job done, but she's kind of clunky when it comes to offering constructive advice about T-SQL.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Fuzzy Matching

    Jason A. Long (9/6/2016)


    Eric M Russell (9/6/2016)


    J Livingston SQL (9/6/2016)


    -- just for fun

    SELECT[dbo].[DoubleMetaPhone]('Pheasant');

    SELECT[dbo].[DoubleMetaPhone]('Phesant');

    SELECT[dbo].[DoubleMetaPhone]('Fessant');

    SELECT[dbo].[DoubleMetaPhone]('Fezant');

    SELECT[dbo].[DoubleMetaPhone]('Phes ant');

    SELECT[dbo].[DoubleMetaPhone]('Fez aunt');

    quite impressive

    Still there is the issue that two words sounding alike are completely different.

    SELECT[dbo].[DoubleMetaPhone]('Pheasant');

    FSNT FSNT

    SELECT[dbo].[DoubleMetaPhone]('Fussy Aunt');

    FSNT...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 2,296 through 2,310 (of 6,041 total)