If you have multiple datasets the rowcount is the sum of all rows returned by all datasets in the report, not just the main dataset.

An execution plan would be helpful as well.

I don't think the issue is the clustered index, although it could be, but the only thing that would change by...

Just thought, if this query is in a stored procedure, I like to see if using temp tables for tables used multiple times in a query can help speed things...

It is highly unlikely that having a clustered key on an identity column is causing deadlocks. An identity column is typically a very good candidate for a clustered key...

Have you looked at the Wait Stats?

Also, the common question, what has changed? Has there been a service pack applied to SQL, the OS? Has something changed in...

Hey is anyone going to be at the SQLSaturday this week in Orlando or next week in Providence? If you are be sure we see each other.

Grant Fritchey (9/9/2013)

---

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are over. Our little... thread... is a toddler...

SSMS doesn't know about the servers. If you want to connect to a SQL Server local to your PC you can put in a ".", "Local", "LocalHost" if it...

Rod at work (9/6/2013)

---

HanShi (9/5/2013)

---

The RAISERROR command in your trigger raises an error with a user defined number. This error is not a standard SQL error, but RAISERROR can still...

Here's an example that shows what is probably happening to you:

DECLARE @ProductionShift TABLE

(

StartTime VARCHAR(10),

EndTime VARCHAR(10)

...

First, running CHECKDB monthly probably isn't often enough. Basically you are saying we can live with having to go back possibly months to a clean database. Check this...

Something like this should work:

DECLARE @test-2 TABLE

(

RowID INT,

DateStamp DATE,

PrevStatus INT,

...

Tom,

I was going to mention the bug and link to the connect item. I also need to mention that RedGate Sql Data Compare doesn't re-enable FK's with CHECK when...

Steve,

I can take this one. Especially since I've been burned by it.

I think the REPLACE function will do what you need.