Forum Replies Created

Viewing 15 posts - 2,761 through 2,775 (of 5,502 total)

  • RE: Service broker security concern

    From my point of view there is no issue regarding Service Broker security.

    The security hole is your SELECT permission on the target table. The only difference between a scheduled job...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 27, 2010 at 2:49 pm

    #1228028

  • RE: Deadlock Issues using OpenXML

    [Disclaimer ON] I'm not a guru. [Disclaimer OFF]

    Based on my experience OpenXML is nothing special being the root cause of a deadlock compared to any other method of dealing with...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 27, 2010 at 2:38 pm

    #1228017

  • RE: How do I sent text messages from SQL?

    Steve Jones - Editor (9/27/2010)

    I do it as Lowell does it, email to the SMS number for the person.

    One thing to note, SMS is guaranteed. And might not be delivered,...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 27, 2010 at 2:20 pm

    #1228000

  • RE: Sql View - Performance Tuning

    I focused on the execution plan of the view:

    Since there is no index for the trip table starting with create_date you end up with an index scan that fits best...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 27, 2010 at 2:06 pm

    #1227984

  • RE: Queries running slow

    I don't think killing processes is the right approach here or in most other scenarios.

    What processes do you usually kill and what status those are at?

    You should run profiler to...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 27, 2010 at 10:45 am

    #1227817

  • RE: How do I sent text messages from SQL?

    If you're talking about sending an email using SQL Server you might want to look up sp_send_dbmail in BOL.

    If your system is not configured yet to send mails, you should...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 27, 2010 at 10:35 am

    #1227815

  • RE: Sql View - Performance Tuning

    Ouch!! You'd better stop that query....

    I was hoping to prea-aggregate AdvStats and reduce the size of that part of your query.

    But, unfortunately, it seems like it won't help at all...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 26, 2010 at 10:54 am

    #1227469

  • RE: t-sql Date Problem

    As per ISO, week of August 9th 2010 is week 32.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 26, 2010 at 10:27 am

    #1227466

  • RE: t-sql Date Problem

    ALZDBA (9/26/2010)

    There may be a difference between microsoft week and iso week !...

    Ther definitely is a difference:

    The "old-fashioned" week function will calculate the weeks starting with week 1 for the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 26, 2010 at 7:36 am

    #1227454

  • RE: Return Parent Level entry using cte

    I added the top level name as an addtl. column (Level1Name) and moved the calculation to the final select (therewith removing the cte1 subquery).

    ;WITH cte

    AS

    (

    SELECT id,Name,parentid,levelid,...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 26, 2010 at 5:33 am

    #1227446

  • RE: Sql View - Performance Tuning

    Ugghhh!!! Those are quite heavy tables...

    I think the major issue is the join between the 500 mill table to the 50mill table and performing an aggregation afterwards.

    The CROSS JOIN is...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 26, 2010 at 5:03 am

    #1227444

  • RE: Deny network access to a named instance

    Lowell (9/25/2010)

    inm ot a network guy, but maybe you can configure the server so only certain machines/ip ranges can access the ports for the sql server?

    i think you can do...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 25, 2010 at 5:43 am

    #1227371

  • RE: Parse data in field???

    Lowell (9/25/2010)

    there is a built in function PARSENAME that can help do this, but it only will help if your data has three periods in it.

    the function is usually used...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 25, 2010 at 2:47 am

    #1227347

  • RE: Parse data in field???

    You could use a split string fuction (search for "DelimitedSplit8k" on this site for a T-SQL solution).


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 25, 2010 at 2:36 am

    #1227344

  • RE: new line character

    You could add char(10) +char(13) (CR/LF) after each CASE part.

    However, SSMS will not display it correctly in grid mode, only in text mode. I'm not sure what tool you'll...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    September 25, 2010 at 2:27 am

    #1227341

Viewing 15 posts - 2,761 through 2,775 (of 5,502 total)