Forum Replies Created

Viewing 15 posts - 421 through 435 (of 465 total)

  • RE: Query tuning - Left Join vs. Inner Join vs. main table select

    GilaMonster (6/4/2012)

    See the link I posted.

    Sorry, Gail, my display didn't refresh before I posted that reply to Luis. Looking at that now...

    June 4, 2012 at 2:09 pm

    #1496751

  • RE: Query tuning - Left Join vs. Inner Join vs. main table select

    Luis Cazares (6/4/2012)

    Unless there's something else missing in the requirements that you haven't shared with us.

    Yes, there is. As I mentioned in the original post, these queries are extremely simplified...

    June 4, 2012 at 1:56 pm

    #1496739

  • RE: Query tuning - Left Join vs. Inner Join vs. main table select

    GilaMonster (6/4/2012)

    Ok, now I see the difference...

    Sorry, I ran out for some food.

    That's changed the logical meaning of the query. The first query is a left join, the filter is...

    June 4, 2012 at 12:59 pm

    #1496701

  • RE: Limit stored procedure rights

    GilaMonster (5/31/2012)

    Read up on EXECUTE AS.

    Got it - that's exactly what I need. Thanks for the kick in the right direction.

    May 31, 2012 at 7:47 am

    #1495222

  • RE: The User Defined Server Roles in SQL Server 2012

    2008 lets you define custom roles - whats different here, besides the new graphic interface?

    May 31, 2012 at 2:58 am

    #1495062

  • RE: Reuse view?

    GilaMonster (5/28/2012)

    Please, please don't trust those index suggestions. They're made on the basis of a single query and if you follow them blindly without testing or considering the rest of...

    May 28, 2012 at 1:45 pm

    #1493905

  • RE: Reuse view?

    GilaMonster (5/28/2012)

    pdanes (5/28/2012)

    No, it won't, because during simplification (also part of parsing) that query would be further reduced to just...

    You can see that if you run that query and look...

    May 28, 2012 at 12:45 pm

    #1493895

  • RE: Reuse view?

    GilaMonster (5/28/2012)

    The term you're looking for is 'materialise'

    Sorry, sloppy terminology. I do try to use correct wording, but I slipped on this one.

    SQL doesn't materialise views when running queries. Views...

    May 28, 2012 at 9:33 am

    #1493860

  • RE: Reuse view?

    Andy Hyslop (5/28/2012)

    Don't get me wrong we do use views where appropriate I suppose I'm just a little more cautious these days (and maybe a little jaded ;-)) when it...

    May 28, 2012 at 9:14 am

    #1493849

  • RE: Reuse view?

    GilaMonster (5/28/2012)

    pdanes (5/28/2012)

    If I make a special view for each join, listing only the fields needed in that particular case, I will have no excess ballast, but SQL Server will...

    May 28, 2012 at 9:00 am

    #1493839

  • RE: Reuse view?

    Andy Hyslop (5/28/2012)

    so please spare me the 'Post your SQL' spankings

    Not a good way to ask for help or advice!! 😉

    Maybe not, but I often get that in response to...

    May 28, 2012 at 8:19 am

    #1493815

  • RE: General Qestions

    Eugene Elutin (5/24/2012)

    P.S. There is an universal solution to stop queries running forever:

    Ask electrician to connect your server room power supply via your floor light switch, so when the...

    May 28, 2012 at 8:01 am

    #1493801

  • RE: IN versus Equals

    Okay, got it. Thank you both, maybe I was thinking about the error 8623 mentioned on that page. Not a problem in my case, there can never be more...

    May 21, 2012 at 5:14 am

    #1490345

  • RE: IN versus Equals

    According to BOL, an IN clause is the same as the different elements with OR constraints.

    Oh? I didn't know that, and I seem to remember reading that multiple ORs are...

    May 21, 2012 at 3:59 am

    #1490304

  • RE: Time for Your Career

    I sometimes feel like all I'm doing is learning new things. And as soon as I do learn something, it's on to some other project and what I just learned...

    May 13, 2012 at 10:09 am

    #1486865

Viewing 15 posts - 421 through 435 (of 465 total)