Forum Replies Created

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

  • RE: Milk

    jay-h (8/14/2012)


    I'm a firm believer in 'if you can't explain it in plain English (or other), you don't understand it". While technical terminology may be necessary when addressing esoteric...

  • RE: Never, Ever Use Clustered Indexes

    P Jones (5/31/2012)


    The problem of possibly changing databases should be catered for in the actual application code by using a data access layer that can be changed according to the...

  • RE: Promoting Engineers

    @TravisDBA - Yes unfortunately you're correct. It's an unfortunate situation that I don't see changing without some type of drastic global event that can change attitudes. Until...

  • RE: Promoting Engineers

    Yeah it really does. Been there, done that myself. It is called "pigeon-holing" and I have seen it derail many peoples career goals over the years until they got fed...

  • RE: Promoting Engineers

    Completely agree with this one. At my current job I've started as standard IT Support and in my many years here I've grown and now do additional roles like DBA,...

  • RE: When Will You Upgrade to SQL Server 2012?

    When I ask vendors why, they generally tell me that they don’t have the in-house resources to do the testing. In other words, they are cheap and don’t want to...

  • RE: Never offend a captive audience

    While I do agree that there is no need for profanity in technical writing, documentation or presentations I completely disagree that it shouldn't be used in everyday life, workplace or...

  • RE: Persisted vs Non-persisted Computed columns

    Argh didn't get it wrong because I didn't know the answer but rather because I can't seem to count this morining.:blush:

  • RE: Truncate rollback

    CirquedeSQLeil (4/22/2010)


    Hugo makes a great point. If everything is explicitly laid out so as to invoke no thought, then the question may be too easy and far too few...

  • RE: Truncate rollback

    Hugo Kornelis (4/22/2010)


    As an author of eleven questions so far (2 of them not yet published), I can only say that you are wrong. I tried very hard to get...

  • RE: Truncate rollback

    Ninja's_RGR'us (4/22/2010)

    I toyed with the idea of including 2008 in there, but I felt it gave better challenge if the code couldn't be run.

    Thing is you didn't need to...

  • RE: Joining on view with a group by or distinct causes slow query

    Hi Jeff,

    Sorry for not replying sooner. Hectic isn't the word for it these days. :crazy:

    Anyway I finally got the missing piece of the puzzle. I'd forgotten to put an index...

  • RE: Joining on view with a group by or distinct causes slow query

    Hi Jeff,

    Yeah I hear where you're coming from and for contacts they have done this properly but not for other objects.

    Orgs can have a main phone and/or fax on...

  • RE: Joining on view with a group by or distinct causes slow query

    I had thought about an indexed view for the phone number part but I'm a bit hazy on whether I can do this or not. I've read a bit about...

  • RE: Joining on view with a group by or distinct causes slow query

    Hi Jeff,

    Yeah I am wanting everything in one view I'm afraid. The reason being is that the application I have to use (3rd Party) has the ability to create custom...

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