The solution is to use SQL views, materialized views, or create a new table that contains only the filtered data the user needs.

If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even ...

While temporal data support is something that has existed in the past within other database platforms, it is a newly available feature with the RTM version of SQL Server 2016. In case you haven't ...

A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a virtual table to simplify queries and add a layer of security to your base ...

Your upcoming session at SQL Server Live!/Live! 360 talks about the "best and worst practices for indexing tables within your SQL Server 2000-2016 database." ...

I've got this view defined on two tables, one of which has an identity field that auto increments. There seems to be no way to insert into this view. If I leave the auto-increment field blank it ...

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.