Thanks David, that's interesting. I will try your suggestions. I might also monitor the connections to see if the same machines use Named Pipes all the time, and then have...

This time of year...clementines, i've eaten 7 this morning

David

What is the evidence that the procedure is executing twice?

Could it be executing once but producing unexpected results?

What happens if you call the procedure from SQA? Does it still...

This article reminded me of an advert I saw a few months ago ( I cant find a link to it, perhaps someone can help me) for a flash drive...

Great article. I look forward to the next in the series.

I did have one problem. I tried the post-script code for adding the date and time to the filename, and...

I find myself wondering if it is worth turning off all the scripting and graphic features in my browser and going back to text-only. All these animated adds are distracting...

I should really be working rather than replying to this, but its first thing in the morning and my brain hasn't started yet (it takes a while for the caffeine...

Hi,

I get this problem as well. In my case it seems to occur where views are referencing other views or UDFs. I have a batch of about 10 views in my...

This happens in Biology all the time. New evidence becomes available which leads to species being reclassified, such as the debate...

http://news.nationalgeographic.com/news/2003/05/0520_030520_chimpanzees.html 

...regarding whether chimpanzees should be classified in the same...

Hi,

also check that the estimated and actual row counts are approximately in agreement. If they are very different, then it indicates that your stats are out of date. since the...

Hi

I use the free version of Zone Alarm for my personal PC (Windows XP SP2 has a built in 'firewall' as well) and have always found it quite useable once...

Hi,

I came up with a slightly different solution on the same theme as Ken's...

declare @DateDemo table

(

  TestDate datetime not null primary key

 ,price int not null

)

insert @DateDemo

select '20070101', 100 union all

select...

Perhaps referring to the script on this site for an ISINTEGER UDF?

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=897

David

Thanks everyone, this has been really useful!

I have used the function to return all strings in the set after the nth string using a little feature for concatenating strings I found on...

Great article Mike, thanks, and what a neat little function SetSplit is! I have added it to my toolkit (and given you and...