What isolation level are you using for your connections? Have you enabled read-only snapshot isolation?

GilaMonster (9/29/2011)

---

GSquared (9/29/2011)

---

SQL 2005 can allow data outside the 8k limit. Are you on SQL 2000? (Gail already asked, but I thought I'd clarify why.) It tends...

GilaMonster (9/29/2011)

---

GSquared (9/29/2011)

---

Is online Index rebuilding Enterprise-only, and does rebuilding an index lock the table outside of that? I seem to remember it does, but I could easily be...

What about Kerberos? What do you have set up to handle the double-hop security token?

The automatic index suggestions always need to be taken with a grain of salt.

Glad I could help.

So long as your data doesn't exceed 8k in any given row, you should be fine, so long as the columns are variable width.

SQL 2005 can allow data outside the...

Are you using Enterprise Edition?

CREATE PROC dbo.RecordCountCheck

(@PassFail_out BIT OUTPUT)

AS

SELECT @PassFail_out =

CASE WHEN (SELECT COUNT(*) FROM Table A) = (SELECT record_count FROM Meta table) THEN 1

ELSE 0 ;

Lots of other ways to do it, that's...

Simple Talk (http://www.simple-talk.com/) has some .NET forums. Not sure how good they are, but they're available.

I'm not sure how I'd do that directly in SSIS, but it would be trivial to do in T-SQL, and if the data is already in tables, you could do...

Didn't realize...

Check these, and the discussions on them. See if they help:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

ME LIKE!

Hiring can follow weird patterns.

Last year, I was job hunting in August, and there was NOTHING in Tampa, but tons in Orlando. But December/January every year, Tampa IT hiring...

GilaMonster (9/29/2011)

---

Evil Kraig F (9/29/2011)

---

Awesome...