Blah, what haven't you written?

Apparently I've had too many bad things taught to me.

I could swear that I've had performance differences between them, but that would have been at least...

EXISTS vs IN

NOT EXISTS vs NOT IN

Not...

GilaMonster (8/22/2012)

---

No it doesn't.

http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/

General conclusion: In is a very slight...

jshahan (8/22/2012)

---

if @ProviderCount >0

set @SqlString3 = @SqlString3 + N' and dbo.Enrollment.ProviderKey in (select id from #Provider)'

Above is an example of how we typically use dynamic SQL. I'm not an...

a2zwd (8/22/2012)

---

Hi

I am retrieving just MonthYear, TotalSales from the query.

I want to show MonthYear on X-axis and TotalSales on Y-axis. I dragged the columns(MonthYear in CategoryGroup and TotalSales...

I've done too much with Kerberos....I was glad that I remembered this.

Kerberos authentication is my preference because once it works, SQL authentication stops being a "why the hell can't it...

There were 0 files in the directory. Existing files were set to true.

I've just run into one thing with it... I figure I'll ask you before I go to Darren.

I left a process with the filewatcher watching a remote share

\\server\share

We copied 2000+...

I would expect it to.

1 + '130' = 131 ('130' converted to...

Thanks,

The Konesans' task is just what I needed.

Normally I'm pretty nervous about 3rd party plugins for SSIS, but this is the right tool for the right task in this...

I'm working with this.... I have a question

So I'm trying to watch for new files... when I see one I kick into a For Each Loop Container that processes as...

Hugo Kornelis (8/16/2012)

---

Actually, this is not a...

honza.mf (8/15/2012)

---

+1

And even worse the answer...

sestell1 (8/15/2012)

---

Nice question. This trips up a lot of people new to SQL and seems to lead to a lot of negative feelings towards NULL values.

(NULLs aren't bad, they're...

I'm in the boat with Anthony here.

Not to mention if you're log shipping, that the database has to be in Standby mode, and will kick the users out every time...