Viewing 15 posts - 736 through 750 (of 920 total)
I believe that the general consensus in the group is that the best practice is to store the images in a file system and the paths to the images, along with...
June 20, 2006 at 4:51 pm
Does it think the stuff in the double quotes is a column name? If so, the database options may be set to QUOTED_IDENTIFER ON, and that can be turned off...
June 19, 2006 at 5:55 pm
The proc it's complaining about is the one you're explicitly executing and not a proc called by the one you're calling?
Are you sure the database context actually points to the correct...
June 19, 2006 at 4:40 pm
Is the procedure owned by dbo? If not, you'll have to qualify the ownere when you call it, or change the owner to dbo.
June 17, 2006 at 11:10 am
My guess is that the data on the two systems is different. If you remove the sub-query and run it by itself, do you get one result on the production...
June 15, 2006 at 10:52 am
What sort of performance improvement were they expecting to get from a smaller log? Do they know where the performance bottleneck is, or is just a guess?
June 12, 2006 at 2:19 pm
If by 'I don't have the database on my computer' you mean you don't have any version of the SQL Server engine installed on your computer, you won't be able to...
June 7, 2006 at 1:11 pm
Could you also post the code that calls the function and the code that checks the return?
May 23, 2006 at 6:04 pm
Tough to know what to do without knowing what symptoms the problems you are experiencing exhibited. The numbers above don't necessarily point to anything without a better context. If you were...
May 22, 2006 at 6:41 pm
It's not unusual for queries to run faster the second time. The data is probably still in memory during the second execution and therefore all the physical IO is avoided.
There...
May 22, 2006 at 6:20 pm
CREATE Procedure select_Proc1
@Key3 varchar(10)
As
BEGIN
IF (@key3 IS NULL)
BEGIN
Select key3
From Or_Table
END
ELSE
BEGIN
Select key3
From Or_Table
Where
END
END
May 20, 2006 at 8:27 am
Could you post the table DDL and the XML file (or a sample of it)? I might have some time to play with this tomorrow. It's been a while since...
May 16, 2006 at 6:31 pm
You can't have the 'END' after the OPENXML. It breaks up the insert in an unacceptable manner.
May 16, 2006 at 6:09 pm
How about this? I moved the 'END' from the middle of the insert.
ALTER PROCEDURE [dbo].[Users_Update_Phones_2]
@UserName nvarchar(256) = null
,@SqldocPhone
varchar
May 16, 2006 at 5:40 pm
It's hard to tell without knowing what the primary key actually is (phone? phoneid?) but here's a rough guess.
IF (x.PhonesID = 0 OR...
May 16, 2006 at 5:03 pm
Viewing 15 posts - 736 through 750 (of 920 total)