A more thorough description of the problem you are trying to solve might get you more precise help.

Lowell!

DDL trigger. log it to a table.

Cheers!

it can't be done in the GUI but SQL Server supports it

exec sp_addrolemember 'mygroup','groupToAddToMyGroup';

There are advantages to using roles, because sometimes you need to add multiple existing AD groups into...

Pretty sure you need to stick with full recovery for mirroring, Seth.

You also don't need to set the recovery model to simple for using dbcc shrinkfile.

In your script below you...

Performance could be less than expected, 8GB isn't a lot of memory for a SQL Server.

SQL Server uses ~512MB of OS memory is for each SQL instance on a typical...

select * from msdb..sysjobs

will tell you the last time the job was modified.

If it was truly enabled (from a disabled state) the date it was enabled will be stored here.

You...

It may be nothing at all...

Try getting your average time by dividing the

total_worker_time / (execution_count *1.0)

I multiply by 1.0 to implicit cast to a float so you get more...

I'll provide the rough syntax for selecting out the information you want and leave it to you to pick up the pieces. I don't know if it will run...

I think you need to pull apart the company information and the import information into 2 different tables.

you would then link the campaign to the company and the import.

anyway, you...

id is a surrogate key, not a natural key.

the natural key is the one (or more) columns that make a row unique.

a surrogate key is a unique idenifier appended to...

Tell me what your natural key is for the prospects table. Is it just company?

you can use a CTE with the row_number() function to identify the ID of oneof the duplicate records and join that CTE with whatever you want to do the updates...

I think it comes down to management recognizing issues within their...

Jeff Torres (6/3/2011)

I have enjoyed reading the articles you submitted. I have read all four of the articles you posted on SSC and I would like to encourage you to...

This is a very well thought out article and well-written.

But I'm with stevemash here. You don't address locking at all in your article which is a big issue for...