I should have also mentioned that the throughput of the BULK INSERT cannot even be compared to a row-by-row approach. The BULK INSERT is so much faster that it'll...

It handles embedded quotes without any problems.

When doing BULK INSERT, I like to use a format file to specify the data source and destination and then direct the BULK INSERT...

We'd like to move our 2005 instances to 2008, but it's a slow process. Like so many things worth doing, it takes time and effort.

Lowell (6/14/2013)

---

Ed Wagner (6/14/2013)

---

I've always done this using a .NET application and found it far easier than trying to force it with T-SQL. The first big hurdle in doing...

The database diagram tool in SQL Server can create relationships, which does modify the tables. If you want to create the diagrams for visualization only, I'd also suggest using...

I don't know if we had the 10% hit problem you're having, but I do remember a 32-bit 2005 instance that kept having log entries saying that it was under...

I've always done this using a .NET application and found it far easier than trying to force it with T-SQL. The first big hurdle in doing it with T-SQL...

Could you give us a little more to go on? The DDL to create the table and something about the insert that's taking a lot time would be a...

It takes time for SQL to run the batch - that's the execution time. It also takes significant time for SSMS to take the execution plan and translate it...

Lynn Pettis (6/13/2013)

---

NJDave (6/13/2013)

---

Thanks - but I overwrite the BAK file with a more recent one and always have it in the same directory.

Is there anything in the database that...

I don't know what to do regarding the database master key for which you don't have the password. I hope someone else does, because I wouldn't mind learning about...

That would be the simple and very effective way to handle it. I have some flatfiles that are loaded daily and processed through a stored procedure using BULK INSERT....

Whenever I have to import data more than once, I very much prefer to use BULK INSERT. I create the format file in XML, write the SQL to do...

Jeff Moden (6/13/2013)

---

Oddly enough, they just proved that it was possible if...

I came up with this.

SELECT

IDIS_ACTV_ID AS ID,

Z.ACTV_HOME_PROPERTY_ID,

ROW_NUMBER() OVER (PARTITION BY ACTV_HOME_PROPERTY_ID ORDER BY (SELECT NULL)) AS BUILDINGID,

Z.ACTNBR,

Z.ACTNAME,

Z.RELATEDYEAR,

Z.IDIS_ACTV_ID,

...