carloparcon (2/3/2010)

---

hello there, im not familiar with sql so please help me

our server is windows server 2008 standard edition, 4gb ram, 2x250gb hdd raid

with sql server 2005

the problem is,

after...

Uh sure, if getting a mostly illusory sense of data security...

kraaitje (2/3/2010)

---

Thanks Barry, great function. I use it when generating procedures using dynamic SQL to view the output. Normally, I use PRINT @sql but the @sql variable is more then...

You need dynamic SQL to do this.

Yes, basically. Each sector will only deliver a...

thanks, dave!

Heh. Yeah, that's why I wrote it. This question is like #5 or 6 on the hit list... 🙂

daxonic33 (1/19/2010)

---

Hi I am currently trying to seek profession in SQL DBA but I have not background in Computer accept just basic knowledge in PC. So Please some one...

Yes, this is one of the long-standing site bugs that I always forget to mention when they ask. You are supposed to be able to use the color-code names,...

Check your Subscribed Threads list. I usually get the best results from that.

Technically, yes, multiple users can "read" the same message, but this trick lacks queuing delivery and synchronization control and is almost certainly not what you want.

If you want "guaranteed multiple...

You do not describe anywhere what the differences and relationships are between a character-class and a job-class. We cannot really answer your question without knowing that.

I good question, but we cannot really help you to answer it without more information. First we need to know a bit about your requirements and specifications, and you...

Jeff Moden (1/16/2010)

---

Heh... maybe I should turn it into an article... the question does come up often enough. That's how my very first article was born... the one on...

If you can post the queries and the before and after query plans, we should be able to tell you what is going wrong.