Viewing 15 posts - 18,121 through 18,135 (of 18,926 total)
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...
April 16, 2005 at 6:11 am
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...
April 15, 2005 at 3:59 am
Sorry, I usually have a global connection called MyCn, which I simply open and close when I need to connect to the database.
April 14, 2005 at 10:41 am
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...
April 14, 2005 at 9:25 am
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...
April 14, 2005 at 9:17 am
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.
April 14, 2005 at 9:04 am
Select * from dbo.MyTable where date_field between dateadd(d,0, datediff(d, 0, getdate())) and dateadd(d,1, datediff(d, 0, getdate()))
April 14, 2005 at 9:03 am
Why r u having a dynamic table name??
That's completely besides the point of a stored proc.
April 14, 2005 at 9:00 am
Actually db_ddladmin should be enough why dbo access??
April 14, 2005 at 7:55 am
Maybe there are more than 75 connections on the server.. or 75 'tasks' running.
April 14, 2005 at 7:17 am
If you say so... I'm neither human nor mvp nor primate
.
April 14, 2005 at 6:42 am
Just a quick note :
isnumeric ('.') = 1 and it can't be converted to a float... might be worth checking it out.
April 13, 2005 at 12:30 pm
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...
April 13, 2005 at 11:35 am
Viewing 15 posts - 18,121 through 18,135 (of 18,926 total)