Have you checked the withs Event Viewer logs? If not please do so. I spent several days fighting some guys over data access I was doing on a call switch...

There were several issues that showed up in 859 and the current publicly available level is 878 found here

http://support.microsoft.com/?kbid=838166

Also here is a good location of up to date info...

But to do without dynamic sql you need to create a storage area using a temp table or table variable and put each item into it's own row. Plenty of...

Then you have either a lot of data, and use of Table variables can be related, in memory at one time or you don't have enough memory to support it...

In fact it is suggested you use the fully qualified name in every circumstance from CREATE statements to actual DML such as a select statement.

You actually get a slight performance...

First off what version of SQL Server are you runing, Enterprise Edition or Standard?

I like this for getting the count of a the number of occurrances of a single character.

DECLARE @a VARCHAR

SET @a = '-'

SELECT

DATALENGTH('a1sdsad12---325143gffdfd4dgsf1 -')

-

DATALENGTH(REPLACE('a1sdsad12---325143gffdfd4dgsf1 -',@a,''))

Or for higher safety do

DECLARE @a VARCHAR

SET...

Or try

SELECT

 IsNull(Table3.Site,Table4.Site) Site,

 Table3.IPAddress,

 Table4.HostName

FROM

 dbo.Table3 Table3

FULL OUTER JOIN

 dbo.Table4 Table4

ON

 Table3.Site = Table4.Site

I haven't heard of anything specific try watching under profiler to see where and when it is occurring.

Can you post a whole example and let us see if we can offer you a alternate and maybe better solution to the code you created?

A table variable only exists during the run of the process that created it as is immediately destoryed at the end and any pages in tempdb associated with it are...

Poor thing is that the server components require it has to be installed on a Windows 2000 server. I only want to test the freeware product on a Windows XP...

COnsidering that I would have to say they have you goverend somewhere, either at the FTP server or a router that is dropping packets. I don't know of any off...

Read this http://www.microsoft.com/sql/techinfo/tips/development/queryopstats.asp

It also tends to be more people put stock in composite indexes than they need to so be carefull that you are truely make a usefull index.

The answer is it depends on the column order with relation to other variable length columns.

When the data is stored there are several bytes resevered for various purposes including the...