Table types in sql server

are read only

check time of specific parts of sp's

SELECT  requests.session_id,
        requests.status,
        requests.command,
        requests.statement_start_offset,
        requests.statement_end_offset,
        requests.total_elapsed_time,
        SUBSTRING(details.text,
                  requests.statement_start_offset / 2,
                  (requests.statement_end_offset - requests.statement_start_offset) / 2)  as problem
FROM    sys.dm_exec_requests requests
CROSS APPLY sys.dm_exec_sql_text (requests.plan_handle) details
WHERE   requests.session_id > 20
ORDER BY total_elapsed_time DESC

special characters in blogspot

have to be encoded

e.g. <

ListView I couldnt see my columns

I was covering them with a toolbar

Linq works with IEnumerable <T >

not  IEnumerable
use a cast to get LINQ on a  IEnumerable<T>

Encrypt with File

            File.Encrypt(@"c:\temp\a.txt");

            File.Decrypt(@"c:\temp\a.txt");

The filename in windows turned green , the file is readable to the account that did the encryption

for some reason -  the encryption tab in properties was empty

2 usings

This is a valid statement in C#

using(StreamWriter sw = new StreamWriter(@"c:\temp\b.txt"))

            using (StreamReader sr = new StreamReader(@"c:\temp\a.txt"))

            {

                sw.Write(sr.ReadToEnd());

            }