Stop Memorizing SQL Part 3 : A Practical SQL Cheat Sheet for Beginners

 A Practical SQL Cheat Sheet for Beginners When learning SQL, students often struggle to remember the correct syntax during exams or practic...

  • Oracle Scheduled Jobs
    1. To change the scheduled time of oracle job and force it to run at certain time, use the set_scheduler_attribute procedure.e.g. To start j...
  • Move distribution database to another drive
    Move distribution database to another drive: There are scenarios in SQL server Replication that we need to move datafiles and logfiles of di...
  • Pros and Cons of stored procedures
    * Stored procedures generally result in improved performance because the database can optimize the data access plan used by the procedure an...