Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 15,381 total)

  • RE: Large Table Design Best Practices

    RonKyle (3/3/2016)

    That column cannot be made NOT NULL in the design because you can't enter that data when the first part is created. How do you enforce the NOT...

    March 3, 2016 at 3:01 pm

    #1862944

  • RE: Trigger for Table Updates

    Lowell (3/3/2016)

    Sean Lange (3/3/2016)

    Don't know what you want your trigger to do but be careful. Triggers fire once per operation, not once per row. So you need to create set...

    March 3, 2016 at 2:17 pm

    #1862929

  • RE: Trigger for Table Updates

    Don't know what you want your trigger to do but be careful. Triggers fire once per operation, not once per row. So you need to create set based queries in...

    March 3, 2016 at 1:41 pm

    #1862917

  • RE: Large Table Design Best Practices

    RonKyle (3/3/2016)

    The biggest challenge of using a single table for this is that the integrity checks would have to be moved to the application.

    I've used these kinds of accumulated...

    March 3, 2016 at 1:34 pm

    #1862915

  • RE: Large Table Design Best Practices

    RonKyle (3/3/2016)

    I'm with Sean. I would absolutely normalize this data.

    This is a false choice. The question is not to put it in a single table in an unnormalized...

    March 3, 2016 at 1:21 pm

    #1862905

  • RE: Nested Case statement question

    robert693 (3/3/2016)

    Hello,

    I have a problem where if a treatment is given between 07:00 and 09:00 am or between 19:00 and 21:00 pm then a protocol must be done between those...

    March 3, 2016 at 10:28 am

    #1862839

  • RE: Large Table Design Best Practices

    RonKyle (3/3/2016)

    But if you keep this in one table you lose a lot of data integrity control from the database side. You now have to allow null and move the...

    March 3, 2016 at 10:26 am

    #1862838

  • RE: Trigger doesn't seem to work

    dndaughtery (3/3/2016)

    I have a trigger that executes an insert into a table with the primary key, previous value, current value, and the Getdate() as a modified date. There are several...

    March 3, 2016 at 10:17 am

    #1862832

  • RE: Large Table Design Best Practices

    RonKyle (3/3/2016)

    think you will be much happier in the long run if you break this into properly normalized tables

    In the absence of data, this cannot be determined with certainty....

    March 3, 2016 at 9:51 am

    #1862820

  • RE: Large Table Design Best Practices

    tnpich (3/3/2016)

    Let me preface this by saying that "Large Table" means the size of the record (number of columns), not that there will be a large quantity of records in...

    March 3, 2016 at 8:41 am

    #1862791

  • RE: Are the posted questions getting worse?

    ChrisM@Work (3/3/2016)

    Sean Lange (3/2/2016)

    Ed Wagner (3/2/2016)

    Sean Lange (3/2/2016)

    Alan.B (3/2/2016)

    Sean Lange (3/2/2016)

    Steve Jones - SSC Editor (3/2/2016)

    Alan.B (3/1/2016)

    Ed Wagner (3/1/2016)

    Alan.B (3/1/2016)

    jasona.work (3/1/2016)

    Ah, using SQL Server DATEDIFF to figure out how many...

    March 3, 2016 at 7:07 am

    #1862731

  • RE: The Term Extraction Transformation

    SQLRNNR (3/2/2016)

    Steve Jones - SSC Editor (3/2/2016)

    Sean Lange (3/2/2016)

    Steve Jones - SSC Editor (3/2/2016)

    Sean Lange (3/2/2016)

    I guess that depends on the noun. :w00t:

    And age of the classifier. At least the...

    March 2, 2016 at 4:02 pm

    #1862600

  • RE: Are the posted questions getting worse?

    Ed Wagner (3/2/2016)

    Sean Lange (3/2/2016)

    Alan.B (3/2/2016)

    Sean Lange (3/2/2016)

    Steve Jones - SSC Editor (3/2/2016)

    Alan.B (3/1/2016)

    Ed Wagner (3/1/2016)

    Alan.B (3/1/2016)

    jasona.work (3/1/2016)

    Ah, using SQL Server DATEDIFF to figure out how many days until my...

    March 2, 2016 at 12:42 pm

    #1862534

  • RE: Are the posted questions getting worse?

    Alan.B (3/2/2016)

    Sean Lange (3/2/2016)

    Steve Jones - SSC Editor (3/2/2016)

    Alan.B (3/1/2016)

    Ed Wagner (3/1/2016)

    Alan.B (3/1/2016)

    jasona.work (3/1/2016)

    Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

    Hmm, using DD makes...

    March 2, 2016 at 12:15 pm

    #1862519

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/2/2016)

    Alan.B (3/1/2016)

    Ed Wagner (3/1/2016)

    Alan.B (3/1/2016)

    jasona.work (3/1/2016)

    Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

    Hmm, using DD makes it seem so...

    March 2, 2016 at 10:42 am

    #1862494

Viewing 15 posts - 1,711 through 1,725 (of 15,381 total)