> All SQL Server DBA's and developers need to learn about .net...or get left behind.

Okay, I'll bite. There are a couple of posts in this thread urging me and...

My $0.02 worth...

Kalen Delaney, in _Inside SQL Server 2000_, recommends that all development environments be case-sensitive, and all end-user environments be case-insensitive. Her view is that anything that will...

If I understand the problem correctly, you could consider an alternative approach: Use a trigger to populate another table for each row that needs to be shipped.

I've actually seen...

The following ought to be reasonably close. I don't have access to an Oracle parser, so it is probably not perfect.

The FULL OUTER JOIN criterion, I hope, is addressed...

It's been a while, but I may be able to offer some general remarks...

In Oracle, if I recall correctly, you can't explicitly define JOINs. In the FROM clause, you...

> For now one ;oint I'd like to address is that it's not my intent or style to be arrogant to developers....

Fair enough. I didn't know how to take...

Hi, Warnat!

> At least there are other DBA's who could enter data (but would not).

Not here. There be me, and that be all.

D> I think the main topic was...

> Hi Lee Dise,

Hi, Warnat!

> it seems quite obviously, that your projects will never grow into the market...

That's precisely the point: Not all products that are created on SQL...

Andy:> “So, let's talk about another worst practice - not putting a primary key on EVERY table and failing to use a clustered key on EVERY table.”

That’s a bold statement....

Kudos for the originality and efficiency. However, very respectfully, from a design perspective, I do not share an enthusiasm for such schemes for the following reasons:

1. Like a...

I had already noticed this behavior, and do not agree that it should be considered a bug.

Consider the way SQL Server "AFTER" triggers and ROLLBACK work: the trigger fires...

The only time you absolutely need to use dynamic SQL is when, at compile time, you do not know the names of the database or the database objects against which...

You just might be a DBA if...

-- Programmers hate you.

-- The system/network admin guys hate you.

-- Your bosses don't understand what it is you do.

-- You spend so much time...

It is said that school teaches you how things should be done but not necessarily how they are done, and experience teaches you how things are done but not necessarily...

I use maintenance plans. But my pet peeve is any software that, when something breaks, provides little in the way of meaningful feedback about the cause. (As an...