(Ben Snaidero) In an ideal world all of our queries would be optimized before they ever make it to a production SQL Server environment, but this is not always the case. Smaller data sets, different hardware, schema differences, etc. all effect the way our queries perform.
Other News
Database Upgrades
Database Upgrades With the recent release of SQL Server 2012 you now have more opportunities with your installations. Now the questions of upgrades, support for earlier versions, multiple version support, reverse compatibility and much more emerge once again. For those of you who have never experienced a release of a new version of SQL Server there is a lot to […]
XML Serialisation and System.Drawing.Color
(Brad Smith) I’m currently doing some work in the area of cross-AppDomain development, where all objects are either marshalled (transparently) using .NET Remoting or serialised. It turns out that, when DataSet objects are serialised, their extended properties are serialised as strings.
MySQL DELETE Join example
(Jan Brinkmann) A very useful helper in your join toolbox can be a delete join. Even though it’s not a special join type but a join used within DELETE statements, it’s still worth mentioning. However, from time to time when I want to make use of delete joins on my own, I somehow managed it to forgo
IBM Information Management Software Portfolio Overview
(Frank Fillmore) The recording of April 5, 2012 webinar “IBM 2012 Information Management Product Strategy and Portfolio Overview” is located here.
SQL SERVER – DMV sys.dm_exec_describe_first_result_set_for_object – Describes the First Result Metadata for the Module
(Pinal Dave) Here is another interesting follow up blog post of SQL SERVER – sp_describe_first_result_set New System Stored Procedure in SQL Server 2012. While I was writing earlier blog post I had come across DMV sys.dm_exec_describe_first_result_set_for_object as well.
Examples for Creating Oracle Functions
(Mika Wendelius) After contributing few articles on Microsoft SQL Server, I thought it would be a good time to do something Oracle specific. This first Oracle article of mine describes some basic tasks but extends to more advanced features.
Bind Countries to a DropDownList in ASP.NET
(Rohatash Kumar) Today, I have provided an article showing you how to get a list of all countries and bind them to a DropDownList in ASP. NET. There are many ways in which a user can get a list of all countries. Here, we use the CultureInfo class to get a list of all countries. It’s easy to implemen
Parsing Large XML Documents in Ruby
(Bill Rawlinson) Today I was given a fairly large XML file (roughly 32 Mb) that I needed to parse in order to see if there was a match between a concatenation between two node values and the contents of a separate file that had comma separated values in it. Always looking for an excuse to use a dif
Comparing Number of SQL Executions to get LOV Description Without Entity Association Available
(Andrejus Baranovskis) When speaking about performance, ADF developers should not rely only on the framework and do blind development. Its a must to check form performance proactively using different methods – AM pool disabled, JMeter stress test and finally monitor number of SQL executions. As for