Forum Replies Created

Viewing 15 posts - 1,906 through 1,920 (of 5,685 total)

  • RE: On Database Migrations and Agility

    Peter Schott (1/22/2012)

    Along those lines, ones you have a decent Continuous Delivery system in place, this shouldn't be as much of a problem. You have your downstream environment(s) that are...

    January 22, 2012 at 4:50 pm

    #1436928

  • RE: On Database Migrations and Agility

    ganotedp (1/22/2012)

    I can't really concur with Dreamweaver's analogy with human development. But Evil Craig F (Ferguson?) is spot on with:

    Craig Farrell. 🙂 Pleasure to meet ya. ...

    January 22, 2012 at 12:46 pm

    #1436910

  • RE: aggregation, group by clause, need help tweakng query

    aitchkcandoo (1/22/2012)

    Evil Kraig,

    That works well. I don't detect extra rows or anything.

    I am making things complicated withthe Over and Partition By, I can see.

    By extra rows I meant there were...

    January 22, 2012 at 12:45 pm

    #1436909

  • RE: View is not showing changed data.

    Satya_0000 (1/21/2012)

    I have altered the view however on querying the view it is not reflecting the changes. anyone pls advice.

    After doublechecking what was recommended above... can you be a little...

    January 22, 2012 at 1:22 am

    #1436866

  • RE: Enable & Disable Index - SSIS

    gugan_ta (1/20/2012)

    I thought to get the expert guidance to know which one will be the best approach.

    The second option will create the least churn for your database, which is good....

    January 22, 2012 at 1:19 am

    #1436865

  • RE: On Database Migrations and Agility

    Peter Schott (1/11/2012)

    I actually like the Agile plan when it can work. I've seen too many large DB Projects fail due to using waterfall (think Amazon Falls) methodology and then...

    January 22, 2012 at 1:15 am

    #1436864

  • RE: The dialog disappears in SSIS 2005

    Personally I'd reinstall from scratch. It sounds like a dll corrupted.

    January 22, 2012 at 1:10 am

    #1436863

  • RE: Conditional Trigger Question

    CELKO (1/21/2012)

    That is another thing we do not like in RDBMS. Redundancy and physical moving of data like it was still on punch cards. WE use VIEWs, COMPUTED and REFERENCES...

    January 22, 2012 at 1:06 am

    #1436862

  • RE: Help me: Many Tables to join.

    GilaMonster (1/21/2012)

    A scalar UDF accessing data in the select clause of a query, yeah it's almost certainly a problem, UDFs are (and they don't show up in execution plans or...

    January 22, 2012 at 12:52 am

    #1436861

  • RE: Database normalization question

    pfm200586 (1/21/2012)

    Student ID

    Student Name

    Major

    Credits Required to Graduate

    Course ID

    Course Name

    Credit Hours for Course

    Course Cost

    Prerequisites to Course

    I came up with two tables (students and...

    January 22, 2012 at 12:48 am

    #1436860

  • RE: aggregation, group by clause, need help tweakng query

    This works fine for me (though I get two extra rows for 10015 and 10018).

    select c.cus_code, c.cus_balance, sum(l.line_units * l.line_price) as "Total Purchases"

    from customer c

    join invoice i

    on c.cus_code = i.cus_code

    join...

    January 22, 2012 at 12:44 am

    #1436859

  • RE: Joining 2 tables, with all values from first

    L' Eomot Inversé (1/20/2012)

    I would say it's better to include it before the ON clause, so that it's clear what's going on: in this case

    BUT: I wouldn't be surprised if...

    January 22, 2012 at 12:30 am

    #1436858

  • RE: Design Challenge

    JohnDBA (1/21/2012)

    Thanks so much for the help!!! That worked perfectly. 🙂

    Excellent. Sometimes it's easy to end up overthinking these things. 🙂

    January 22, 2012 at 12:22 am

    #1436857

  • RE: SQL Agent Job succeeds even though step should fail

    L' Eomot Inversé (1/20/2012)

    Drat, that's horrible. Surely there is some way of detecting this error?

    No, it appears to be a 'feature' of 2k8 for Linked Servers. I haven't...

    January 22, 2012 at 12:22 am

    #1436856

  • RE: I am hoping there is a simple way to accomplish this selection

    meichner (1/20/2012)

    I do have a question about your note. Am I correct that if I had a connection between the 'u' and 'm' that I would not have gotten the...

    January 22, 2012 at 12:14 am

    #1436855

Viewing 15 posts - 1,906 through 1,920 (of 5,685 total)