You've requested...

Share this with your colleagues:

Download this next:

How to create effective SQL server databases

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 and determining the data types that are best suited to the organization’s needs.

Some of the ways that data type choices affect SQL include:

  • The ability for DBAs to write more efficient code
  • Unintended performance impacts, such as unnecessary page splitting
  • The efficiency of an execution plan
  • And more

Read this white paper to learn about all of the ways that data type choices can affect SQL Server database performance.

These are also closely related to: "Docmosis V2.0"

  • JSON: SQL++ vs SQL:2016

    In this whitepaper, Don Chamberlin (co-designer of the original SQL) compares SQL++ and SQL:2016 – two quite different SQL-based approaches to querying JSON data. SQL++ creates a new SQL-based language specifically for JSON data, while 2016 allows JSON documents to be stored in columns of tables.

    The paper introduces both languages, looks at example queries written in each, and analyzes their pros and cons. You’ll learn how SQL++ can enable you to: 

    • Use your existing SQL skills with a more flexible data format
    • Shorten your queries by about 3x compared with SQL:2016
    • Operate on JSON data without converting it to or from relational data

  • Determine what NoSQL database is best for your use case

    Choosing a new database is always an overwhelming process—particularly when you’re choosing to move to a NoSQL system.

    While NoSQL databases are often marketed as a one size fits all solution, their best use cases are often much more focused. You’re likely looking for a database that can handle:

    • Queues
    • Metadata
    • Searches
    • Data ingestion
    • Or more

    Read this white paper to help determine what NoSQL solution is best for your specific needs, instead of rushing into the wrong database.

Find more content like what you just read:

  • First edition of Computer Weekly 1966

    To celebrate Computer Weekly's 50th anniversary, the National Museum of Computing, which holds the print archives of the magazine, has scanned the first issue of Computer Weekly. We have made this available to download.


  • Leverage data virtualization to flesh out and solve security flaws

    In the world of big data, everything that could potentially be useful is stored. It is often left in a variety of locations, formats, and secured in different ways, creating a security nightmare. Read this white paper to learn how TIBCO’s data virtualization can help your company improve its security stance and protect key data for analytics.


  • Switching databases: From SQL Server to NoSQL

    More and more companies are moving from SQL Server and other relational databases to NoSQL to power their critical web, mobile, and IoT applications. This white paper describes potential upsides to NoSQL and clarifies the important difference between SQL and NoSQL databases.


  • How Dremio secures your data

    Because data sets and analytics systems are valuable targets for cybercriminals, it is important that your data access and analysis systems provide a variety of security options so that you can protect your organization’s data from potential threats. Read the attached guide to see some security choices that the data lake engine Dremio offers.


  • Autonomous storage optimization: 8 top use cases

    Access this e-book to explore a self-driving software-defined storage model that can respond and adapt to changes in the internal or external environment in order to optimize performance and capacity as needed.


  • Best practices guide for using SDS and MySQL

    There is always room for improvement and with MySQL, that means optimizing storage choice and policy-based, template-driven tuning capabilities. Access this white paper to learn about an SDS solution that maximizes the value of MySQL by managing performance level requirements across different services and types of applications.


  • Fraud Detection in Healthcare: a step-by-step guide to incorporating machine learning

    There are many AI-based use cases that span the healthcare industry, all with the goal of improving patient care. Access this white paper to learn the 3 basic types of anomalies that may be detected and to learn how to confront the challenges of fraud and anomaly detection with 4 AI and ML-based approaches.


  • Query optimization: A step by step guide

    How do you improve the performance of SQL queries? Read this e-book to learn about the various techniques that can be deployed to make your SQL queries more effective.


  • Dataiku vs. Excel: Who comes out on top?

    Dataiku has compiled a "guidebook" for businesses that are currently still using Microsoft Excel for all their data management and analytic needs. If you fit the bill, check out this e-book for an intensive comparison between the two platforms.


  • How to create a remote work and flexible schedule policy

    Not only does remote work cut company costs and improve employee happiness and job satisfaction, but it’s also becoming a key benefit to attract and retain top talent. Download this white paper for tips on crafting remote work, flexible schedule and working from home policies.


  • Prefab data centers: Quantifying the rack density impact

    In this white paper, you will quantify the capital cost differences between prefabricated vs. traditional data centers, as well as learn why prefabrication does not come at a capex premium. Access this paper to discover the impact of rack density for both designs, and discover a side-by-side architecture comparison between prefab and "stick built".


  • Make enterprise budgeting easier with an enterprise planning management software

    In this e-book, learn how to prepare your business for success with a modernized financial process. Discover the value of an enterprise performance management (EPM) software, and review how an EPM software can help your organization make budgeting easier, improve employee satisfaction, and more.


  • Machine Learning Applications for Banking Fraud Detection

    AI-based systems can augment regulatory alert systems and improve analysts’ workflow by reducing noise without discarding results. Access this paper to view the 3 types of anomalies to look out for, understand examples of how banks use fraud and anomaly detection, and learn how to build a basic, machine learning-based fraud detection system.


  • 6 steps to data modeling with Apache Cassandra

    This white paper covers a methodical approach that can be useful in approaching Cassandra data modelling, focusing on 3 simple principles and 6 steps that implement the principles.


  • Hands-on Oracle Application Express security

    This book extract demonstrates how Oracle Application Express (APEX) can be vulnerable to SQL injection, using sample code.


  • 5 common pitfalls of relying on Excel for financial planning

    This white paper will walk you through the 5 signs that you may be abusing Excel for your planning needs and show you how you can take advantage of the capabilities that you appreciate while avoiding its numerous pitfalls.


  • Leveraging machine learning in your IT environment

    In today's expanding and increasingly intricate IT environments, how exactly can IT filter through all events as they occur to solve system issues as they arise? Learn more about intelligent event analytics, designed to recognize patterns and anomalies within your system's activity and take steps to resolve problems instantly.


  • Best practices for your AWS cloud data warehouse

    Amazon has stepped in and supplied a quality cloud data warehouse solution with Amazon Redshift, but businesses can still face challenges including difficulty querying data, loading data into Redshift inefficiently, and more. Read this e-book by Matillion to find out how to procure the most value from your Amazon Redshift data warehouse.


  • Effective print management

    Analysts Louella Fernandes and Clive Longbottom offer tips on developing an effective print management strategy.


  • Building a flexible data center: Prepare for future growth

    This feature eGuide offers answers for all of the potential data center questions you may be having as you embark on your journey to build a flexible data center in this down economy. Download now and identify some of the required factors for your data center construction.


  • Use network data to power DX with Riverbed

    In this product overview, learn about Riverbed® SteelConnect™ Analytics and how it can help IT organizations analyze, visualize, and unleash the power of network data to transform their digital business.


  • How to use low-code for complex business rules

    Creating complex business rules with decision tables is a time-consuming coding project that can bog down developers when having to write hundreds of lines of code. Download this whitepaper, which explains how low-code features reduce several development chores that come with decision table construction.


  • 6 IT priorities for financial crime protection

    Download this financial intelligence whitepaper, which overviews 6 priorities for financial institutions to consider, and a key understanding of intelligence tools that can enhance data protection.


  • CW+: Quocirca Report: 21st century enterprise print services

    Despite the huge growth in electronic communications, printed output, whether internally produced or externally procured, is still widely used in 21st century businesses.


  • Moving from relational to NoSQL: How to get started

    This white paper explains the need for non-relational databases, describes advantages of NoSQL, and clarifies the important difference between SQL and NoSQL databases.


  • AI & content management: The perfect pair

    One of the most exciting areas in which AI has already made a strong impact is content management. From personalized content and asset tagging to content production and A/B testing, read this white paper to explore some of the biggest opportunities for IT teams when it comes to AI and content management.


  • Understand, predict and minimize customer loss

    Churn is when a company loses a customer - and mostly every business will have to deal with this sooner than later, because it has the power to plateau growth. Read this white paper to learn how to use predictive analytics to predict and prevent customer loss.


  • Case study: Microsoft Dutch HQ glimpses the future

    Microsoft has turned its Dutch headquarters into a radical experiment which the company believes could point the way to the future of the workplace. Its office at Schiphol airport has done away with dedicated desks and offices and it has given employees the freedom to chose where, when and how they work.


  • Machine learning has its eye on traditional data warehousing

    This Eckerson Group report details 3 new approaches to data-driven environments that are replacing traditional approaches of data warehousing. Learn how the downsides of traditional data warehousing are being tackled by these new methods and with less need for data modeling.


  • Couchbase vs. MongoDB for query

    This whitepaper explores how the popular NoSQL databases Couchbase and MongoDB™ differ in their approach to query. Among many key differences, you'll learn that only Couchbase provides developers with the power and familiarity of SQL. And you'll learn why only Couchbase offers strong support for ANSI join constructs and advanced query optimization.


  • Overcoming the top 7 phone verification challenges

    No consumer wants to be the victim of fraud or the recipient of unwelcome spam, and no app or service provider wants to unwittingly harbor spammers or fraudsters. In this e-book, learn how to increase conversion rates and onboard users at global scale with phone verification.


  • The importance of digital identity management

    Customer identities are among the most critical and valuable assets of any organization. Failing to provide adequate security can result in financial, reputational, and even legal consequences. This paper highlights industry best practices for building customer trust through comprehensive security programs. Read on to learn more.


  • Data-driven organization design

    This extract from Data-driven Organization Design by Rupert Morrison provides a practical introduction for HR and organisation design practitioners, to using analytics to transform their organisations.


  • How to build a scalable, modern data center network

    Download this white paper to learn how you can build a scalable, robust, and agile data center network—without breaking the bank—by using fixed form factor switches (FFF) and disaggregated network operating systems in a leaf/spine Clos architecture.


  • 5 must-have ETL automation functions

    By automating part or all of the ETL process, your data scientists can be left to focus on higher level projects, not manage menial, repetitive tasks. Read the attached e-book to learn the essential steps you should consider as you automate your ETL and data ingestion processes, as well as questions to ask AND five must-have automation functions.


  • Models for evaluating SDDC storage performance

    The need has never been greater for a storage performance model that can achieve business velocity and operational agility. Download this white paper to learn how to achieve optimal storage performance inthe SDDC and the several measurements that go into creating a successful storage performance tracking model.


  • An e-book on data virtualization and the logical data warehouse

    Read this white paper to learn about the Logical Data Warehouse, and to find out just how it can improve business intelligence and decision-making throughout your organization.


  • Rack flexibility and cost-reduction to keep your data center ahead

    As big data, IoT, and cloud technology reshapes enterprises at a rapid pace, data centers are under pressure to deploy IT faster and at a larger scale than ever. Discover how a freestanding frame and containment system can deliver the rack flexibility and physical cost-efficiencies to keep ahead of changing data center needs.


  • CW+: Quocirca report: Effective public sector citizen communication

    The UK public sector is in the midst of a period of transformation and improving citizen engagement will be key to the success of this change.


  • Integrating IT and facility departments for a cohesive data center team

    Although it often seems as though the IT and facilities departments are from different planets, integrating the two groups has become more important than ever for the efficient and cost-effective data center operations. This expert e-book explores how effective communication between IT and facilities can improve your organization's bottom line.


  • How to make the most out of your data lake architecture

    Most organizations deposit their raw data in data lakes, where it can be stored easily. But it can require a complex series of programs, tasks, and pipelines to leverage this data into analytics insights.Read this guide to learn how Dremio can use your data lake and allow your business to derive analytics insights directly from your data.


  • Centralize network management in the cloud

    Find out how to create reliable, secure, mobile-friendly Wi-Fi connectivity for your organization's users, especially in industries like education and retail that rely more and more on the interactions between people and technology.


  • Evaluation of managed print service suppilers

    In Quocirca’s evaluation of major providers of Managed Print Services (MPS) in Europe, Quocirca found that Xerox and HP  lead the pack, due to their  global scale and broad service capabilities. The analysis also showed that Ricoh and Lexmark  have gained considerable ground, demonstrating effective maturity and service delivery excellence.


  • What is a vulnerability disclosure policy?

    Download this article to find out what a vulnerability disclosure policy (VDP) is, what's included in a good policy, which organizations have a VDP today, and which government agencies have published guidance on VDPs.


  • Host a more effective sales call with the help of videoconferencing software

    While the use of video has gone mainstream in the workplace, there’s still ample opportunity for sales teams of all sizes to leverage the power of videoconferencing. In this white paper, find advice on how to host a more effective sales call with the help of videoconferencing software.


  • Top RPA vendors, ranked and compared

    Inside this 38-page Gartner Magic Quadrant report, take a closer look at the market forces causing RPA technology to surge in popularity. Then, see how the top enterprise RPA vendors on today’s market stack up against one another in terms of machine learning capabilities, pricing, governance features, and more.


  • Open Information Security Management Maturity Model (O-ISM3)

    The O-ISM3 is The Open Group framework for managing information security and information in the Open Information Security Management Maturity Model (O-ISM3) wider context. It aims to ensure that security processes in any organization are implemented so as to operate at a level consistent with that organization's business requirements.