GitHub

create-database-scoped-credential-transact-sql.md

[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw ...
IEEE

Dynamic Materialized Views

Abstract: A conventional materialized view blindly materializes and maintains all rows of a view, even rows that are never accessed. We propose a more flexible materialization strategy aimed at ...
fingerlakes1

Oracle Schema Compare – How to Do It With These 5 Easy Tools

Have you experienced breaking an app because you forgot to add or update new database objects? That’s one hell of a disruption to your users. Doing some Oracle schema compare could have avoided the ...
GitHub

querying-the-sql-server-system-catalog-faq.yml

[!INCLUDE[sql-asdb-asdbmi-asa-fabricse-fabricdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-fabricse-fabricdw.md)] This topic contains a list of frequently ...
TechRepublic

Passing table valued parameters in SQL Server 2008

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...
TechRepublic

See performance gains by using indexed views in SQL Server

See performance gains by using indexed views in SQL Server Your email has been sent 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 ...