Reboot Windows 7, Windows 2008 Automatically

1.   Launch Task Scheduler.

2.   Click Action and select Create Basic task.

3.   Type AutoRestart (or others you want) in the Name box and click Next.

4.   Select Daily and click Next

5.   Type the time you want to restart the computer and click Next.

6.   Select Start a program and click Next.

7.   Click Brower and navigate to %SystemRoot%\System32 and select Shutdown.exe and click Open. Type /F /R in the Add arguments (optional) box and click Next.

8.   Click Finish.

Can't Install Microsoft SQL Server 2008 Management Studio Express

Do you have Windows 7 64Bit and you are trying to install SQL Server 2008 Management Tools and cannot?

{Programming} & Life has the long answer at this link

Here is the short answer from the same site.

FIX – INSTALL BACKWARDS!

So that’s the logic, install everything backwards:

First the SQLManagementStudio_x64_ENU.exe to install your tools, and then SQLEXPR_x64_ENU.exe to install your database services. Or perhaps if you are happy with an all in one package, go for this guy – Microsoft® SQL Server® 2008 Express with Tools it’ll probably save you a lifetime of headaches. Don’t try to be tricky like me and get separate installs.

Oracle PL/SQL Cursors - For Loop and Using a Record

Here are two variations of looping through rows in Oracle PL/SQL.  The FOR structure reduces the amount of code, in either case is it more perference than anything else.

---------------------------------- 
--Cursor - For Loop
----------------------------------    
for i in (select constraint_name, table_name
          from all_constraints
          where constraint_type = 'R'
          and owner = lv_owner
          and status = 'ENABLED')  
  LOOP
  execute immediate 'alter table ' || i.table_name ||
                    ' disable constraint ' || i.constraint_name || '';
end loop;

----------------------------------
--Cursor - For each record
----------------------------------     
declare cursor csr is    
          select constraint_name, table_name
                    from all_constraints
                    where constraint_type = 'R'
                    and owner = lv_owner
                    and status = 'ENABLED';
                    
 begin
   for rcd in csr
    loop          
     execute immediate 'alter table ' || rcd.table_name ||
                       ' disable constraint ' || rcd.constraint_name || '';
    
    end loop;
  end;