Well, sp_who2 is shipped by MS with SQL Server and gives a consistent set of data and will be available on all SQL Servers. sp_whoisactive is a great tool...

In my opinion, it always better to jump ship before it sinks and if you see the ship sinking and can get out you should. So you are taking...

I'd agree that asking what is relevant to a particular error number is silly. Very few people I know have error numbers memorized since you always get some kind...

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,

...