Sql Optimization

https://www.simple-talk.com/sql/performance/basic-sql-server-performance-troubleshooting-for-developers/

Where to get free ftp

http://www.sftp.net/public-online-sftp-servers

We need to create SP which will return only those columns where value is different in 2 rows. 2 rows will be identify by Row No OR primary key which developer need to investigate over it.
https://stackoverflow.com/questions/2768688/is-there-a-way-to-select-nth-column-in-a-select-clause-from-a-table-view
https://stackoverflow.com/questions/2768688/is-there-a-way-to-select-nth-column-in-a-select-clause-from-a-table-view
https://stackoverflow.com/questions/653714/insert-results-of-a-stored-procedure-into-a-temporary-table

To Do

Q: How to know which button click is fired in c#
Ans:
   If sender Is Button1 Then
      s = "button1"
   ElseIf sender Is Button2 Then
      s = "button2"
   End If

Q: How to call one button click event in another
Ans:
  protected void btnSaveChanges_Click(object sender, EventArgs e)
  {
    btnContinue_Click(sender, e);
  }

"File has invalid value ">>>>>>> .mine". Illegal characters in path."
Ans: Delete the /obj folder in each project that is complaining and re-compile.

How to save/capture audio/video/screenshot during discussion.
Ans: https://www.techsmith.com/jing.html
        Download software from above link create account and then use.

How to serialize object in c#
Ans:
    public string SerializeObject(object oObject)
    {
      StringWriter swWriter = new StringWriter();
      XmlTextWriter twWriter = null;
      string sXmlFormate = string.Empty;
      try
      {
        XmlSerializer serializer = new XmlSerializer(oObject.GetType());
        twWriter = new XmlTextWriter(swWriter);
        serializer.Serialize(twWriter, oObject);
        sXmlFormate = swWriter.ToString();
      }
      catch (Exception ex)
      {
        Errorcl.HandleException(ex, false);
      }
      finally
      {
        swWriter.Close();
        twWriter.Close();
      }
      return sXmlFormate;
    }

How to set SecurityProtocol in website
Ans:System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls;

How to check current enable protocol in site?
Ans: string sTesting = System.Net.ServicePointManager.SecurityProtocol.ToString();