yes

I see what you mean but a 40 min job will run 36 times a day so if you have the first run at 00:40 the last run would be...

I have my own monitoring for this so don't have the mdw turned on to compare. I think these are cumulative waits and to be blunt the info is pretty...

do you mean you want to update the primary key column which is used as a FK in other tables?

aha -- not a simple answer as it just depends. If you start making distributed queries across servers you have to get the indexing and queries absolutley right to avoid...

you need to try to generate different values for each row - or at least in the columns which are important. At best you need data representative of actual...

As George says just because 2008 is in the name the versions are different. I really don't like this R2 stuff as it's not the same, if you use windows...

I'm not dismissing sql io or iometer but be wary of results. There's nothing quite like backups and restores + some hefty sql code to really sort out differences. I...

DBAs really need to work with Storage guys, it'll save so much time and money. I'm lucky that I've been able to work with storage and as I got a...

It isn't that simple - I've been doing this type of stuff for over 12 years with SQL Server, since 7.0.

Here's a doc I wrote about partitioning - it was...

yup no DBA is the way to go - funny I always seem to end up in contracts with companies who thought that way! On the plus side it enables...

SQL 2008 R2 is a later version that SQL 2008. If you have the choice I'd always go for the latest version, SQL 2008 R2.

yup that'd do it - missmatched sids the issue you have to resolve with log shipping and standby servers!

yes if you add a user or an ad group you can't set the default database unless you've added the user to that database.

so add your domain user group...

You don't say what sort of storage you have or how you think you have a problem - what appear to be io problems can actually manifest in many different...