Grant,

Thank you for the information. Can you possibly point me to the right direction for updating stats on the tables as well as more information for "Full Scans". I will...

The execution plan is attached. Thanks for the replies and any help will be appreciated. The query ran for 40 minutes before it provided me the execution plan and 622...

http://www.sqlservercentral.com/articles/powershell/68011/

Thank, this definitely points me to the right direction.

However, this only gives me the count of the total tables in a database with the is_identity true/false.

I need names of...

I think log shipping is a cheaper of all those options and efficient as you can do log backups every 15 minutes or so and a weekly full database backup....

Great, thanks for the quick reply. Yes, we do take log backups of all high volume production databases at every 30 minutes 🙂

repent_kog_is_near (10/1/2009)

---

Gail

Thanks for the useful article.

Other than slowing down the DB, does it also cause lot of fragmentation?

Also what is the best way to estimate the ideal size of the...

Basically what's happening is that the table your querying is getting either updated with new records or getting modified by an update statement which locks the database. So when you...

Yes, and for information purposes, those "With" clauses are also called CTE's or 'Common Table Expressions'. It is nice though I have not used it yet. Waiting for a situation...

You can setup triggers to monitor for updates to the table by logging them into another table when an update / insert takes place into any of your production tables....

Lowell (9/25/2009)

---

ok here's a 2005 secret: there is a hidden row identifier in every table row named %%LockRes%%,

in 2008 they renamed the identifier to %%physloc%%

you can use that as part...

I'm not sure I understand. It deletes all columns from the table? :crazy:

How about:

SELECT dupeColumn,

COUNT(dupeColumn) AS NumOccurrences

FROM users

GROUP BY dupeColumn

HAVING ( COUNT(dupeColumn) > 1 )

I'm just thinking...

Could you possibly pick out a column you have suspicions on for being a potential PK candidate and then look for duplicates based on that column using a...

Paul White (9/14/2009)

---

OK. If the two things happened at EXACTLY the same moment (the database was set up so that the INSERT didn't block the SELECT or vice-versa...)

You would...