Viewing 15 posts - 33,481 through 33,495 (of 59,102 total)
Fine! I'll take the last word. 😉 No one has or is denying you your personal opinion. I say, again, that you did a great job...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 9:46 pm
That still doesn't say much about the performance, Drew. How many rows are you processing with this and about how long does it take? 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 5:34 pm
ark.trofman (6/25/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 5:31 pm
drew.georgopulos (6/24/2011)
thanks so much...its doing what i need.
drew
It looks like you could have a whole lot of rows in the source table. How's the performance with the recursive CTE...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 1:34 pm
jkp2311 (6/25/2011)
Hi Bitbucket....I will follow the method as Lutz told me as well as jefferson..
but let me know the good material about CTEs.
so i can learn
Thanks a lot all people...
My...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 1:28 pm
Do you do any index maintenance on the subscriber side? If not, page and extent splits may be the cause.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 1:23 pm
Charles Kincaid (6/24/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 1:21 pm
venugopal.machina (6/24/2011)
what are the features and benifits of database tuning advisor?
Gosh... look it up in Books Online. Figure out your own answer to the interview/test question. At least...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 1:15 pm
I absolutely agree, Orlando. The ONLY times I use Table Variables is when I have to and there are only two places where I have to...
1. In User...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 12:58 pm
I believe that setting up the view as a "Partioned View" may help... a LOT!. Please lookup "Partitioned View" in Books Online on how to correctly set one up...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 12:46 pm
kamaleshray (6/25/2011)
Thanks for reply, Actualy I want to set the next value for Identity .
But now i got one sql to do this
DBCC CHECKIDENT (TableName , RESEED, value...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 12:42 pm
Jim Murphy (6/25/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 12:28 pm
ark.trofman (6/25/2011)
Jeff Moden (6/25/2011)
ark.trofman (6/24/2011)
So, please, could you learn English first, and then look from your unreachable heights down at the people who try to publish here ?
You were doing...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 12:26 pm
jkp2311 (6/24/2011)
Thanks for Posting your reply.
It will be helpfull to on millions of way.
That's the logic what i want.
I guess it will be helpful all members of our community
who...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 12:20 pm
I think it odd that people say "Bulk Insert is too picky". It checks for errors in the data and, when it finds an anomoly, it creates an error....
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2011 at 12:10 pm
Viewing 15 posts - 33,481 through 33,495 (of 59,102 total)