Restarting the publisher is not a problem.

Restarting the distributor or subscriber may have an affect depending on how long they are down for.

If they are down for longer than you...

I don't know about it being the "only" way but it is certainly what I use.

I have a reporting server and data is constantly being replicated down to it. ...

Yes, that's the one but it doesn't seem to be present in SQL2005 or VS2005.

I would set up transactional replication to server B syncing every 5 minutes. That way you are not going to get sudden huge spikes in traffic just a series...

I try to avoid string manipulation where possible/practical as it computers work better with numbers. Sometimes string manipulation is a necessary evil.

I worked on a project using VS for database professionals and was initially very impressed. I say inititially because I found that deploying the project to an existing database...

You have FLOOR which rounds down and CEILING which rounds up but it doesn't specify decimal places.

You could do something like

FLOOR(Value *100)/100

Depending on what you are doing with your rounded...

Steve,

Your previous feedback is something useful that I can do something with. The situation I am in is that I am trying to move towards agile development but I'm...

Thanks as ever for your comments.

Some of the books I've read on the subject do mention that house building is a bad analogy for agile development but I couldn't think...

I thought that clustered indexes have to go on the same filegroup as their table in any case.

I would look to put the larger indexes on their own filegroup and...

Bounce your records into a temporary table with an identity field on it.

Then do something similar to the pseudo query below

UPDATE DEST

SET DateTime = DATEADD(mm,T.ID-DT.FirstID,GETDATE())

FROM dbo.YourTable AS YT

INNER JOIN...

If you have the chance then use international/national standards for your geographic codes. You would be surprised by how many different every day entities DO have an ISO standard.

Obviously...

If it ain't broke, don't fix it!

If you are running SQL2000 and your boxes aren't stretched then where is the pressure to upgrade?

There are some features of SQL2005 that really...

Good article.

For me one point jumps out. The attendees were quite good at prioritising for themselves!

My experience is that 99.9% of people are reasonable, are willing to give something...

In the ideal world I would agree with you entirely. Block them at the firewall and remove db_datareader/db_datawriter access.

However the problem described in the article was of a business...