You can drop the login without any consequences on the primary system.

First, you might look at this script for a more efficient index rebuild: http://sqlfool.com/2009/06/index-defrag-script-v30/

An index rebuild is a logged operation. So rebuilding the indexes will result in lots of log...

What I have heard regarding CUs is that they are tested and the support people at MS have confidence in them. However, they do not get the wide range of...

You create a login and user on the source system.

You then migrate that login to the new system (the user will come through log shipping) using the same SPID.

This should...

I have heard of upgrades being done that have literally been done with shipping a SAN through Fed Ex for large scale migrations.

These days I'd use Michael's advice. I'd actually...

Backup does nothing to the transaction logs. Not sure what you mean by "reorganize" here, but a backup doesn't affect t-logs.

The thing is you database file and your external files...

CREATE USER: http://msdn.microsoft.com/en-us/library/ms173463.aspx

Luke L (1/13/2011)

---

I get what you're saying and it's probably a wash for the most part. The biggest win for me is when I'm out for a run, I...

You cannot make changes to a db in standby mode.

I like Geoff's advice. Do not overwrite files. You'll overwrite the one that you need in a disaster situation.

Write a new file every time you do a full backup, and...

Stefan Krzywicki (1/13/2011)

---

They're trash money at this point. If people see money on the ground, they stop and pick it up. If they see a penny on the ground, they...

The author is an open source person, so I'm not surprised that Oracle/SQL Server aren't on there. I assume they qualify as RDBMSes, just like MySQL 😎

Too true, and too often I see developers that don't ever expect a query to fail...

You...

If you get that message, then somewhere in there you have a pattern that isn't being caught or isn't handled well. The Charindex doesn't find something and returns a 0.