Tuesday, April 03, 2012

A couple things I learned about databases today

1 - In DB2, the following pseudocode doesn't work:
define cursor
open cursor
while (not end of cursor)
   make table update
   commit;
 end-while
close cursor

The reason?  The "commit;" statement closes your cursor!  you'll have to commit after exiting your loop.

2 - In SQL Server, you can end up with a database that has no owner.  (!)
To correct this, us the sp_changedbowner system stored procedure.
example: sp_changedbowner 'sa'

A more thorough treatment of this topic can be found here.

Crazy ...

No comments:

Get Restart log using PowerShell

I'm often curious about a restart on a Windows server system. An easy way to get a list of the restart and what initiated it is to use t...