Lynn Pettis (8/3/2016)

---

Jack Corbett (8/3/2016)

---

Lynn Pettis (8/3/2016)

---

Is the code I wrote here really that sophisticated, or is it that I have been doing this so long that for...

The problem with Lynn's fine solution is that it isn't able to utilise an index on the Address Type, hence a relatively expensive sort operator is introduced in the execution...

Good point Thomas;-)

😎

Why not

Declare @test VARCHAR(100) = 'This is my name';

SELECT @test;

😎

Can you post the DDL, sample dara and the expected results?

😎

Depending on your maintenance window, best option may be a fresh install of the new server, script transferrable logins, detach and copy the databases, attach on the new instance and...

Quick answer, No.

😎

Phil Parkin (8/3/2016)

---

Eirikur Eiriksson (8/3/2016)

---

Phil Parkin (8/3/2016)

---

Eirikur Eiriksson (8/3/2016)

---

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error...

Phil Parkin (8/3/2016)

---

Eirikur Eiriksson (8/3/2016)

---

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error flow to insert to...

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error flow to insert to a table with varchar(max)...

Quick thought, you can define "hard" attributes like weight, size, value etc. which are common to all and then use sparse columns in the same table for softer attributes which...

Post the DDL (Create table scripts) for all the tables, sample data as insert statement and the expected output, makes it much easier for us to provide you with the...

Have a look at Time and Space: How to Monitor Drive Space in SQL Server By Ed Wagner[/url]

😎

IIRC, either when the batch size is reached or the last row has been processed.

😎

Quick question, have you tried Robocopy?

😎