Data types in the character string category include:
Author: SSWUG Research
BI for DBA – SQL Server BI Development practices – strategy and tools
(SQLMaster) As a DBA how many times were you involved in BI development related projects?
Comment lines: Looping versus recursion for improved application performance
(Brian S Paskin) No matter the purpose or scale of an application, performance is always a critical factor. Looping and recursion are comparable but different methods for computational coding.
Troubleshooting Excess Compilations in SQL Server Using the Plan Cache and PowerShell
(Derek Colley) You are seeing evidence of an excessive number of query compilations or recompilations in SQL Server. This may be manifesting itself as high CPU load, or longer transaction execution times. You need to identify which queries are causing this behavior and identify potential solutions t
Simple jquery Plugin In Details
(Ehtesam Ahmed) jquery is the most popular javascript library amongst web developers. If you have some knowledge of jquery, you may be familiar with code like
Schema Design in MongoDB vs Schema Design in MySQL
(Stephane Combaudon) For people used to relational databases, using NoSQL solutions such as MongoDB brings interesting challenges. One of them is schema design: while in the relational world, normalization is a good way to start, how should we design our collections when creating a new MongoDB appli
Columnstore Indexes in SQL Server 2012
(Robert Sheldon) The columnstore index in SQL Server 2012 stores columns instead of rows, and is designed to speed up analytical processing and data-warehouse queries. Whilst columnstore indexes certainly do that effectively, they are not a universal panacea since there are a number of limitations o
How to Move a Database That Has Database Snapshots
(David Browne) Database snapshots cannot be attached/detached, so how do you move a database that has database snapshots to a different disk location?
12c Asynchronous Global Index Maintenance Part II (The Space Between)
(Richard Foote) In Part I, I discussed how global indexes can now be asynchronously maintained in Oracle 12c when a table partition is dropped or truncated. Basically, when a table partition is dropped/truncated with the UPDATE GLOBAL INDEXES clause, Oracle simply keeps track of the object numbers o
DB2 for z/OS and WebSphere Integration for Enterprise Java Applications
(Paolo Bruni, Zhen Hua Dong, Josef Klitsch, Maggie Lin, Rajesh Ramachandran, Bart Steegmans and Andreas Thiele) IBM DB2 for z/OS is a high-performance database management system (DBMS) with a strong reputation in traditional high-volume transaction workloads that are based on relational technology.