Hi Juanita,

First of all, you are correct that the SQL EM will not let people do anything that they don't already have permission to do.  But I'm afraid that you...

EB24,

This community is pro-SQL Server, but that does not mean we are necessarily anti-Oracle.  Well, not exactly anyway.  I think this (along with the extremely open-ended nature of your question)...

Well, in this case there is so little IO that the query cost of the parallelized version is going to be unusually impacted by the query optimization phase, and also...

I *think* I've seen PKM referred to by Microsoft as "Publishing and Knowledge Management," or something similar to that, and that MSSearch is part of Microsoft's PKM initiative.  So I...

Hi John,

Newbie or no, you are correct: you need those check constraints.  But if you looke further back in this thread you'll see that we've discussed that a bit already. ...

If I understand what you're trying to do, you might want something like this (wherever I put "etc" it's because I assume you may have other attributes you need to...

No, I don't think that's right.  Sorry...

Well, that's interesting news!  Toad has a very loyal following among the Oracle crowd - I'll have to check this out. 

Thanks for the info!

Any chance you could post a jpeg of that query plan?  Or is it too big?

Thanks,

Chris

Scott,

Have you considered putting some kind of tracer in the beginning of the trigger, before the exec statement, just to make sure that the trigger is not firing?  You could...

Are you sure you meet all the requirements for the "smart" partitioned views?  Specifically, I'm talking about rules like:

• the view must be UNION ALL (not UNION)
• the partitioning column must...

As for the claims that "all corporate consumers use RAID 5" or something similar ... that's just bunk.  I have worked at places where the sysadmins would refuse to run...

RAID 1 provides fault tolerance and generally improves read performance (but may degrade write performance).

Well, whoever put that in BOL needed to clarify what they were trying...

Yes, RAID 10/01/1+0/0+1/SAN/etc. would be nice, but of the choices given ... RAID 5 advocates need to remember that the log needs to do flat-out writes as fast as possible. ...

Chuffed?  Is that like "cheerfully fluffed?"