Wednesday, August 21, 2013

The lie of multitasking

The ability to perform multiple activities at once is usually regarded as an asset. Recent research may prove that wrong.
For most of my career, multitasking, the ability to perform multiple activities at once, has been regarded as an asset. Managers have encouraged their staff to multitask, and IT leaders frequently speak of employees who are effective multitaskers in a positive light.
However, recent research into how the brain functions suggests that multitasking isn't the asset we once thought, and that those long-admired employees and peers are more likely better at focusing and shifting on single tasks, rather than possessing some super-human ability to simultaneously perform multiple tasks. Previously, the brain was regarded much like the processor in our computers and phones. You could allocate a percentage of the processor's overall capacity to a task, and the task would be completed commensurate with the allocation it received. If a particular task took one minute using 100% of the processor, you could do two similar tasks in two minutes, since each would receive 50% of the computing capacity.

Multitasking in the field

Unlike our computers, the human brain's capacity to process degrades significantly the more tasks it's trying to manage. Rather than a 50% reduction in performance when trying to do two similar tasks at once, the reduction tends to be more in the area of 80-95%.
For a ready example of how ineffective we are at multitasking, do some "field research" during your next conference call. Even a task as banal as triaging email or playing Solitaire significantly degrades one's ability to follow the conversation, and is far more likely to be the source of "I'm sorry, could you repeat that" than is some technical problem with the telephone connection.

So, what's going on with multitasking mavens?

While the research clearly indicates the human brain struggles to perform multiple tasks at once, most of us have met people who have a seemingly inhuman ability to perform several distinct activities under pressure. However, if you study these people, they tend to gather a collection of tasks, sequence them logically, and then focus with laser-like intensity on a single activity. These are the people who are not fondling their smartphones in meetings or stopping to open their email application every time the new email beep occurs. Rather than performing several activities at once, they're able to focus on a single activity, then rapidly shift to the next activity.

Practical multitasking

To apply these lessons to your own organization, stop trying to foster some inhuman ability to simultaneously perform multiple tasks. At best, this is frustrating and results in poor performance, and at worst, costs your organization significantly in terms of lost productivity and inferior output. A critical component of managing multiple tasks is gathering and prioritizing each, so work to develop your task management and tracking capabilities. This might be a well-defined system and set of tools, or merely sitting for a few moments and gathering your thoughts before jumping to the next email or beeping device.
Finally, work on applying 100% of your focus to the task at hand. For example, the quality and speed of my writing increased significantly when I disabled all the notifications on my workstation, so I could write an article unmolested by tweets, emails, likes, and other distractions. Even in conversations, you'll find the other party responding with more excitement and engagement when you devote 100% of your mental energy to the conversation and the speaker.
With these easily applied techniques, you can become far more efficient at managing multiple tasks and using the human mind to its most effective capacity. While this may seem subtly nuanced from the old idea of multitasking, try these techniques for a day or two and you'll notice a world of difference.

MS SQL Datetime conversion

-- MSSQL Server string to date conversion - datetime string format sql server
-- MSSQL string to datetime conversion - convert char to date sql server
SELECT convert(datetime, 'Oct 23 2012 11:01AM', 100) -- mon dd yyyy hh:mmAM (or PM)
 
SELECT convert(datetime, 'Oct 23 2012 11:01AM') -- 2012-10-23 11:01:00.000
 

-- Without century (yy) string date conversion - convert string to datetime
SELECT convert(datetime, 'Oct 23 12 11:01AM', 0) -- mon dd yy hh:mmAM (or PM)
SELECT convert(datetime, 'Oct 23 12 11:01AM') -- 2012-10-23 11:01:00.000
 

-- Convert string to datetime sql - convert string to date sql - sql dates format
-- T-SQL convert string to datetime - SQL Server convert string to date
SELECT convert(datetime, '10/23/2016', 101) -- mm/dd/yyyy
SELECT convert(datetime, '2016.10.23', 102) -- yyyy.mm.dd
SELECT convert(datetime, '23/10/2016', 103) -- dd/mm/yyyy
SELECT convert(datetime, '23.10.2016', 104) -- dd.mm.yyyy
SELECT convert(datetime, '23-10-2016', 105) -- dd-mm-yyyy
 
-- mon types are nondeterministic conversions, dependent on language setting
SELECT convert(datetime, '23 OCT 2016', 106) -- dd mon yyyy
SELECT convert(datetime, 'Oct 23, 2016', 107) -- mon dd, yyyy
-- 2016-10-23 00:00:00.000
SELECT convert(datetime, '20:10:44', 108) -- hh:mm:ss
-- 1900-01-01 20:10:44.000
 
-- mon dd yyyy hh:mm:ss:mmmAM (or PM) - sql time format
SELECT convert(datetime, 'Oct 23 2016 11:02:44:013AM', 109)
-- 2016-10-23 11:02:44.013
SELECT convert(datetime, '10-23-2016', 110) -- mm-dd-yyyy
SELECT convert(datetime, '2016/10/23', 111) -- yyyy/mm/dd
SELECT convert(datetime, '20161023', 112) -- yyyymmdd
-- 2016-10-23 00:00:00.000
SELECT convert(datetime, '23 Oct 2016 11:02:07:577', 113) -- dd mon yyyy hh:mm:ss:mmm
-- 2016-10-23 11:02:07.577
SELECT convert(datetime, '20:10:25:300', 114) -- hh:mm:ss:mmm(24h)
-- 1900-01-01 20:10:25.300
SELECT convert(datetime, '2016-10-23 20:44:11', 120) -- yyyy-mm-dd hh:mm:ss(24h)
-- 2016-10-23 20:44:11.000
SELECT convert(datetime, '2016-10-23 20:44:11.500', 121) -- yyyy-mm-dd hh:mm:ss.mmm
-- 2016-10-23 20:44:11.500
SELECT convert(datetime, '2008-10-23T18:52:47.513', 126) -- yyyy-mm-ddThh:mm:ss.mmm
-- 2008-10-23 18:52:47.513
 

-- Convert DDMMYYYY format to datetime
SELECT convert(datetime, STUFF(STUFF('31012016',3,0,'-'),6,0,'-'), 105)
-- 2016-01-31 00:00:00.000
-- SQL string to datetime conversion without century - some exceptions
SELECT convert(datetime, '10/23/16', 1) -- mm/dd/yy
SELECT convert(datetime, '16.10.23', 2) -- yy.mm.dd
SELECT convert(datetime, '23/10/16', 3) -- dd/mm/yy
SELECT convert(datetime, '23.10.16', 4) -- dd.mm.yy
SELECT convert(datetime, '23-10-16', 5) -- dd-mm-yy
SELECT convert(datetime, '23 OCT 16', 6) -- dd mon yy
SELECT convert(datetime, 'Oct 23, 16', 7) -- mon dd, yy
SELECT convert(datetime, '20:10:44', 8) -- hh:mm:ss
SELECT convert(datetime, 'Oct 23 16 11:02:44:013AM', 9)
SELECT convert(datetime, '10-23-16', 10) -- mm-dd-yy
SELECT convert(datetime, '16/10/23', 11) -- yy/mm/dd
SELECT convert(datetime, '161023', 12) -- yymmdd
SELECT convert(datetime, '23 Oct 16 11:02:07:577', 13) -- dd mon yy hh:mm:ss:mmm
SELECT convert(datetime, '20:10:25:300', 14) -- hh:mm:ss:mmm(24h)
SELECT convert(datetime, '2016-10-23 20:44:11',20) -- yyyy-mm-dd hh:mm:ss(24h)
SELECT convert(datetime, '2016-10-23 20:44:11.500', 21) -- yyyy-mm-dd hh:mm:ss.mmm

ITWORLD
If you have any question then you put your question as comments.

Put your suggestions as comments