The article describes a way of managing multiple package configurations easily, it assumes...

Mike DiRenzo (6/3/2009)

---

I wonder how tough of a "sell" it was to your peers and management. This is ALWAYS where the rubber meets the pavement...delivery of the concept is...

Andy Leonard (6/3/2009)

---

How would you apply this to environments with firewalls between application tiers? I've used a two-step approach with an environment variable that points to a configuration database for...

We now now a unique constraint won't work for the Customer table - they're all named John. :w00t:

Identity columns are not necessarily unique. If you never reseed the identity sequence, and never use...

Sorry, the first step is not to stop the server since it is already down due to the missing tempdb drive.

Also, the normal way to move tempdb (on a running...

Look up "Moving System Databases" in Books Online. Here's the simple version, assuming your SQL Server is the default instance and not a named instance.

In a command window, stop...

Krishna Potlakayala (5/21/2009)

Are you sure you can take a differential backup once the tlog has been truncated- (which means you have broken the log chain)- once truncated only possible backup...

Running DBCC SHRINKFILE is not the same as truncating the log. The command to truncate the log is BACKUP LOG ... WITH TRUNCATE_ONLY, and you should not use it....

HumanResources is the schema, so all queries were correctly qualified. The question specifically states that the database is AdventureWorks.

Many of the tools you can't afford have free trial versions available that you could use for a one-time job. Sometimes they are impressive enough that the beancounters can...

In a situation where management requires you to handle huge transactions, but refuses to buy the hardware to deal with it, even in the face of log truncations and server...

I haven't used DTS in a while, but I believe you can do a lookup on a separate connection in a data pump task to accomplish a join.

You're posting in...

How many connections do you normally see on this server? If connection pooling is working, the IIS server should require a relatively small number of connections. An overwhelming...

It sounds like you want to pick the single best address for each entity, using the isMailing and isShipping fields to define "best" (with preference given to isMailing). All...