In MariaDB and MySQL, cursors create a temporary table.
Does this statement deserve a whole blog post? Apparently not. However, in some cases one does not expect a temporary table to be created: 195 more words
Although I had different topics planned for my first blog, but I just received this client issue this morning, and I decided to share it with you to explain how to take advantage of the powerful information contained in the oracle trace files. 1,268 more words
Just lately I have been going back over CDC in SQL, I’m planning on taking the Microsoft Certs so I thought I better had :) and I wondered if a simpler process could be achieved, I wondered this as I wanted something simpler for my own stuff as I thought CDC was more than I needed. 943 more words
In store procedures, sometimes you need to get some specific value/s or the entire row/s then make some changes on them or send these values to another store procedures. 199 more words
Citrix XenDesktop/XenApp 7.6 FP3 has introduced enhanced architecture to support both 24-bit and 32-bit advanced cursors. Historically remoting protocols have supported simpler cursors but with an increase in the use of complex and larger cursors for complex CAD and 3D applications, Citrix has introduced a new architecture to support such cursors on-going. 217 more words