Write simple queries and ensure that the can use indexes effectively

Create a clustered index that is unlikely to fragment fast.

Create a couple of nonclustered indexes to support frequently run queries.

Without...

To answer any of that I'd need to know what it's deadlocking with. To find that you, you can run profiler and capture the deadlock graph event, or you can...

Mike Baria (7/25/2008)

Sure...but there's the rub...it never got implemented on a production server, yet it's in production. The dev server has other similar projects on it (in production but...

Truncating the log breaks the log chain. Once you're run it, you can't take any more log backups until you take a full or diff backup. They fail with the...

Please don't use all caps. It's the online equivalent of shouting at someone.

Why? Is this for a test or interview?

Sounds like a good plan.

Dynamic SQL is about the best solution for performance for this type of query. Though it does bring its own complexities. Apologies, I was under the impression that you were...

From a look at it, the performance you have is probably the best you're going to get. Between the SELECT * and the complex where clause, you're looking at an...

In general, wider nonclustered indexes are more useful than narrow. You want the indexes to satisfy as much of the where clause of the queries as possible.

Can you post the...

Is one of those full and log backup the DB with the really large log file? If so, the reason that the log has grown to that size if that...

Hmm. Check that the tran log backups really are running. Check that the replication log reader...

Have you considered replication? Yes, there is a small overhead, but you can transfer the data realtime or on demand and you don't have to recreate or change the procedures/views/functions.

Plus,...

Is the database in full recovery mode?

Do you have transaction log backups running?

Do you have replication running?

What is the recovery requirements for this DB in the case of failure? (ie,...

It's used by the replication log reader, to mark that it has read and replicated a set of commands. You can use it if there's problems with replication, but that's...

It's posted in 2 different forums on the same site, posted at the same time. That's what I mean by cross post.

It's been standard internet etiquette since the early...