[dba-SQLServer] Output wizard choked

MartyConnelly martyconnelly at shaw.ca
Tue May 22 16:35:45 CDT 2007


Here is the start of a series of articles on performance tuning SQL
One is a 30:1 increase of speed on INSERTs, another on NOLOCK use

http://www.sqlservercentral.com/columnists/jSebastian/2944.asp

Eric Barro wrote:

>Just google it :)
>
>
>I've found articles on www.sqlteam.com quite helpful. A subscription to
>SQLMag.com has been quite helfpul as well. I also have the Microsoft SQL
>Server 2000 Bible from Wiley Press.
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
>Sent: Wednesday, May 16, 2007 1:59 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: [dba-SQLServer] Output wizard choked
>
>I gotta get a book for this stuff.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Eric Barro
>Sent: Wednesday, May 16, 2007 4:49 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: [dba-SQLServer] Output wizard choked
>
>SUBSTRING('abcdef', 2, 3) returns bcd
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
>Sent: Wednesday, May 16, 2007 1:18 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] Output wizard choked
>
>I tried to set up an export using the export wizard.  It choked because the
>data in the address1 field was larger than the allowed data field width that
>I entered.  The output file is a fixed width file speced by the customer so
>what there is is what there is.  I saw no place to edit the transform or
>tell it to go ahead and trim the data.  I did save the transform info in a
>DTSX file, though the last time I did that it didn't end up very useful.
>
>What is the SQL Server syntax for returning the first N characters?
>
>Any suggestions.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
> 
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>No virus found in this incoming message.
>Checked by AVG Free Edition. 
>Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007
>10:47 AM
> 
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada




More information about the dba-SQLServer mailing list