I would think, in that case, that a powerful enough server could keep up with it. Have you tried load-testing to see what kind of hardware load that will...

Either he stole that one from Groucho Marx, or...

Mangal9i (3/6/2009)

---

People will call me rude if I don't reply you.

You talked about Global Cursor, I don't like them, I never wrote a single cursor in my life.

Why I...

I most certainly am surprised. You have top-notch credentials. Doesn't get better than "Most Valuable Player", which is what "MVP"...

Yes. Personal aesthetic preferences are purely subjective. I like chocolate. Even if you don't, that makes neither...

I'm not sure what your Planners group has as rights and such. If it's part of the system administrators group, all logins in it will show as "dbo".

Mangal, my comment WAS about "technical stuff". It was about costs in execution plans. I'm sorry if you don't think that's technical.

I have to ask: Why would you...

You're welcome.

Since saints are, by definition, dead, I'm certainly glad to hear that! 🙂

Once hear/read/saw in a movie (don't...

It has to do the sort to do the union and dedupe. That's part of how it does that.

create table dbo.Numbers (

Number int primary key);

go

insert into dbo.Numbers (Number)

select top 10000 row_number() over (order by t1.object_id)

from sys.all_objects t1

cross join sys.all_objects t2;

You'll find a lot of references, on this page...

tosscrosby (3/6/2009)

---

http://www.sqlservercentral.com/Forums/Topic668871-338-2.aspx#bm669990

Good one G. I don't like to kick...

We probably need to keep in mind that "MVP" != "Highly knowledgable about T-SQL". I don't know what the selection criteria are, but it could just be that he...

That means there's only one row that has one of those extensions. The other two don't exist in the table.

Try this and see if it gets anything:

select *

from person

Where...

Current_User will work if not all the users are part of the sysadmin group. That group returns as dbo. That's by design (since it's what sa/dbo really means).

You...