How to power off iPhone without using screen

[ iPhone ] 14 Oct 2021

Typically, the iPhone can be powered off by holding the power button and volumn up button. Then you can slide the bar on the screen to power it off.

But what if the screen is freezing unresponsive. If you keep holding power button and volum up button, instead of power off the phone, it is going to send emergency SMS to some number. Thuat is not what you want.

Here is what you can do:

Make sure screen if off
Hit the volumn up button
Then Volum Down button
Then holding the power button until the device restarts

The last three steps needs to be pretty fluid. In this way, the device will be restarting without touching the screen.

Hope it helps!

Some useful SQL scripts

[ sql database ] 13 Sep 2021

Collection of some SQL script

How to find the number of bytes per row

-- This query will return which table uses the most space and start from there
--  In some case, this query is faster than the select COUNT(*) from *TABLE_NAME*
select 
    o.name, 
    max(s.row_count) AS 'Rows',
    sum(s.reserved_page_count) * 8.0 / (1024 * 1024) as 'GB',
    (8 * 1024 * sum(s.reserved_page_count)) / (max(s.row_count)) as 'Bytes/Row'
from sys.dm_db_partition_stats s, sys.objects o
where o.object_id = s.object_id
AND o.type='U' -- Only want to know the user table
group by o.name
having max(s.row_count) > 0
order by GB desc

How to delete large amount of data from tables

If you want to delete all data

Truncate table TABLE_Name

Once the table is truncated, the database might not release the space immediately. In this case, run the following command

DBCC SHRINKDATABASE (N'YouDbName')

If you want to delete records meet certain criteria

DECLARE @Deleted_Rows INT;
SET @Deleted_Rows = 1;


WHILE (@Deleted_Rows > 0)
  BEGIN

   BEGIN TRANSACTION

   -- Delete some small number of rows at a time
     DELETE TOP (10000)  LargeTable 
     WHERE readTime < dateadd(MONTH,-7,GETDATE())

     SET @Deleted_Rows = @@ROWCOUNT;

   -- Below two line will ensure the log file from increasing
   COMMIT TRANSACTION
   CHECKPOINT -- for simple recovery model
END

QDC SLG