Forum Replies Created

Viewing 15 posts - 136 through 150 (of 381 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...

    February 2, 2015 at 2:25 pm

    #1774892

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

    February 2, 2015 at 1:56 pm

    #1774883

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

    January 26, 2015 at 9:25 am

    #1773155

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

    January 26, 2015 at 8:04 am

    #1773121

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

    January 23, 2015 at 11:01 am

    #1772758

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

    January 8, 2015 at 8:14 am

    #1768787

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

    January 8, 2015 at 6:45 am

    #1768771

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

    December 29, 2014 at 7:25 am

    #1766764

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

    December 26, 2014 at 8:58 am

    #1766476

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

    December 26, 2014 at 7:27 am

    #1766466

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

    December 26, 2014 at 7:26 am

    #1766465

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

    December 12, 2014 at 1:45 pm

    #1764568

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

    December 9, 2014 at 3:00 pm

    #1763667

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

    December 9, 2014 at 7:35 am

    #1763524

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

    November 25, 2014 at 8:12 am

    #1760826

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