(Andrew Reid) Many applications need to use the same value in several different places. The examples below show a net value and a tax figure being added to create a gross amount. The tax figure is calculated by multiplying the net value by the tax rate.
Author: SSWUG Research
MySQL, GROUP BY, Select lists, and Standard SQL
(Peter Gulutzan) The MySQL manual says: “In standard SQL, a query that includes a GROUP BY clause cannot refer to nonaggregated columns in the select list that are not named in the GROUP BY clause.”
You Take Too Long
(dfitzjarrell) Sometimes statements take longer than you’d like to complete. This can happen for a number of reasons including data changes, table growth, stale statistics and the occasional optimizer bug you haven’t encountered before. When it’s a SQL query that is misbehaving it’s pretty easy to f
libdb2.so.1: cannot open shared object file: No such file or directory – … ibm_db.so
(Leons Petrazickis) Got this error while deploying a Rails app on Nginx:
In-Memory OLTP Index Troubleshooting, Part II
With the In-Memory OLTP feature in SQL Server 2014 we introduce two new types of indexes for memory-optimized tables: the memory-optimized NONCLUSTERED indexes, and the memory-optimized HASH indexes.
Add a Tooltip to Simple XML Tables with Bootstrap and a Custom Cell Renderer
(Jason Conger) I recently created a dashboard that displayed some information from the Windows Event Logs in a table. The “Message” field was important, but took up a lot of screen real estate.
Change an item Label dynamically
(Jeff Kemp) Need to change the label of an item on-the-fly? When I run my Apex page it renders item labels like this:
The Change Management Perspective of the DBA
(Craig S. Mullins) The DBA is the custodian of database changes. Usually, the DBA is not the one to request a change; that is typically done by the application owner or business user. But there are times, too, when the DBA will request changes, for example, to address performance reasons or to util
ASP.NET MVC Custom Action Filters
(Suprotim Agarwal) Filters in ASP.NET MVC are a way to apply cross-cutting logic at the controller level. Some examples of cross-cutting logic is Security and Logging. Security is a cross cutting concern because, once enabled, we need to apply it for all incoming requests in the web Application.
Shortcut to Script Individual Columns from a Table-Valued Function in SSMS
(Melissa Coates) I noticed recently that if you use SQL Server Management Studio to script out a Select statement from a table-valued function, SSMS generates a Select *. In the following screen shot, I’m scripting out a Select statement from a table-valued function that’s in the AdventureWorks2012