Viewing 15 posts - 661 through 675 (of 824 total)
are you using tblxxx as a kind of temp table?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 10, 2005 at 3:01 pm
Yes, that's my point. What if the INSERT fails? The UPDATE still happens but you will now be setting the addressID in tblSponsor to NULL.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 10, 2005 at 2:17 pm
Do not neglect the error checking and transaction control. If the first insert fails for some reason, your code would still attempt to update tblSponsor.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 10, 2005 at 1:11 pm
Try something like this...although I still think it's not a smart thing to split your addresses off like this given what you've said about the subject.
CREATE PROCEDURE dbo.Sponsor_Create_Address
AS
SET NOCOUNT...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 10, 2005 at 12:58 pm
It all depends on the situation. If you have no choice but to have IIS and SQL on the same box, and can't upgrade the box, then you have to...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 9, 2005 at 10:49 am
The easiest way is to use Enterprise Manager, right click on your server name, go to properties. Click on Processor and then you have a listing of available processors. Just...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 8, 2005 at 1:34 pm
ALTER DATABASE tempdb
REMOVE FILE templog2
where templog2 is the logical name of the extra log file, not the physical name.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 8, 2005 at 1:27 pm
This may not be a bug at all. If you are running a fairly "large" transaction; say updating all 10000 rows at a time, there might not be enough room...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 8, 2005 at 1:15 pm
Just one last thought... I will reiterate that if I were in your place, I'd be calling MS. At $250 per incident (worst case) it probably doesn't take much of...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 8, 2005 at 1:06 pm
I didn't really "rule out" a problem with the log file, but it seems doubtful since you would expect to see a host of other problems if that were the...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 8, 2005 at 12:24 pm
I have never seen anything like this in nine years. The only things that I've seen that could explain this is either the compressed volume thing (although you wouldn't see...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 8, 2005 at 12:03 pm
What is the point of splitting off the addresses into a seperate table? If each sponsor can have only one address then it is an attribute of the sponsor and...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 7, 2005 at 4:32 pm
I don't believe the BCP has a published limit to the number of rows it can handle. I know that I have used it to handle a table with over...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 7, 2005 at 4:02 pm
Run the following query on your server:
select serverproperty('IsClustered')
If it returns 1 you have a clustered server. If this is the case there are several steps you need to take to...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 7, 2005 at 3:42 pm
Is this by any chance a clustered instance?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 7, 2005 at 2:43 pm
Viewing 15 posts - 661 through 675 (of 824 total)