You pretty much said it yourself... You have the same cost but with 33% more rows in the select so one option seems better than the other. While I...

Counter_answer : that's already too many if you want my opinion. But I guess that it may become handy in very large data warehouses to be able to add...

Go buy one or contact idera for an extended trial version. You'll be lucky if you don't get banned from this board with a post like that.

[EDITED]

It's strange that...

How would check on the server to find the source of the deadlock and resolve that first. And then I'd have the err handler rerun the query whenever it...

Sorry, I usually have a global connection called MyCn, which I simply open and close when I need to connect to the database.

on the server

:

CREATE PROCEDURE [dbo].[SPN_DemoReturn] @SomeParam as int, @SomeOutput as int output

AS

SET NOCOUNT ON

--do usefull

SET @SomeOutput = 14

RETURN 1

SET NOCOUNT OFF

GO

in vb

Private Function exec_SPN_DemoReturn(ByVal SomeParam As Integer, ByRef SomeOutput As...

Nope, the datediff operation must be executed in order to check for equality to 0. There are really only a few functions that you can run that won't force...

PW's solution will work but it will force an index scan, my solution will allow for a range seek which can give a great performance boost.

Select * from dbo.MyTable where date_field between dateadd(d,0, datediff(d, 0, getdate())) and dateadd(d,1, datediff(d, 0, getdate()))

Why r u having a dynamic table name??

That's completely besides the point of a stored proc.

Actually db_ddladmin should be enough why dbo access??

Maybe there are more than 75 connections on the server.. or 75 'tasks' running.

If you say so... I'm neither human nor mvp nor primate .

Just a quick note :

isnumeric ('.') = 1 and it can't be converted to a float... might be worth checking it out.

You're right about the top thing, but he's using a temp table to keep the keys that need to be processed and once the work is done he deletes the...