Then why is it posted in the SQL 2005 forum?

DEFINE: ([Expr1006] = [PROBE VALUE])) ...

idiescreaming (1/11/2010)

---

As both of you pointed out that killing SPIDs is not a good idea and I do understand why, is there a way to safely unlock the process using...

Not true at all.

Count(*) and count(<constant>) both count the number of rows in the resultset.

Count(someColumn) counts...

Not quite. Log's divided into sections. The sections can be active or inactive. Only the...

Use the REVOKE statement to remove permissions.

Example

REVOKE SELECT on SomeTable TO Public

Specific statement depends on what the objects are.

Directly editing the system tables, even on SQL 2000, was just...

Depends. Oracle has per-row and per-statement triggers. I have no idea which is the default (if...

You're gonna have to give us more details than that to work with. Table structure would be useful, as would some pseudo code, details on exactly what's happening.

What uses the primary key to filter/select by? If nothing, I'd suggest a 3-phase approach here.

1) Make the primary key nonclustered

2) Add a clustered index on the CreateDate column

3) Partition...

Well, your code asks for only one value from the deleted table (which will have 4 rows if 4 rows were deleted),...

For future reference, please read through this for the best way to post to get fast replies. http://www.sqlservercentral.com/articles/Best+Practices/61537/

Now this isn't tested, cause no table structure was posted, but should work...

I would suggest you optimise your queries before starting to fiddle with locking and isolation levels.

Try these articles for starters

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

And, before you consider changing isolation levels, do some reading as...

Do note that what SSMS is doing here is creating a new table, copying all the data over, recreating all the indexes and constraints and dropping the old table. Fine...

gregory.anderson (1/11/2010)

---

Never heard of the partition thing...I'll look into that.

Yes, this is 2005 enterprise edition, sp2 I believe.

Right now, the customer is receiving 5 9's of uptime and they are...

A full backup does not truncate the transaction log. Never has. A transaction log backup will contain the transactions since the last log backup.

The only time when a log...

Why do you want row locking there?

Before going that step, have you checked indexes?

Is this Enterprise Edition? If so, have you considered table partitioning. With a partitioned table, you...