What is the best way to beat writer's block? Anybody have any ideas? I am half way through an article and now I cant seem to complete it. Damn..!!!!:angry:

Well, let us look at a scenario where there is a clustered index on column A. The table has 30 columns. If you have a query that selects just 3...

Ah.. Now I know what you mean.. I reread it and figured it out. But these are not so common cases...Right?

Wayne, The OP is talking about having a clustered and a non clustered on the same column....

SQL Service and Agent Service has to run under a domain account. Check if that is the case in your set up

I have never heard of anyone recommending to have both clustered and non clustered on the same column. This is the first time.

The red fox has left the chicken coop.....

Time to run wild... 😀

Does this server have only SQL Server in it or are you using that same server for other purposes? When booting up, are there lots of things done on start...

Check sp_replshowcmds on BOL. It should help you

Shrinking log file is a bad option.

Make sure you have regular transactional Log back ups. From what I see in your message, there are still some commands that needs...

Did you check the event log to see why it did not start? That is the first step to find out why a service did not start up.

When you have Bulk Inserts/Updates there will always be latency. But it should not be up in the sky. Your distributor is running on its on server? How is your...

Big Brother is always watching you... 🙂

First a warning. This could back fire on you if you delete it completely of your production DB.

But this can be achieved. You can set up transactional replication between...

You cannot use IPAddress for setting up subscriber. You could do something like creating a host file in your Publisher that will help resolve this issue. This is a temporary...