1 - In DB2, the following pseudocode doesn't work:
while (not end of cursor)
make table update
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.
I doubt that this comes up often, but I find myself in a bit of an argument about what isolation level will be used for transactions in our ...
Microsoft Technet has published an article that includes some rules of thumb for sizing a SQL Server system. NOTE: These are for sharepoin...
The Soft and Melting Duck Egg Meditation: (Moving the yang qi from the head) When Master Hakuin was just starting out upon his Zen c...