Hey G, how about cross-server service broker queues?

CEWII

With a previous employer when we were working on a major project we would often schedule a conference or "war room" for a period. We would bring most of...

Bob,

SQL uses what it feels it needs to. I used to have a process that ran all by itself on a SQL Server and that even though there was...

I walked through this thread and have to agree that a trigger to do this is a particularly bad design choice. Now I know you said that this is...

wow, old thread, glad to be of help.

CEWII

Actually, I hadn't thought of that either.. I'll have to look at that.. Interesting..

CEWII

LutzM (7/22/2011)

---

I don't think we really disagree here, Elliott.

However, I would not compare a decision between SQL and .NET with a decision between Oracle and SQL Server.

To summarize it: "It...

LutzM (7/21/2011)

---

I'm not sure if it's a "short sighted" position:

I'll have to deal with arguments like the number of viruses available to attack the systems and the risk/additional effort involved...

How many records are we talking about here?

You certainly can do this row by row, however that method of processing is substantially slower than a set based solution. Also...

The doc you are looking for is:

How to configure volume mount points on a Microsoft Cluster Server

http://support.microsoft.com/kb/280297

CEWII

I don't think you can use a parameter like that directly. I think the parameter substitution is limited to the where clause. I have gotten around that in...

I often overcome the windows problem with the sheer cost savings, but it usually hasn't been a problem in my environments.

In environments where very few windows servers this might be...

Those are the rough storage costs yes. If you are going to have a lot of files especially in the 40MB range you will very quickly have a very...

Thanks.

CEWII

Brandie Tarvin (7/21/2011)

---

Logic is definitely the problem here. NULL means Unknown. It doesn't equal anything. So if both @B1 and @B2 are capable of being NULL, then you CANNOT use...