I'd go one step further - you probably want to make TempDB plenty big (both on data and log files), so that you can avoid having to contend with auto-growth....

mchristy (10/14/2008)

---

I am trying to calculate a fixed payment on a variable rate loan with the following variables

Loan amount = $10,000

Total length of loan = 60 months

where the Rate =...

You should look...

Also - keep in mind that the second you put XML information into an XML data type, SQL Server will reorganize that data in any which way it feels like...

Since we're talking straight network issues at this point - you might care to make sure that your frame sizes are compatible all of the way through. LAN traffic...

declare @column_num int

declare @columnname varchar(max)

declare @tablename varchar(max)

set @column_num=2

set @columnname='';

set @tablename='MyTable'

select @columnname=@columnname+',['+column_name+']' from information_schema.columns

where table_name=@tablename and ordinal_position>=@column_num

declare @sql varchar(max)

set @sql='select '+substring(@columnname,2,len(@columnname))+' from '+@tablename

Print (@sql)

Exec(@sql)

Thanks for the feedback! I am glad that helped you.

(There is no way to mark a specific answer, so don't worry about hunting it down!)

Jeff Moden (10/13/2008)

---

You should continue the question because you're still using a loop and a function...

This got posted twice - answers should go over here:

http://www.sqlservercentral.com/Forums/Topic585181-1292-1.aspx

Jeff Moden (10/13/2008)

---

Last, but not least, you need to include the intial value of @j-2 in the @I loop or it just counts down in one iteration of @I and...

There is no updated virtual table - it's Inserted. That is more than likely what your problem is.

It's always a combination of Inserted and/or Deleted.

Jeff Moden (10/10/2008)

---

rbarryyoung (10/10/2008)

---

And what bothers me most about this is that I know that it is not the extra formatting that is killing my speed, but the built-in formatting...

bobhovious (10/12/2008)

---

Ditto what Chris said. Varchar(max) is going to hurt your I/O. Go there only if you KNOW your data is going to exceed 8000...

Why not build a client-side SSIS package, which takes the file name in as a parameter? You would still be able to access all of the .NET stuff from...

Well - considering some of the hopes being hung on this thing - here's hoping they don't jump the gun. If it's as big of a product as it's...