Basically, run through the Object Explorer in SSMS. You have the database backup, so that's done. So, Security, logins & roles next. Then Server Objects, usually just linked servers, but...

You don't have to turn on a traceflag any more with SQL Server for deadlocks. The full deadlock graph is available in the system_health extended event session.

Posting the deadlock...

Then you need a way to mark the IP as changed (UpdateDate or something similar) or you have to capture the full data set and then compare it to spot...

Double post. Not sure why. Apologies.

I actually had to support a policy management system at an insurance company and had to deal with latest versions similar to this. Largely you've already got good solutions from...

Deadlocks are usually caused by a combination of poor performance and problematic coding choices. Not being able to see your structures, code or the output of the deadlock graph, all...

murnilim9 (7/16/2014)

---

Jeff Moden (7/16/2014)

---

murnilim9 (7/16/2014)

---

Thanks a lot on your response !

Btw I performed rebuild indexes on certain databases ..maybe around 22 indexes need to be rebuilt and it failed and...

Threadizens!

Make sure we talk if you're Telford this week. The Red Gat Army is travelling up there this afternoon.

Could be that you've enabled Enterprise settings on the databases and that's being detected.

I wouldn't recommend doing an in-place downgrade of this type anyway. May just be my paranoia shining...

Have a nightly process run from SQL Agent to make the checks to see if something is coming up in the next 48 hours, or whatever, and send an email...

You can't have a second set of transaction log backups. That will absolutely break things. But you can set up full backups as Gail outlines.

Sure, but how do you determine if there has been a change? If you always update a datetime column, maybe you can just check for updates since the last one....

You can also look to extended events as a way to capture this sort of behavior, filtering to ensure you're only capturing queries against the table and only those queries...

That's a giant topic and it's kind of hard to give you too much guidance in a forum post. Yes, most tables should have at least a clustered index. In...

Don't just look at the...