I appreciate the way the information was delivered but one thing wrong with what has been presented... Although the domain of GUIDs is huge, NEWID() creates a Type 4 GUID, which is nothing more than a huge random number. Random numbers are NOT guaranteed to be unique even between just two machines, never mind globally.. Despite the extremely low probability of two machines (or even a thousand machines) generating two identical values, there is still the chance of a collision.
Hi Venkat, You must have a donation link or add donation link in every video. You are doing great job and many would voluntarily donate if you provide donation link in the video. I would definitely donate. Lets not get all benefits for free and give some benefit for you for the effort you have put... Or you can make it one time subscription fees or some sort of payed model. Your videos are worth buying...
Hi venkat... I follow all your videos to learn different technology. Thanks for sharing knowledge.. Can you also please make videos on selenium and advanced selenium using c#? this will really help in not only my professional career and also others who all follow your videos ..
Thanks kudvenkat .. All ur Tutorials are Awesome Nd easy to learn .. I lov it n great fan of urs :) Sir I got one doubt .. tht whn u try to insert in identity column y it didn't gave error of cannot insert into identity column .. bcz its auto increment right ? plz explain sir..
Is there a better way to transfer efficiently the contents of 2 tables namely OrderHEaderTmp and ORderDetailTmp to a permanent Table OrderHeader and OrderDetail? The reason is that the Tmp tables are just temporary storage areas of sales to be transfered at the end of the day to the permanent tables , once the records are transferred the data in the tmp tables will be deleted so that it will be faster to save and retrieve and print on the tmp tables for the next day. The reason I did put temporary first is that more and more records will be saved each day and it is not fast to print .
HI, Can you show a demo in sql server to loop through a table and Update, or insert new records , For example, in a table there are some payables that occur each year for every member, I wanted to automate so that instead of adding new records one by one for every member on the payables table then I want to write a stored proc but not quite sure how to do it. Thanks!
I really wanted to thank you so much. Only i want to ask you about my problem, I cannot use bulk insert at Sql server 2012 with codepage 65001, any mistake, is there any Solution?? my code is bulk insert FeedDeFaultGroups from 'C:\mdm_feed_-_default-groups.csv' with ( FIRSTROW = 2, CODEPAGE = '65001', FIELDTERMINATOR = '\t', ROWTERMINATOR = ' ' ) go
Big fan of your SQL playlist - saw all of them last week! Another Guid is NEWSEQUENTIALID: msdn.microsoft.com/da-dk/library/ms189786.aspx Another reason for using Guid is privacy because it is impossible to guess the next id.
you are a really a teacher with good developer I like ur all video.....
This was in my mind to check what is GUID and in morning got the notification kudvenkat has uploaded a video :) this made my day, thank you
Venkat hit puberty?
thank MR.Venkat, it is so nice after so long time you uploaded video.Thankssss
Great! I like how you associate the concepts with the real practices.
Very clear and confident voice. Keep it up!!
what happened with your voice Venkat ?!
:D
I appreciate the way the information was delivered but one thing wrong with what has been presented...
Although the domain of GUIDs is huge, NEWID() creates a Type 4 GUID, which is nothing more than a huge random number. Random numbers are NOT guaranteed to be unique even between just two machines, never mind globally.. Despite the extremely low probability of two machines (or even a thousand machines) generating two identical values, there is still the chance of a collision.
Hi Venkat, You must have a donation link or add donation link in every video. You are doing great job and many would voluntarily donate if you provide donation link in the video. I would definitely donate. Lets not get all benefits for free and give some benefit for you for the effort you have put... Or you can make it one time subscription fees or some sort of payed model. Your videos are worth buying...
csharp-video-tutorials.blogspot.com.eg
you can buy his DVD
You are a perfect teacher.
Hi venkat... I follow all your videos to learn different technology. Thanks for sharing knowledge.. Can you also please make videos on selenium and advanced selenium using c#? this will really help in not only my professional career and also others who all follow your videos ..
Muchas gracias por explicarlo :) me ha servido demasiado, gracias por explicarlo paso a paso!
Glad to see, new one in the List.....Thank You #BrilliantVenkatSir
Hi venkat,
Why you using primary key in I'd column since you set column type as unique identier with default constraint on new id() it's enough?
Another Awesome video. Thank you Sir!
Thanks kudvenkat .. All ur Tutorials are Awesome Nd easy to learn .. I lov it n great fan of urs :)
Sir I got one doubt .. tht whn u try to insert in identity column y it didn't gave error of cannot insert into identity column .. bcz its auto increment right ? plz explain sir..
Is there a better way to transfer efficiently the contents of 2 tables namely OrderHEaderTmp and ORderDetailTmp to a permanent Table OrderHeader and OrderDetail? The reason is that the Tmp tables are just temporary storage areas of sales to be transfered at the end of the day to the permanent tables , once the records are transferred the data in the tmp tables will be deleted so that it will be faster to save and retrieve and print on the tmp tables for the next day. The reason I did put temporary first is that more and more records will be saved each day and it is not fast to print .
HI, Can you show a demo in sql server to loop through a table and Update, or insert new records , For example, in a table there are some payables that occur each year for every member, I wanted to automate so that instead of adding new records one by one for every member on the payables table then I want to write a stored proc but not quite sure how to do it. Thanks!
Thank You Venkat; Thats nice :)
Thanks from Bangladesh.
what if int is not enough? What other options do we have?
I really wanted to thank you so much. Only i want to ask you about my problem, I cannot use bulk insert at Sql server 2012 with codepage 65001, any mistake, is there any Solution?? my code is
bulk insert FeedDeFaultGroups
from 'C:\mdm_feed_-_default-groups.csv'
with
(
FIRSTROW = 2,
CODEPAGE = '65001',
FIELDTERMINATOR = '\t',
ROWTERMINATOR = '
'
)
go
Thanks a lot
awesome explanation
Big fan of your SQL playlist - saw all of them last week!
Another Guid is NEWSEQUENTIALID:
msdn.microsoft.com/da-dk/library/ms189786.aspx
Another reason for using Guid is privacy because it is impossible to guess the next id.
Thank you
I would prefer to listen ur old voice
flawless
Your voice made me jump XD
customers in India John & Ben nice looks like all customers are christians.
Thank you