Tuesday, 3 February 2026

DB PRod issues

 Production data transer issue i have faced

not using where update command using transaction
>>tansfer larger amount of data from dev emp table to test emp table mistate first load  less dpendent data
>> functions and tables and veiws 
then sps
>>it taking 40 mnts for 50k records.


at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Capgemini Interview

 capgemini famous interview question List<int> A = new List<int>(); A.add(1); List<int> B=A; B=new List<int>(); B.Ad...

  • wrap text in excel
     if text length big make it next line shorcut is ALt+Enter or cilck on wrap text
  • generate APK using capacitor
     D:\A-MyProjects2024-2025\ReactNative2025\BookRental\android\app\build\outputs\apk\debug path of apk To build an Android app using Capacitor...
  • Dtabase design
      OLX, like many large-scale online platforms, employs a variety of data structures and technologies to manage its data effectively. While s...