polkadot (3/5/2013)

---

If user names are in several of the system tables and DMVs, are you saying that they are not joinable to the index usage system table? Is there...

Google for 'Gaps and Islands' Itzik Ben-Gan

He's written a huge about on several ways to get this kind of result.

User names are in several of the system tables and DMVs.

And profiler would have to be...

qur7 (3/5/2013)

---

OK, I think I get it now, so as long as the database is up , i can take a new backup with a new password and restore it...

polkadot (3/5/2013)

---

Lowell, or Gila, or someone!, would you mind also telling me which system table I can join to the sys.dm_db_index_usage_stats table to get names of users or userids that...

Tablock -> take locks at the table level. If the statement would normally take shared locks, that will be a shared table lock. If the statement would normally take exclusive...

This is a Microsoft SQL Server forum, if you have Sybase questions I'm sure that you'll get better answers on a Sybase forum.

The allow_row_locks column in sys.indexes for the clustered index.

If the database is online, the password on the certificate backups is irrelevant, you can take new backups with any password you want (see Books Online for details).

Rebuild if you can, reorganise if you can't.

No. A procedure has a single...

Backups are pretty much an IO bound operation. Check the latency and throughput on the drives.

Why not just take a backup, copy the backup across and restore on the other server?

A single piece of dynamic SQL will not cause the entire procedure to recompile. At worse, the dynamic section will compile each time, but that depends on a number of...

Bit of a large question. Entire books have been written on the subject. Literally.

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

http://www.amazon.com/Server-2012-Query-Performance-Tuning/dp/1430242035/