BTW just ran a check on my server.  A single connections seems to occupy around 32K of ram.  So 1000 idle connections would take around 32mb or ram.  It's a...

A huge amount of idle connections can be a problem... but I mean huge (10K maybe even 100K).  Unless you server is extremely short on ressources where 500 connections can eat...

Yup binary search can be manually applied too .

I feel the need to point out that temporary tables where created exactly for those kind of process!  May we know what you are trying to execute will that pseudo...

May I suggest a faster technic.

Comment half the columns.  Depending wether it works or not, you know in which half the error is so that's 50% of the work done.  In the...

I just don't see it... and I don't have .net installed to test so I'll leave that one in your hands unless someone else wants to try it out!!

Depends on how busy is the server.  You can start with a 3 secs wait delay.  Then change accordingly to how the server behaves.  It shouldn't slow it down too...

Can we see a link to this top 10 pls... I'd like to see it .

This works for me :

DECLARE @I AS INT

SET @I = 12

SELECT CASE

 WHEN @I = 1 THEN 1

 WHEN @I = 2 THEN 2

 WHEN @I = 3 THEN 3

 WHEN @I...

It's a table with all the dates as the clustered primary key.  Then you can add flags for trimesteres, week-ends, holidays, etc.

BTW the reason I use A function to run this is that I put all of this code in a single class which is also computer-generated.  That way any application...

Glad you got this working... needless to say that I have this code made to fit my setup which includes a global...

This thread is onw officially rated R .

Maybe we could help more if we had the query in question before our eyes!!

Thanx for the help... I just hope my code works for him .