Query Languages

WHITE PAPER: Data type choices can have a significant impact on your database design and performance. A best practice is to "right-size" data types by asking business questions that are best suited to the organization's needs. Read this white paper to learn about all of the ways that data type choices can affect SQL server database performance.

Posted: 09 Nov 2018 | Published: 09 Nov 2018

EGUIDE: Read this white paper to discover product features and expert advice on whether to upgrade to the newest versions of SQL Server: 2008 R2 and Denali.

Posted: 13 Feb 2012 | Published: 30 Jan 2012

EZINE: In this issue, we drill down on the facts of NoSQL databases, tapping into the experiences of savvy startups and other companies whose needs led them to NoSQL technologies. But is NoSQL right for you? Companies with fast-growing vaults of Web, social media, demographic and machine data should pay attention. IT experts chime in with timely advice.

Posted: 04 Apr 2014 | Published: 04 Apr 2014

WHITE PAPER: This brief resource examines the true value of Apache Hive, a SQL engine for the Apache Hadoop framework. Inside, learn how Hive's facilities for data and metadata management are impacting the existing warehouse infrastructure and driving business success.

Posted: 29 May 2013 | Published: 31 Mar 2013

EGUIDE: MySQL, under Oracle's stewardship, has sometimes been viewed with suspicion and seen as an open source icon that has been co-opted. Learn how COO Alexander Culiniac and other experts a reconciling their positive experience with MySQL and the public's doubts about Oracle's intention with the database.

Posted: 29 Jun 2017 | Published: 27 Jun 2017

WHITE PAPER: This paper will discuss how Vertica enhances the capabilities of analytical work through the implementation of different architecture for relational database-based analytical work. By simply rotating the orientation of the database from rows to columns, dramatic improvements in load and query speed, scalability and cost effectiveness are achieved.

Posted: 29 Aug 2011 | Published: 01 Sep 2009

EGUIDE: Read this expert e-guide to learn how SQL Server consolidation can help you cut costs and increase efficiency. Discover why many companies are choosing to consolidate several databases on different physical servers into a single SQL Server and the metrics you must consider before doing so.

Posted: 18 Apr 2012 | Published: 18 Apr 2012

EGUIDE: In this TechTarget e-guide we sit down with two seasoned SQL Server experts as they relay their experience SQL Server 2016. Access this e-guide and you'll find out how SQL Server 2016 is already better tuning queries, identifying problematic workloads and much more.

Posted: 03 Feb 2016 | Published: 01 Feb 2016

WHITE PAPER: Access this paper to see how a leading acceleration system combined with SQL Server in-memory OLTP improves customer experience by boosting system response time and business productivity.

Posted: 27 May 2014 | Published: 27 May 2014

WHITE PAPER: Find out how NoSQL databases can help your company meet the growing amounts of data in a manageable and usable fashion for BI. This paper gives an in-depth example at how MongoDB provides NoSQL benefits, as well as leveraging data in real-time, the benefits of document-oriented data, and examples of how users have implemented this to their BI.

Posted: 27 Aug 2012 | Published: 01 May 2012