Forum Replies Created

Viewing 15 posts - 91 through 105 (of 5,502 total)

  • RE: How to prevent database access

    When you refer to a new fature of SQL2014 you might refer to the new server level permission "CONNECT ANY DATABASE" in combination with "VIEW SERVER STATE" and "DENY SELECT...


    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]

    August 13, 2014 at 4:27 pm

    #1737851

  • RE: SQL Query question

    You'll need to perform a second join to the members table:

    select t.*, m1.lastname, m1.firstname, m2.lastname, m2.firstname

    from tickets t

    LEFT OUTER JOIN members m1 ON t.assigned_to = m1.member_id

    LEFT OUTER JOIN...


    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]

    August 13, 2014 at 10:44 am

    #1737701

  • RE: Are the posted questions getting worse?

    TomThomson (8/13/2014)

    I wish I could give you some of ours. I'm beginning to dislike English summers nearly as much as I disliked English winters in the bad old days...


    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]

    August 13, 2014 at 9:59 am

    #1737680

  • RE: Are the posted questions getting worse?

    Evil Kraig F (8/12/2014)

    More than a few reasons why the top of the hills were considered the best real estate way back when. I'm glad to hear everyone so...


    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]

    August 12, 2014 at 2:09 pm

    #1737345

  • RE: Career future , stay or switch

    With 70$/hr you're talking about roughly 140k/yr if you're a full time employee...

    If that's your current situation, then the only alternative would be consulting.

    Yes, you could make more per hour...


    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]

    August 12, 2014 at 12:31 pm

    #1737314

  • RE: Pythian is hiring! - Expert-level SQL Server Database Consultant

    nah - they probably want somebody to do both.

    If that's the case, why isn't Oracle listed as a required qualification?

    Or do you mean they're asking for a SQL Server expert...


    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]

    August 12, 2014 at 10:28 am

    #1737289

  • RE: Pythian is hiring! - Expert-level SQL Server Database Consultant

    That's weird:

    RESPONSIBILITES:

    Provide support to external clients on all aspects of Oracle Database Management, including but not limited to:...

    and

    QUALIFICATIONS: Highly experienced in Database design and Administration performing the following:

    • Expert knowledge...


    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]

    August 12, 2014 at 10:20 am

    #1737285

  • RE: group by tally vs triggers

    Not enough information.

    What do you mean by "tallied"?

    Any sample data (table def, sample data and expected result) available to demonstrate what you're looking for?

    Based on your -rather vague- description I...


    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]

    August 11, 2014 at 5:18 pm

    #1737074

  • RE: Need help with building a view

    What are you trying to accomplish here?

    It looks like you return the running total balance per month an fiscal year.

    Why would you worry about this FY having less than 12...


    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]

    August 11, 2014 at 4:11 pm

    #1737067

  • RE: cannot find database

    Does the user "james" has the permission to connect to database "data"?

    Or how do you handle the connection between the two databases (users and data)?


    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]

    August 11, 2014 at 3:41 pm

    #1737062

  • RE: How can I hide a picture's watermark in Reporting Services? Can I a second image? Please, help!!

    For example, let's say I want to hide the "Microsoft's watermark" in this picture, can I use a second image?

    Yes, you can use a second image: one that is officially...


    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]

    August 11, 2014 at 11:06 am

    #1736958

  • RE: using select union all using multiple databases

    You can't create views across database using the syntax you're thinking of.

    Instead you could create a view on each database and use that in your view:

    create view view1 as

    use

    select...


    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]

    August 11, 2014 at 10:43 am

    #1736941

  • RE: Are the posted questions getting worse?

    To expand on Lynns idea:

    It might be an additional "feature" to set a minimum number of forum posts before being allowed to flag a thread.

    While I do trust each of...


    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]

    August 11, 2014 at 7:21 am

    #1736847

  • RE: Troubleshooting\Tuning sql query taking more than 40 secs

    Sometimes it's essential to know what the application will do with the data.

    Let's just assume a scenario where they would just filter out 10% of the data and throw 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]

    August 11, 2014 at 5:22 am

    #1736793

  • RE: Troubleshooting\Tuning sql query taking more than 40 secs

    In your very first post you mentioned the result is used by people looking at it.

    It's rather unusual to present 280k rows to a user...

    So I need to ask: what...


    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]

    August 11, 2014 at 4:40 am

    #1736772

Viewing 15 posts - 91 through 105 (of 5,502 total)