Define your own organization in the clients table. When staff are working on internal jobs the client is yourself. You should also have specific tasks defined in a Tasks...

For shops that have no .net development expertise (or desire to do so) its a good tool. Also very good for shops that have lots of varying but lightweight integration...

I'm not aware of any file size limitation for importing data into SQL server.

Things you can do to make the import operation as efficient as possible:

1) put the database into...

We had similar requirements so I wrote a .net utility that can transfer various objects from one database to another, or to renamed tables in the same database. I used...

Sounds like you (client apps) might be using a lot of server side or API cursors. They are performance killers... change your code to use client side cursors instead.

IDENTITY_INSERT is a session setting so if your script (or DTS package) is issuing the commands in separate sessions like this:

exec('SET IDENTITY_INSERT dbo.InspectionFrequency ON');

exec('Insert dbo.InspectionFrequency ( < column_list> ) values(...

cast it to an integer when you join, like : cast(Points.ScalePoints as integer) = cast(Scales.Scale as integer)

Here is an example of a legitimate case: A table with rows...

create a view of the table which removes the character you are worried about then BCP the view.

declare @someValue money

set @someValue = getprice()

Select dividend/@someValue as dividendYield, @someValue/Bookvalue as PriceToBookValue, @someValue/Earnings as PERatio From SecurityDetails.

It is possible SQL could be smart enough to now the function return is...

AndrewSQLDBA (10/7/2011)

---

Yes, that I could. I can use C# in a SSIS package. My problem is that I am not sure where to begin with it.

I am able to replace...

If it were me I'd write a little C# program to process and load the pipe delimited rows and then insert into another table. You could split each row...

Maybe you should take a look at FASTFIRSTROW table or query hint, it might help you.

However, as other have noted, when your query involves huge tables and joins to...

Yes. We use RAID 1 for tempdb on most our servers, the rest have RAID10 for size and...

If the data is static except for a monthly load process you just drop and rebuild the indixes as a part of the load process.

In this day of terrabyte drives...