GajaKesari Posted September 23, 2014 Author Report Posted September 23, 2014 okasari move chesina records next time malli pick avvakoodadu
ramu Posted September 23, 2014 Report Posted September 23, 2014 okasari move chesina records next time malli pick avvakoodaduoka stored proc raasi...trigger lo danni call cheyyi... with in proc nuvvu records ni filter cheyyali....
GajaKesari Posted September 23, 2014 Author Report Posted September 23, 2014 oka stored proc raasi...trigger lo danni call cheyyi... with in proc nuvvu records ni filter cheyyali.... example untey ikkada vey bhayya
ramu Posted September 23, 2014 Report Posted September 23, 2014 example untey ikkada vey bhayya calling stored proc in trigger ani google cheyyi ... inka stored proc logic is ur requirement dependent...nenu mobile dbing so konchem difficult. .. :)
GajaKesari Posted September 23, 2014 Author Report Posted September 23, 2014 calling stored proc in trigger ani google cheyyi ... inka stored proc logic is ur requirement dependent...nenu mobile dbing so konchem difficult. .. :) k
loveindia Posted September 23, 2014 Report Posted September 23, 2014 To ManchiBoy and others.. Using a trigger for selecting the amount of inserts done is a slow and heck of a process. It wastes lots of IO usage and during etl things will work very very slow.. Also for this trigger you are suggesting he should be using a loop to call all the inserts which will take a while to load all the records and will definitely exceed more than 30 minutes of time frame if he is looking at 100+Million records... If the tables reside in the same databases, speed will be a little okay but if they are spanned across different databases it will be a challenge as well. To ManchiBoy, There is an option called MERGE in sql server, which can get you to what you want. What MERGE statement does is, it will select only the changes or new inserts or deletes which ever you want between two different tables you have. This will be your fastest and safest bet to work with. Put all the code inside a sql proc and call it as a job every 30 minutes or as per your requirement. I wrote an article regarding how to use MERGE step by step. http://sqlsaga.com/sql-server/how-to-capture-changes-between-source-and-destination-using-merge-statement/ good luck reading. Don't forget to like SQLSAGA's facebook fan page :P
GajaKesari Posted September 23, 2014 Author Report Posted September 23, 2014 ee beerbob neeku thanks chepthunnadu bye1 To ManchiBoy and others.. Using a trigger for selecting the amount of inserts done is a slow and heck of a process. It wastes lots of IO usage and during etl things will work very very slow.. Also for this trigger you are suggesting he should be using a loop to call all the inserts which will take a while to load all the records and will definitely exceed more than 30 minutes of time frame if he is looking at 100+Million records... If the tables reside in the same databases, speed will be a little okay but if they are spanned across different databases it will be a challenge as well. To ManchiBoy, There is an option called MERGE in sql server, which can get you to what you want. What MERGE statement does is, it will select only the changes or new inserts or deletes which ever you want between two different tables you have. This will be your fastest and safest bet to work with. Put all the code inside a sql proc and call it as a job every 30 minutes or as per your requirement. I wrote an article regarding how to use MERGE step by step. http://sqlsaga.com/sql-server/how-to-capture-changes-between-source-and-destination-using-merge-statement/ good luck reading. Don't forget to like SQLSAGA's facebook fan page :P
dotnetrockz Posted September 23, 2014 Report Posted September 23, 2014 okasari m,ove chesinavi malli move cheyyakudadhu ante row identifier orevery row ki oka flag undali and u shud mark that flag as true if the record is read
dotnetrockz Posted September 23, 2014 Report Posted September 23, 2014 To ManchiBoy and others.. Using a trigger for selecting the amount of inserts done is a slow and heck of a process. It wastes lots of IO usage and during etl things will work very very slow.. Also for this trigger you are suggesting he should be using a loop to call all the inserts which will take a while to load all the records and will definitely exceed more than 30 minutes of time frame if he is looking at 100+Million records... If the tables reside in the same databases, speed will be a little okay but if they are spanned across different databases it will be a challenge as well. To ManchiBoy, There is an option called MERGE in sql server, which can get you to what you want. What MERGE statement does is, it will select only the changes or new inserts or deletes which ever you want between two different tables you have. This will be your fastest and safest bet to work with. Put all the code inside a sql proc and call it as a job every 30 minutes or as per your requirement. I wrote an article regarding how to use MERGE step by step. http://sqlsaga.com/sql-server/how-to-capture-changes-between-source-and-destination-using-merge-statement/ good luck reading. Don't forget to like SQLSAGA's facebook fan page :P bro nee site lo cheppina adventure works dw 2012 database mdf file ekkada nunchi download chesavu? i tried d/l but every file is corrupt or not able to attach to db
loveindia Posted September 23, 2014 Report Posted September 23, 2014 okasari m,ove chesinavi malli move cheyyakudadhu ante row identifier orevery row ki oka flag undali and u shud mark that flag as true if the record is read idea good but extra memory man for that bit flag.. MERGE will do same sheeeeeet behind the scenes...... :)
loveindia Posted September 23, 2014 Report Posted September 23, 2014 bro nee site lo cheppina adventure works dw 2012 database mdf file ekkada nunchi download chesavu? i tried d/l but every file is corrupt or not able to attach to db http://msftdbprodsamples.codeplex.com/releases/view/55330 enjoy man... Good Luck Coding...
Recommended Posts