TSQL - Handling multiple CTEs

with

       cte(Num) as

       (

              select 1 as Num

              union all

              select 1.2

       )

       , cte2(Num2) as

       (

              select 2 as Num2

       )

select *

from

       cte cross join cte2

;

MacOSX - Booting tricks

You can use these key combinations when your computer has problems, strange booting behaviors, etc.

• Disk checking: Command + R
• PRAM reset: Command + Option + P + R
• SCM reset: Shift + Control + Option + POWER BUTTON, then POWER BUTTON

TSQL - String search within stored procedures

SELECT

       Name

FROM

       sys.procedures

WHERE

       OBJECT_DEFINITION(OBJECT_ID) LIKE '%RecoveryDuration%'

;