Forum Replies Created

Viewing 15 posts - 76 through 90 (of 428 total)

  • RE: Stairway to XML: Level 7 - Updating Data in an XML Instance

    I haven't read your entire series yet (though I certainly intend to do so) but while scanning through this level it struck me you that you are referring to typed...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    November 13, 2012 at 4:01 am

    #1558432

  • RE: Service broker filling up Tempdb

    Bobby Glover (10/29/2012)

    Can two service broker queues use the same contract.

    It's services that you connect a contract to, not the queue. When you have a conversation between 2 services in...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    November 5, 2012 at 4:26 am

    #1555959

  • RE: How does a C# CLR trigger know the table it was called for?

    An extensive search on the internet has revealed that the functionality I need (getting the parent object that was affected by the action that the trigger fired for) is not...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    October 23, 2012 at 2:49 am

    #1551785

  • RE: How does a C# CLR trigger know the table it was called for?

    Calling a CLR procedure passing in the @@procid from a T-SQL trigger works. But, if I do this, I don't have access to the SqlTriggerContext object inside the CLR code...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    October 22, 2012 at 3:40 am

    #1551283

  • RE: How does a C# CLR trigger know the table it was called for?

    Jeff Moden (10/21/2012)

    Ahhhh... getting back to the original subject of how to get the table name... I found an interesting bit of code that Remi suggested at the following URL....


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    October 21, 2012 at 1:18 pm

    #1551184

  • RE: How does a C# CLR trigger know the table it was called for?

    Jeff Moden (10/21/2012)

    Gosh, thanks for the extensive writeup. Unfortunately, the only way I've seen to get the table name through a CLR trigger is a nasty hack that uses...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    October 21, 2012 at 1:03 pm

    #1551182

  • RE: How does a C# CLR trigger know the table it was called for?

    We currently do have generated T-SQL auditing triggers. Each trigger gets generated by a stored procedure. These triggers generate an xml file from the inserted & deleted tables and send...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    October 21, 2012 at 2:20 am

    #1551139

  • RE: WMIEventProviderNotificationQueue

    First off, I do not have any experience with WMIEventProviderNotifications, but I have worked a lot with Service Broker, so I may be totally off, but I think I can...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    October 3, 2012 at 6:08 am

    #1544839

  • RE: Monitoring date specific changes

    You've probably over simplified your example table, as I don't see an account column in it. I would expect a bookings table to have an account column in it, to...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    September 19, 2012 at 6:13 am

    #1539502

  • RE: Delay in Asynchronous Procedure Calls

    For those trying to duplicate this experiment, for example to learn some Service broker basics from it, here is the same experimental code with documented improvements in it:

    create database t2

    go

    use...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    September 19, 2012 at 1:47 am

    #1539416

  • RE: Delay in Asynchronous Procedure Calls

    Your async handler routine should not exit after each message: Service broker expects its handlers to continue processing messages for as long as there are more messages available. As you...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    September 18, 2012 at 8:03 am

    #1539112

  • RE: How to grab characters before and after a string

    Phil Parkin (8/15/2012)

    ....

    select [Room / Shelf]

    ,left([Room / Shelf], charindex('/', [Room / Shelf]) - 1)

    ,right([Room / Shelf], len([Room / Shelf]) - charindex('/', [Room / Shelf]))

    From ChemInventory

    Where [Room...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 17, 2012 at 2:08 am

    #1526945

  • RE: find max

    Also, use proper types for your columns. Numeric values -like a salary- should not be entered as strings. If you store them as strings the values may not sort as...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 17, 2012 at 1:22 am

    #1526926

  • RE: comma separate value show as table

    BrainDonor (8/16/2012)

    The easiest way is probably to use the CSV Splitter function, by Jeff Moden (with some assistance from others) - http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    The splitter function will return 3 rows per input...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 16, 2012 at 2:00 am

    #1526371

  • RE: end conversation gets blocked by process with request_id 0?

    I have not found more information why this happened, but after a restart of the sql server the lock that was held already for almost 14 days was released and...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 16, 2012 at 1:40 am

    #1526355

Viewing 15 posts - 76 through 90 (of 428 total)