Viewing 15 posts - 3,391 through 3,405 (of 7,429 total)
Try running DBCC DBREINDEX against that table and it's indexes to see if anything in the SP changes. I get a seek when I test on 25000, 50000 and 100000...
February 7, 2003 at 11:48 am
Almost forgot to mention. The process is not limited to Procs. Any WITH ENCRYPTION item can be done this way. And thanks for the additional detail Brian.
February 7, 2003 at 9:56 am
You are right we could argue this till the end of time. My point however was the suggestion (although does work) has some major cosiderations the user needs to know.
For...
February 7, 2003 at 8:25 am
Oops, sorry we are are two different pages here.
With the SP you do this
DECLARE @RegNumber int
--
SELECT @RegNumber = ISNULL( MAX( RegistrationKey ), 0 ) + 1
FROM zMaster
INSERT zMaster VALUES (@RegNumber)
but...
February 7, 2003 at 7:17 am
quote:
As for transaction log, whether you use a procedure or a trigger, you are not limiting the transaction entry in the log....
February 7, 2003 at 6:16 am
Does MakeCode have a lot of duplicates?
Can you tell me the definition of this clustered index [PUMA].[dbo].[CCMakeModel].[IX_CCMakeModel]?
Is this a composite index with more than one column involved and...
February 7, 2003 at 6:04 am
Sorry, can I get the def of GetVehicleMakeByCode UDF. I assume like the SP but want to be sure how you defined it exaclty. Then I will have a way...
February 7, 2003 at 5:37 am
Understand that but I want to be sure nothing is missed here. When tested, even with transaction control keep in mind your INSERTS are running sequentially not syncronously.
Try testing this...
February 7, 2003 at 5:34 am
Not sure why the UDF would be faster but there has to be an underlying factor here. Can you pots some details of the Tables referneced, the SP and UDF...
February 7, 2003 at 5:10 am
Wow what a thread this has become.
Diwakar the point if you look back is to ensure advancing number without gaps.
Although your code does work for a single insert what happens...
February 7, 2003 at 5:00 am
Stored Procedures are presented in a straight forward manner (as far as I think of it, but I do have advantage of several years) in SQL Books Online. I suggest...
February 7, 2003 at 4:54 am
Another way you can do it is to a DTS package file.
Saw this in another thread last night and started to script it to generate and run against all my...
February 7, 2003 at 4:12 am
The method of obj_Name is an off shoot of Hungarian notation commonly used in other programming languages. As I program in C++, VB, etc I prefer this naming convention.
First the...
February 7, 2003 at 4:06 am
Ahh, I didn't catch that previously. Was look at this late lastnight. Yes a straight SELECT with no conditions is going to perform a Scan. It will look for the...
February 7, 2003 at 4:00 am
Duplicate thread. Please keep comments in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=9837&FORUM_ID=8&CAT_ID=1&Topic_Title=UDF%27s+vs+Procs&Forum_Title=T%2DSQL
February 7, 2003 at 3:54 am
Viewing 15 posts - 3,391 through 3,405 (of 7,429 total)