Forum Replies Created

Viewing 7 posts - 16 through 23 (of 23 total)

  • RE: Detect duplicate rows - with a twist

    Sure, no problem.

    There is only one table and only a few pertinent columns:

    /****** Object: Table [dbo].[CallDetailRecords] Script Date: 04/27/2009 12:10:02 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_PADDING...

  • RE: Trigger to verify rows exist in *child* table?

    bbaley (1/23/2009)


    Just to beat the dead horse deader.......

    Since we were talking about logic on the application side vs. logic on the db side...

    seems I always end up in some...

  • RE: Trigger to verify rows exist in *child* table?

    bbaley (1/23/2009)


    since you said the application already has logic to try and mitigate it.

    Sorry for the confusion. The application was changed *after* we discovered that invoices were being saved without...

  • RE: Trigger to verify rows exist in *child* table?

    GSquared (1/22/2009)


    "There does not now, nor will there ever, exist a programming language in which it is the least bit hard to write bad programs." - Lawrence Flon

    By the way,...

  • RE: Trigger to verify rows exist in *child* table?

    bbaley (1/22/2009)


    It seems like you answered your own question...

    >>>>The Invoices row is inserted/updated first (it must exist before a InvoiceLines row can be inserted)

    Does that mean you have a foreign...

  • RE: The FILESTREAM Data Type in SQL Server 2008

    Kevin Farlee (9/24/2008)


    We have done extensive perf testing. Generally for blobs under 256K to 1 MB it's quicker to access via TSQL. For larger blobs it's quicker to...

  • RE: The FILESTREAM Data Type in SQL Server 2008

    Nice article, but I have a couple of questions/suggestions:

    1. Are there any tests demonstrating the performance difference between FILESTREAM and traditional VARBINARY(MAX) columns? I've seen mention of varbinary being cumbersome...

Viewing 7 posts - 16 through 23 (of 23 total)