Forum Replies Created

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

  • 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...

    September 8, 2016 at 7:40 am

    #1899808

  • 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...

    September 8, 2016 at 7:17 am

    #1899797

  • 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...

    September 8, 2016 at 7:12 am

    #1899795

  • 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...

    September 8, 2016 at 6:58 am

    #1899788

  • 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

    September 7, 2016 at 12:06 pm

    #1899643

  • 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...

    September 7, 2016 at 10:10 am

    #1899614

  • 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...

    September 7, 2016 at 7:37 am

    #1899577

  • 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.

    September 7, 2016 at 7:27 am

    #1899574

  • 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...

    September 6, 2016 at 2:40 pm

    #1899466

  • RE: Ensuring logins are not used

    If you've enabled login auditing, and you've confirmed no logins for past month, then should do it. At this point disable them and have an email alert notify you in...

    September 6, 2016 at 2:25 pm

    #1899462

  • RE: Fuzzy Matching

    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 FSNT

    September 6, 2016 at 11:33 am

    #1899423

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

    By default, VIEW DEFINITION (access to DDL text of an object) is denied. You can grant this a user at the server, database, schema, or object level. The following article...

    September 6, 2016 at 11:23 am

    #1899416

  • RE: NCAs and NDAs

    mjh 45389 (9/6/2016)

    Many years ago I volunteered for redundancy (it was a case of that if you volunteered you got a fairly generous payoff but if did not you would...

    September 6, 2016 at 11:17 am

    #1899411

  • RE: Fuzzy Matching

    'ABC Lickers' is probably an entirely different business.

    September 6, 2016 at 11:11 am

    #1899410

  • RE: NCAs and NDAs

    Here in the US, local state laws can limit non-compete agreements or subject them to a restricted interpretation. Whether a court will uphold a disagreement depends on whether the NCA...

    September 6, 2016 at 8:46 am

    #1899355

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