You have to have a clustering service running. That's not the same thing has having a standard failover cluster. You can read a little more in the AlwaysOn FAQ.

I sincerely try to use the correct data type for the situation. Could I just plug int or bigint anywhere rather than think about if a tinyint or smallint can...

Case statements in the WHERE claue are going to lead to some less than satisfying execution plans. I'd suggest breaking down into different queries rather than do that.

In general, this is one of those "Doctor, doctor! It hurts when I do this" moments. The correct response being "Don't do do that."

It's pretty rare to have an emergency...

Keep monitoring the system, thousands and thousands of blocking occurrences will flit by. All that matters is when blocking is excessive, meaning, too much time is spent waiting for resources...

GilaMonster (5/8/2012)

---

Bhuvnesh (5/8/2012)

---

I am totally agree with you but take it in other way around, database/schema designs are not done on current requirements/structures only but also keeping future in...

My experience is the same, a regular refresh to ensure that data reflects production as much as possible. The issue is, this is only viable when the databases are of...

Unless we're talking about some type of actual error, no, there's nothing to see for a query that behaved, but didn't do what you wanted.

No, I wouldn't say every table needs it at all. It's a business call. BTW, what about UpdateDate and UpdateBy? And are we doing physical deletes? Instead we could use...

You can run it on any environment. As you've already been told by Gail, you must run it in Production. When? Find the time when you have the least load...

I have a book on that topic, linked the signature below, or you can search online and find a free e-book copy of the book. I also post regularly on...

The simplist option is to restore the production database on your development environment. I agree with the previous poster, you should set up scripts to clean out any sensitive information.

After...

If you're in transactional replication, did replication fail? Is the distributor down?

Although, if you're simply testing the restore to validate the backup, the fact that logins don't sync correctly is not an issue you need to worry about.

Yeah, you can't test this against production systems. Good first choice.

After that, just take the backups that are already running in production and test them in a restore against a...