Personally I liked the original code name "Gemini".

When IT doesn't support the business those non-IT parts of the business that are computer savvy design and build their own tools an...

One of the problems I found when switching to agile development practises was getting the non DB development team to accept architectural principles from the DB perspective.

The good architects tend...

As far as I am concerned encryption and data security should be present in all editions.

I can understand the lesser editions having limits on CPU and RAM they can use.

I...

robert.goudie-497430 (12/18/2009)

BTW we still use DTS - despite having several books at work on SSIS that our key people have read at one point or another.

Thus far we have found...

The article was mainly about standard edition.

The killer feature for enterprise users is the ability to switch partitions on replicated tables. This means that with careful design the purge...

http://www.sqlservercentral.com/articles/Files+and+Filegroups/65538/

The point has been made that many DBAs know these procs and have used them for years.

Great, so why doesn't Microsoft include them in BOL?

They are stable and have survived...

Worth buying developer edition. All the features of enterprise edition but for the price...

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...