What are the specs of the various machines?

What else is running on the machines? If the host is running WebTrends you may see a huge performance hit. WebTrends...

DECLARE @sProcName SysName

SET @sProcName=''

WHILE @sProcName IS NOT NULL

BEGIN

SELECT @sProcName =MIN(Name)

FROM SysObjects

WHERE Type='P' AND...

I've installed it on my development servers but don't have anything to report as yet.

The @@error bug seems to be fixed and some queries seem to run faster.

What I am...

Well, as VARCHAR/NVARCHAR shouldn't pad the string that implies that either your variable is paddding or the setString function is padding it.

What happens if you run

SELECT databasepropertyex(DB_NAME(),'IsAnsiPaddingEnabled')

Why bother?

I am sure that you can copy MODEL to another instance, but I'm not sure about MSDB. I suspect that you can move MSDB but don't quote me...

Ye Gods, don't you just hate vendors who buy a stable full of products, chuck them in a bucket, stir with a big stick and then say "look at our...

I think you are getting confused with the byte storage rather than the physical character storage.

NVARCHAR(10) and VARCHAR(10) can both take 10 characters but NVARCHAR will store it in 20...

Massive locking problems.

Every record creation seems to result in an insert and multiple updates while locking everything up.

Its OK when its just publishing but when visitors are surfing the site...

If you don't explicityly need unicode or double-byte characters then stick with CHAR, VARCHAR, TEXT etc rather than NCHAR, NVARCHAR, NTEXT.

I don't use CHAR very often because it is a...

I saw an article that argued that certain languages attract good programmers. If that is the case then C++ and Java will naturally be skilled.

Try recruiting a good VB...

I think you are getting a bit mixed up with your CONVERT statements

select convert(varchar(20),planarrvtime,108) as plantime,

convert(varchar(20),arrtime,108) as arrvtime,

DATEDIFF(hour, planarrvtime, arrtime) as diff,

case DATEDIFF(hour, planarrvtime, arrtime) when 0 then 'Present'

else CAST(DATEDIFF(hour,...

SELECT LEFT(YourColumn,5) AS Code, Count(*) AS Records

FROM dbo.YourTable

GROUP BY LEFT(YourColumn,5)

I forgot to add, I built an Excel export routine that spat out an HTML table but the page header had a ContentType="application/vnd.ms-excel"

This means that although the file is really...

I could be wrong here but I think the export to Excel uses the old JET libraries and that is the reason the TEXT data gets restricted to 255 characters.

If you want a global temporary table then use CREATE TABLE ## rather than CREATE TABLE #.

Be careful though. When the creating connection logs out the table will vanish...