Ninja's_RGR'us (7/19/2011)

---

Wow Jeff must make a nice santa in real life...

There's someone you all know that deserves your vote here[/url].

I'm sure you know who I'm talking about. 😉

:-D:hehe::-D:hehe::-D:hehe::-D:hehe:

Thanks Jon, very funny!

You're welcome.

You should thank Adam instead of me! 🙂

On what?

The registration fee for SQLServerCentral? OK, done. 😀

The points for the question? You got it by posting your refund request. 😎

Yes, you just have to connect as sysadmin and change that setting in the server properties dialog, under the "Security" applet.

You can also change it in the registry, but I...

Ah, got it!

Is this a duplicate of this post?

Here he goes again.

I didn't notice it from the start.

Funny. 🙂

ALZDBA (7/13/2011)

---

Koen Verbeeck (7/13/2011)

---

I handed him "a" solution. And that he doesn't complain, he got *exactly* what he asked...

Sure! No problem.

But we need something more than a screenshot in order to help you.

Take a look at this article[/url] and you will learn how to post a question effectively.

Crystal ball needed here. I forgot mine at home. 😀

Looks like your question got trimmed.

Can you post it again?

Unfortunately no.

But if you study and learn the subject well enough you won't have to memorize interview questions.

sp_MsForEachDB is an option, though undocumented and sometimes unreliable. A cursor is...

kramaswamy (7/12/2011)

---

I'd bet your biggest issue with this query is simply that there is a large amount of data present, and no indexes to handle them.

Create an index with username,...