You sql string should include a parameter marker

set @sql = @sql + ' AND b.LocationID=@LocationID' etc

That way sp_executesql will cache the appropriate query plan.

Depends on the license that has been bought and the hardware and OS you want to install it on.

If you have the Enterprise license then use the Enterprise edition.

If you...

If there are a discreet set of designs and a discreet set of sales reps then you need a separate mapping table with a combined primary key of LogoDesignID and...

This sounds like a strange approach.

Are you trying to back up on one server and restore on another?

I would use a batch file that runs SQLCMD to do each task...

So you have one distributor but how many distribution databases do you have?

I ran into a problem where the distributor didn't look like it was stressed but the outstanding transactions...

create PROCEDURE [dbo].[usp_Dynamic]

@location_id int = NULL

...

sp_tableoption...

Personally I believe that VARCHAR(MAX) is a datatype of last resort.

To give an extreme example the longest possible telephone number is 15 digits so allowing for formatting I allow VARCHAR(20)....

If you have one publisher then multiple distribution databases won't do you any good because a publisher is associated with one distributor.

MySQL is great for one master, multiple slaves.:hehe:

We did...

Was it described as software that could query mixed datasources in situ?

To me it sounds like some form of ETL system that can merge data from several systems into a...

My first exposure to agile lead me to think of it as the bodge it and wing it methodology. It fundamentally isn't. It isn't even a methodology, it...

The thing that impresses me most about MySQL are the MySQL tech staff. These are a bunch of guys I consider myself privileged to have worked with.

The trainers were...

I would be surprised if it was the FKs that made the difference. I suspect it was the clustered keys primary or otherwise.

I have run into this problem on...

I've just been reading "The Mythical Man Month" by Fred Brooks. Some people think his book is brilliant other people deride it with comments such as "it taught me...

For me the most important thing about "agile" is that it emphasise communication and that the best communication is face to face.

Short itterations mean that developers and business people get...