Hi

Here you can find a great article by Gail about parameter sniffing:

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

Greets

Flo

Could you please post your BCP command line call (without authentication)?

I just tried:

CREATE TABLE TestBcpOut (ColA VARCHAR(40), ColB INT)

CREATE TABLE TestBcpIn (ColA VARCHAR(20), ColB BIT)

INSERT INTO TestBcpOut

...

:w00t:

Sorry, I misread. You want to move from 2k5 to 2k? Forget my advice to use VARCHAR(MAX)/NVARCHAR(MAX)

To compare TEXT/NTEXT either use LIKE or a full-text index.

Greets

Flo

TEXT/NTEXT are marked as deprecated in SQL Server 2005. You should switch to VARCHAR(MAX)/NVARCHAR(MAX)

The provided error occurs when you try to use an "=" operation on a TEXT column or...

The error usually raises when you try to INSERT/UPDATE too large string or binary data into a table.

Please post the DDL of your procedure and the tables you UPDATE/INSERT inside...

Hi Sylvia

As John wrote; setup a dev-environment with smaller database(s).

Our production databases are between 5 and 500GB. Anyway, we have small development databases with about 500MB, QA databases with some...

RBarryYoung (5/28/2009)

---

True, except that we see anywhere form 20...

Bob Hovious (5/28/2009)

---

That is an impressive number of views. I always felt that The Thread is a large part of what makes SSC seem more like a...

Alvin Ramard (5/28/2009)

---

GSquared (5/28/2009)

---

Ironic for a chipmunk to want cats on the...

I think the main difference between "BCP/BULK INSERT" and TVPs is the context to use it.

Since BCP requires special privileges it's not a feature for front-end applications. TVPs can be...

Great job, Solomon!

That's definitely a feature which was missing in my opinion.

I think BCP is a very powerful and nice tool but it is much less flexible. XML is a...

Since I have no idea about Oracle. Could you please explain the "commit/rollback features"? This makes it easier for T-SQL guys and gals 🙂

YEAH!!!

4995 bottles of beer on the wall, 4995 bottles of beer! Take 1 down pass it around, 4994 bottles of beer on the wall!!

😀

Barry,

No problem, anytime!

Barry gave you a very good hint. Take it!