Viewing 15 posts - 11,401 through 11,415 (of 18,923 total)
It's quite possible and actually the best possible plan you can have. So unless you re getting unexpected results, you are golden to move forward with it.
October 30, 2006 at 11:51 am
Are you telling us that the proc fails, or does not insert data without throwing an error??
You can check if the rowcount (@@rowcount) is greater than 0 in the proc. ...
October 30, 2006 at 11:48 am
SET PROTECT_PRODUCTION_DATA_INTEGRITY_MODE ON --> this setting should be ON at all times !
Thanx Rudy, I hadn't laughed that much in a long time. Not that it's funny topic...
October 30, 2006 at 11:44 am
Well again the question stands. Do the users complain about poor performance on that application? If they only wait like half a second a few times a day and it's...
October 30, 2006 at 11:39 am
Thanx for the link... been wanting to send it to a few users but I never had time to search for it!!!
Is it a revised version from the CD version...
October 30, 2006 at 11:33 am
I'm almost glad to see that I was not the only one have slowliness issues with SSMS. Is it really that slow???
And yes please keep QA working with at least...
October 30, 2006 at 11:27 am
Are you sure that you are connecting to the right server instance. Is it possible that the upgrade tool in fact creates another server instance and that both the old...
October 30, 2006 at 9:50 am
2 questions :
1 - How many users / programs are hitting the server at the same time (talking at the same millisecond here).
2 - Is it too slow now...
October 30, 2006 at 9:46 am
The defragmentation made the indexes more usable because they would get faster data access than doing a table scan. This means that the server changed its execution plan on the...
October 30, 2006 at 9:42 am
EXEC sp_dbcmptlevel 'DbName'
But since you don't know about that, I'm assuming you didn't manually alter it, so that would make them level 80.
However I have no clue on how to...
October 30, 2006 at 9:19 am
From the original code :
if @OUT is not null or ltrim(rtrim(@OUT))<>''
For the statement to return true, only 1 of the 2 parts need to be true, not both...
October 30, 2006 at 6:47 am
If I may post some of the same details :
CREATE TABLE [tblABC] (
[fldID] uniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT [DF_tblABC_fldID] DEFAULT (newid()),
[fldNote] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[fldDate]...
October 30, 2006 at 6:32 am
Put everything in the dynamic sql statement... I'll look more into Monday when I have access to a server.
October 28, 2006 at 7:27 am
as we said '' is NOT NULL so it will always return true.
October 28, 2006 at 6:30 am
set @error2 = ''
there for @error2 IS NOT NULL
this should do it :
IF NULLIF('', @OUT) IS NOT NULL
begin
end
October 27, 2006 at 1:13 pm
Viewing 15 posts - 11,401 through 11,415 (of 18,923 total)