Forum Replies Created

Viewing 15 posts - 136 through 150 (of 380 total)

  • RE: The Number that shouldn't be a number

    jarick 15608 (1/31/2015)


    The one I dont get is the use of float in a financial application. I just don't see the reason. Someone help me.

    I've seen some big...

  • RE: The Number that shouldn't be a number

    How about using the dbtimestamp data-type as the Identity Column Value and Primary Key for Claim and Policy tables in an insurance database?

    Can you guess what happened when they tried...

  • RE: Deploy the Database First

    mike.gallamore (1/26/2015)


    Or applications that sit on top of someone else's database: say health care systems, CRM etc. Often it becomes the job of the front end guys to quickly re-wire...

  • RE: Deploy the Database First

    Another reason why SELECT * from <any object> should never be used in application execution code.

    We have two apps created by a Developer that swears this is fine.

    Of course he...

  • RE: Removing Duplicates

    How do you delete a duplicate from a Heap?

    If the table is a true Heap with no PK and the records in every column match you would have to delete...

  • RE: Two Days Off

    Eric M Russell (1/8/2015)


    The good news is that Verizon cloud services isn't very popular, so the outage should impact only a small percentage of it's customers. 🙂

    I did read...

  • RE: Two Days Off

    If it goes down ever it is not a "cloud" service it is a remote service.

    Cloud services are always on and should be redundant.

    Verizon redefines the standard to match...

  • RE: "NOT IN" Operator and Three Valued Logic

    Jamie-2229 (12/28/2014)


    Tom,

    Mostly, by way of English language flow. It is simple to say "Show me the stuff that isn't there or show me what you've got IN there." ...

  • RE: "NOT IN" Operator and Three Valued Logic

    Jamie-2229 (12/26/2014)


    In my experience, MICROSOFT SQL SERVER application for NOT IN and IN is rarely applied the way it is intended.

    This is what is so odd about what you...

  • RE: "NOT IN" Operator and Three Valued Logic

    Hugo Kornelis (12/26/2014)


    Jamie-2229 (12/26/2014)


    Yep, you're right. So if you are using an "IN" or a "NOT IN" statement, not only is it faster to join than use "IN" or...

  • RE: "NOT IN" Operator and Three Valued Logic

    Jamie-2229 (12/26/2014)


    Yep, you're right. <deleted incomprehensible data />... They are ugly.

    Jamie - What are you even talking about? The IN and NOT IN operator have been around for 20+...

  • RE: NO COUNT

    The importance of SET NOCOUNT ON in the all the user defined SPs is very important to get good performance.

    False: If SET NOCOUNT ON is executed inside of...

  • RE: SSRS - Report for Stored Procedure with Multiple Values Passed

    g.britton (12/9/2014)


    Since SSRS just passes a comma-delimited string, I write my query like this:

    select ...

    from ...

    where column in (@var)

    and either:

    1. put the base query in a view or TVF and...

  • RE: SSRS - Report for Stored Procedure with Multiple Values Passed

    Nice simple article that covers ways to resolve what can be a very frustrating issue with SSRS.

    Many developers and DBA's alike have a difficult time understanding the difference between passing...

  • RE: In The Beginning

    Brian.Klinect (11/25/2014)


    That's exactly what I did. I had no idea I could use a negative number for a datetime!

    Since DateTime is stored as an Integer, it only makes sense...

Viewing 15 posts - 136 through 150 (of 380 total)