This article is a follow-up to one I wrote in August 2017, "How To Set Up a SQL Express Database for Horizon View," in which I detailed how to configure a SQL Server Express database for use with View ...

Indexed views. In SQL Server 2000 and 2005, you have the ability to add indexes to views. But, if a view is just a stored query definition in the database with no data of its own until it is run ...

Nominally, views are named SQL queries. These named-queries can be used within other queries as if they were physical tables. Therefore, inside a given SQL query, users may incorporate tables or views ...

When I am working with an Oracle database, I still find myself using SQL*Plus for many quick and dirty database queries. In particular, I often look up constraints in SQL*Plus. In this post, I ...

Most Common Wait Types in SQL Server and What They Mean. ASYNC_NETWORK_IO—The async_network_io wait types point to network-related issues. They are most-often caused by a client application not ...

That is, all database objects that comprise an individual database (views, triggers, indexes, tables, schema and so on) reside together in one file that defines an SQLite database. Database files are ...