Skip to main content

Posts

Find slow running queries on MS SQL Server

Source Below query will helps you find the queries which have taken a lot of time in milliseconds. To confirm that you have query performance issues on your SQL Server instance start by examining queries by their execution time. SELECT     req.session_id     , req.total_elapsed_time AS duration_ms     , req.cpu_time AS cpu_time_ms     , req.total_elapsed_time - req.cpu_time AS wait_time     , req.logical_reads     , SUBSTRING (REPLACE (REPLACE (SUBSTRING (ST.text, (req.statement_start_offset/2) + 1,        ((CASE statement_end_offset            WHEN -1            THEN DATALENGTH(ST.text)              ELSE req.statement_end_offset          END - req.statement_start_offset)/2) + ...

How show date in Day-Month-Year in Siebel

  There are two ways one is that you change the date format on server level but this will cause issue like if you are getting date in business component and parsing it with some business rule and when you change the date format you need to modify operation everywhere. Below solution is simple and easy to execute. Follow below simple steps to achieve your desired date format. Open Siebel Tools. In Tool go to Applet and query the applet where you want to change the date display format. Now from list or control query the desired date field. Scroll right or use tab to find the "Display Format". Now from below you can make your own date format. For example as per my requirements I am using "DD-MMM-YYYY" after compiling the applet on UI date will display "21-Sep-2022". Format mask Description: YYYY or yyyy four digit year such as 2017 YY or yy last two digits of year such as 17 M month with no leading zero 1-12 MM Two digit month 01-12 MMM Three letter month suc...

How to watch DC movies and TV series in order 2022

Below is the list of DC Movies and TV series in release order: Man of Steel (2013) Batman vs Superman: Dawn of Justice (2016) Suicide Squad (2016) Wonder Woman (2017) Justice League (2017) Aquaman (2018) Doom Patrol Season 1 (2019)(TV series) Shazam! (2019) Joker (2019) Doom Patrol Season 2 (2020)(TV series) Birds of Prey: And the Fantabulous Emancipation of One Harley Quinn (2020) Wonder Woman 1984 (2020) Zack Snyder’s Justice League (2021) The Suicide Squad (2021) Doom Patrol Season 3 (2021)(TV series) Peacemaker Season 1 (2022)(TV series) The Batman (2022) See Also: How to watch the Marvel movies and TV series in order 2022  

How to watch the Marvel movies and TV series in order 2022

Below is the list of Marvel Movies and TV series in release order: Iron Man (2008) The Incredible Hulk (2008) Iron Man 2 (2010) Thor (2011) Captain America - The First Avenger (2011) The Avengers (2012) Iron Man 3 (2013) Thor The Dark World (2013) Captain America The Winter Soldier (2014) Guardians of the Galaxy (2014) Avengers Age of Ultron (2015) Ant-Man (2015) Captain America Civil War (2016) Doctor Strange (2016) Guardians Of The Galaxy Vol. 2 (2017) Spider-Man Homecoming (2017) Thor Ragnarok (2017) Black Panther (2018) Avengers Infinity War (2018) Ant-Man And The Wasp (2018) Captain Marvel (2019) Avengers Endgame (2019) Spider Man Far From Home 2019 WandaVision (2021)(Disney Plus series) Falcon and the Winter Soldier (2021)(Disney Plus series) Loki (2021)(Disney Plus series) WandaVision(2021)(Disney Plus series) Falcon and the Winter Soldier (2021)(Disney Plus series) Black Widow (2021) What If...? (2021)(Disney Plus series) Shang-Chi and the Legend of the Ten Rings (2021) Etern...

Tax Return Filing Required Documents FBR Pakistan

  Below are the requirements for filing the tax return in FBR Pakistan. Please note that financial duration of a year is  July of last year to June of current year . Electricity, Gas, Telephone Bills (July of last year to June of current year). Mobile Phone Tax Certificates (July of last year to June of current year). Bank Statements of all Bank Accounts (July of last year to June of current year). Bank Payments slip of any withholding tax deposit if any (July of last year to June of current year). Provide details of any asset (property, Vehicle etc.)  & Liabilities (i.e. buying or selling any assets Plot, House, Car, Bike, Gold, Bank or Personal Loan(s) etc.) bought (July of last year to June of current year). Provide Company stamped tax certificate if you are a job holder (July of last year to June of current year). Details of any amounts received from foreign if any (July of last year to June of current year). Bank Accounts Details with IBANs. In URDU: ایف بی آر پا...

How to kill a Windows service which is stuck in Stopping status

In Windows service, you stop the service but it returned an error and stuck in "Stopping" status. In this case you need to kill the service so you can start again. There are two solutions for either you can restart the machine but if this machine is a server and it is not possible than you need to kill the service manually. For killing the service process please follow below steps: Get the Service Name: Go into Services and double click on the Service which has stuck in "Stopping" status.  Make a note of the "Service Name". Find out the PID of the service: Open a command prompt and type in: sc queryex [service_name] Replace this [service_name] with the name you copied from previous step. Copy of the PID Kill the PID: In the same command prompt type in: taskkill /f /pid [PID] Replace this [PID] with process number you copied from previous step. If it is successful you should receive the following message: SUCCESS: The process with PID XXXX has been termin...

How to enable Internet Information Services on Winodws 10

Go to Control Panel > Programs and Features. On Left Most click on "Turn Windows Features on or off" hyperlink. Form the new Window, click on "Internet Information Services" check box. Click on "OK" button. Windows will search for its packages and enable the services. When process completed click on "Close" button. Click on Windows button and type "iis" and now click on "Internet Information Services (IIS) Manager".  All Done.