i found this bat file from microsoft which is pretty much bullet proof:

it adds the current user as an administrator to the sql server that is prompted in the command...

bulk insert into a single table is incredibly fast. switching away from INSERT statements being generated to sticking the data into a local DataTable, and either syncronizing the changes or...

Beatrix Kiddo (11/20/2013)

---

We have a user who has access to just one view on one database, and he needs to create a linked server from his database to that view....

you have to switch to dynamic SQL for the whole thing, when you try to parameterize BULK INSERT; it only accepts static strings, and not variables.

DECLARE @sql varchar(8000)

--bulk insert won't...

easy fix for you guys.

I assume you went to this page and downloaded the procedures from Micorsoft:

http://support.microsoft.com/kb/918992

from there, all you really need to do is modify the code, so that...

my personal rule of thumb, based on my own experiences, is that if a table has more than 50K rows, i'd rather use SSIS (or The Import/Export Wizard, technically still...

the openquery for a simple select is what you are after, it's just what you do witht eh results(sticking them into your local table instead of displaying)

INSERT INTO...

rebuilding the indexes updates the statsitics for the columns of the indexes, but not all the statistics for the given table.

statistics on non indexed columns let the query engine...

Ed Wagner (11/19/2013)

---

I may be remembering incorrectly, but if you use dynamic SQL in your procedures, the dependency might not show up in the list. If you find that's...

don't limit yourself to think it must be a single char.

i export stuff like html in and out all the time; as a result, i use multi character delimiters that...

just a few things i'd throw in there, but it sounds like you've got it covered pretty well.

Post-Migration, make sure you rebuild statistics for all tables, in each database with...

d.velders (11/19/2013)

---

It's indead an idea to generate a SP that does the calculation of these working days.

Does anyone have an example on how to do this or even better a...

the default length is 1.

when you use cast or convert, the default length is 30, but for column definitions, it's a single character.

this seems to work for me;

I had this saved in my snippets:

SELECT depz.referenced_schema_name,

depz.referenced_entity_name,

objz.type_desc,

...

with the data you posted, everything is older than 40 months, so i assume the item has no official value any more; i added one example to the sample data.

so...