pdanes

Forum Replies Created

Viewing 15 posts - 406 through 420 (of 458 total)

RE: Disk configuration

TheSQLGuru (6/25/2012)
With a 100MB database and a few users - who cares?
Well, I do, and such a low workload also makes it a good time to experiment, and learn how...

June 25, 2012 at 10:24 am

#1505153
RE: Disk configuration

TheSQLGuru (6/25/2012)
Personally with that config I would go with 2-disk RAID1 for C drive and 4-disk RAID10 for D drive. You will need to use the C drive for...

June 25, 2012 at 8:31 am

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

GilaMonster (6/8/2012)
I'm not irked.
Oh, good - sometimes it's hard to tell via only text.
Play around with that setup (as simple as possible) and see if you can get your head...

June 10, 2012 at 10:32 am

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

GilaMonster (6/8/2012)
Sorry, but what did you want me to say? That one is faster than the other? That one is better than the other?
No apologies necessary. As I wrote, I...

June 8, 2012 at 5:25 am

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

GilaMonster (6/8/2012)
They are two logically different queries that in this case just happen to produce the same result. That's why you get different query plans, because to SQL those two...

June 8, 2012 at 4:49 am

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

GilaMonster (6/5/2012)
Hi Gail, sorry for the delay in responding, I had some fires to put out, and I wanted think about what I needed, and construct an example to help...

June 8, 2012 at 3:23 am

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

GilaMonster (6/5/2012)
It has nothing whatsoever to do with performance. The meaning of the two queries is different. That's why you're getting different execution plans.
But Gail, they both produce EXACTLY the...

June 5, 2012 at 4:53 am

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

pdanes (6/4/2012)
Well, I've advanced some, at least to a higher state of confusion. It certainly appears that the subquery syntax (#3) was unnecessarily complicated and brought no improvements - the...

June 5, 2012 at 3:41 am

#1496945
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

Viewing 15 posts - 406 through 420 (of 458 total)