Sometimes (often) you just need to ignore what a vendor says because you know more than them.

I ignore vendors all the time when they start spouting nonsense like that.

You are...

I agree that a clustered index on date makes the most sense for a date table, at least for the majority of applications.

I think a sequential number for the...

Access to the “secret” forums is post count based, but Steve makes exceptions on a cash basis.

You can contact him via private message to negotiate terms.

Vendor promised CIO 10% kickback on license purchases.

Decided it would be easier to find qualified Oracle DBAs and developers than SQL Server DBAs and developers.

IT summer intern said it was...

Maybe you could ask them?

Thre is a good chance that setting the database to READ_COMMITTED_SNAPSHOT will resolve most or all deadlocks.

However, deadlocks will still be possible, and if you still get them you will...

You should look into using SQL Server Extended Events for this monitoring.

Introducing SQL Server Extended Events

http://msdn.microsoft.com/en-us/library/bb630354(v=SQL.100).aspx

sunny.tjk (6/13/2011)

---

Gail, don't you think it becomes really tough to write a query to update statistics if there are 200 columns.

For example: I need to specify 197 columns in the...

MyDoggieJessie (6/11/2011)

---

Using SQL 2008, SP2 assuming you replace "MyJob" with a valid SQL Agent Job on your server, how can you get around the fact that error # 22022 is...

We use it for full, differential, and transaction log backups, and have never had a problem with it.

I believe 'guaranteed to never fail' software applications do not exist and never will.

I would also say that most software applications fall very, very far from that ideal.

One thing you could do to make the proc less of a problem is to have it randomly exit most of the time. Since it is just the same...

My assumption was that you were trying to view the data from another connection.

You can use the OUTPUT clause of the UPDATE statement to get what you want.

begin TRAN

UPDATE Table1

SET...

I have seen a table that was 15 GB in size, even thought the rows were narrow, and it only had 200 rows in the table. It was an...

If you are using row-versioning isolation (SNAPSHOT ISOLATION or READ_COMMITTED_SNAPSHOT), you will see the data as of the last committed transaction and before the start of uncommitted transactions.