(Xaprb) If you’ve ever wished you could see MySQL’s EXPLAIN output formatted as a tree, now you can. MySQL Visual Explain transforms EXPLAIN output into a hierarchical view of the query plan, which is significantly easier to read and understand.
Other News
Setting up a Linked Server for a Remote SQL Server Instance
(Gregory A. Larsen) Sometimes an application may need data stored in another database on a different instance of SQL Server. That different instance might be on the same physical machine or might be on another machine altogether. So what do you do in this situation? Your options depend on your data
RBAR: ‘Row By Agonizing Row’
(Remi Gregoire) If, like me, you have not had the valuable experience of working in a Very Large Database Environment (VLDB), you may have done some ‘Row by agonising row’ (RBAR) programming without seeing too many bad results. But as time goes by, and as the Databases grow larger, the consequences
Which is Faster — (1) Copy and Local Bulk Insert or (2) Bulk Insert across Network?
(Linchi Shea) A while back, I was asked which of the following two bulk insert options would be faster: –Copy/Bulk Insert: First copy the data file from server B to server A, and then bulk insert the data into a table on server A –Bulk Insert across Network: Directly bulk insert the data from
Watch the Latest Weekly SQL Server Show, Posted Today
Watch the Latest Weekly SQL Server Show, Posted Today SelectViews: SQL injection protection tips, cross-site scripting, overall security tips. First-Ever Minicast on SQL Server Surface Area Tools, 60 second SQL Server tip and much more. Watch the show, posted weekly to SSWUG.ORG and open access to all. This week features our first "mini-cast" and a new player feature that lets […]
(76) SelectViews: SQL injection protection tips, cross-site scripting, overall security tips.
Video Programming for IT Professionals
Using Scripting to Help Manage Your Databases
Featured Article(s) Using Scripting to Help Manage your Databases I was discussing my issue with this Windows Admin friend of mine, and he suggested that we use a script to get all the information that I needed. After speaking with him for only a few minutes, I was surprised at how much he claimed that he could do with a […]
Ask Ben: Selecting All Text Nodes Of An XML Document
(Ben Nadel) I like all your xpath stuff you have been doing in ColdFusion. Can you help get the text values of my xml document?
The State of Native XML Databases
(Elliotte Rusty Harold) I’ve recently been asked by several people to summarize the state of native XML databases for those interested in exploring this space. IMHO, native XML databases are now roughly where relational databases were circa 1994: solid, proven technology that gets the job done but o
Implementation Restricted Relaxed in Oracle 11g
(Alex Nuijten) If you are a regular user of the FORALL statement, you are probably also familiar with this message: PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records