John Hanrahan (11/19/2013)

---

But any idea why @@rowcount would be so slow? The line of code doing the insert is a single row insert. I can't understand why it...

They are a tool. They can be used well or used badly. When used badly, blame the developer, not the tool.

Abu Dina (11/20/2013)

---

Perhaps an ORDER BY clause in your query is now using...

Ignore the 0. The database ID and object ID are what you need to identify the table that the blocking is on (and it is a table-level lock).

Please run a full CheckDB, not just a check table on the one table you know there's a problem with. I asked for a full CheckDB to see if there...

You can just add the new file (with a decent size) and disable autogrow on the first one. With an empty new file and an almost full existing one, SQL...

Please run the following and post the full and complete, unedited output

DBCC CheckDB (<Database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Again, not enough information. Please read through the article I referenced.

If you create an index on a column that is just in the select clause, that index is probably useless.

No where near enough information to answer that.

Depends on the columns in the index, the where clause predicates, the selectivity of the index and more.

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

http://www.sqlservercentral.com/articles/Indexing/68636/

Database ID 15 (so the database with an ID of 15 in sys.databases)

Table ID 638292499 (so the table with an ID of 638292499 in sys.objects)

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1515848-1550-1.aspx

A properly maintained log should not be growing.

Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/

Short answer - it doesn't. It forces the optimiser to use an index. It's possible that it will result in worse performance if the hinted index is not the best...

Depends on your requirements and version. In SQL 2005, triggers are the main ones, on all tables with audit tables that they write into. On 2008 you also have Change...

Not unless you have some form of auditing or change tracking in place.