I'd be interested in seeing the performance characteristics of each of the three solutions.

Not to worry, we all know you're pushing for your 10,000th

Jeff, you could save yourself a couple of "REPLACE"'s

select convert(varchar(10), getdate(), 112) + replace(convert(varchar(8), getdate(), 108), ':', '')

You can have log shipping in any edition of SQL Server 2000 and 2005.

For the editions that don't come with it builtin ( which is sometimes more trouble than its...

What features are you specifically looking for in a monitoring product, real-time monitoring, graphs & reports, notifications, etc ... ?

Do you have any sort of budget? Are there in-house skills...

One other thing, if your statements are structured like the one you posted in this thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=387258

Try removing the ROWLOCK hint. Amazingly enough you might find that with an appropriate...

Ok, am I missing something here ... you have a 16 field primary key?? Bearing in mind that the primary key identifies a unique record, surely the id column (which...

Rather than forcing the statement to use an index that is not appropriate. Can you post the index definition and we might be able to see why it's not being...

Must be ultra-high priority

26th July - http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=385309

16th July - http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=382197 ( Jeff - this is the one you contributed to )

And now this post on the 1st August. In that...

Agree with Anders.

You really need to look at some process optimisation.

"PAG: 10:1:45083" will give you the page resource thats being locked. You can use DBCC PAGE to look at whats...

Please don't cross-post. See my reply in the other thread.

You have to have a primary key for transactional replication to work. When you say 'create an "id" column in each table', I presume your thinking of creating an identity...

Please do not cross-post. See my response in the other thread.

If you could provide the DDL for proc_create_fsa_export it would be helpful as well.

Also, you might want to investigate the failed logins for JUnitCustomer. 7 failures in a little over...

Also, presuming 'x', is the only field you're returning, add that field to an index on SubsidairyID, non-clustered or clustered. SQL will prefer that index as it will be able...