Have you tried updating statistics?

UPDATE STATISTICS <Table Name>

A process becomes suspended when it has to wait for a resource. To figure out why it's suspended, check what resource it's waiting for. Query sys.dm_exec_requests and check the wait_type...

All data changes are done as part of a transaction, whether the transaction be explicitly started or not. Even a single statement update is done as a transaction (which includes...

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

What transaction log backups do you have?

Since the DB is in full recovery, you must have some or that log would have long since grown out of control.

What do you mean by 'can't open transaction'?

Is your user getting an error? If so, what error?

The log backups won't necessarily be identical. The NO_TRUNCATE on the first one will ensure that they both start at the same point, but the second may contain records the...

gregory.anderson (7/30/2009)

---

Yep, there are already a few indexes on this table that cover the PK and other "ID's" in the table, but one specific SP always comes back via Quest...

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

Agreed. This is not a...

In all the SSAS recommendations I've read (and the ones I've made) the datetime is stored in the SQL table as a datetime, to whatever granularity the user wants to...

Should be possible, I can't think of a reason why it wouldn't. What have you tried and what problems are you having.

Do you want the trigger to fire only for a specific user, or do you want the trigger to fire for everyone whenever a certain user is logged in?

Sleeping just means not currently running a query. It's easy for a sleeping connection to still be holding locks if a transaction it ran earlier wasn't committed.

Switch traceflag 1222 on....

The exams for the MCDBA certification have been retired. It is not possible to write them any longer.