Groups | Blog | Home
all groups > sql server (microsoft) > march 2006 >

sql server (microsoft) : 22 seconds via QA and sub-second under 1 SSMS


aaron.kempf NO[at]SPAM gmail.com
3/29/2006 9:44:26 AM
why is it that this sql statement

DECLARE @SQL_BULK_INSERT VARCHAR(1000)

SET @SQL_BULK_INSERT = 'BULK INSERT LOGTEXT_STAGING FROM ' + char(39) +
'C:\aaron\ARC_LOGS\LOG_138849.TXT' + CHAR(39) + ' WITH (ROWTERMINATOR =
' + char(39) + CHAR(13) + CHAR(39)+ ',FORMATFILE = ' + char(39) +
'c:\arc_20060329_logtexttemp.xml' + CHAR(39) + ')'

PRINT @SQL_BULK_INSERT

takes 22 seconds via SQL 2000 query analyzer; but it runs in under a
second in SQL Server Management Studio??
aaron.kempf NO[at]SPAM gmail.com
3/29/2006 9:55:56 AM
oh how funny

i had a hung isqlw process i dont know wtf it was doing.. but it was
consuming like 99% of my processor.

i killed it and QA and SSMS started behaving the same.

i'm just impressed; obviously SSMS responds better to a busy sql server
than does Query Analyzer
AddThis Social Bookmark Button