)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON IDENTITY(1,1) NOT NULL,ĬONSTRAINT PRIMARY KEY CLUSTERED Next is our table, we will populate it with test data also:
#ADVENTUREWORKS2012 QUERIES CODE#
The user name path in the code above, please replace it with your own, or directly from within SSMS, right click and select Create New Database and name it AdventureWorks2012. sys.sp_addextendedproperty 2012 Sample OLTP Database’ĪLTER DATABASE SET READ_WRITE = ‘enable’ĪLTER DATABASE SET ANSI_NULL_DEFAULT OFFĪLTER DATABASE SET ANSI_NULLS ONĪLTER DATABASE SET ANSI_PADDING ONĪLTER DATABASE SET ANSI_WARNINGS ONĪLTER DATABASE SET ARITHABORT ONĪLTER DATABASE SET AUTO_CLOSE ONĪLTER DATABASE SET AUTO_SHRINK OFFĪLTER DATABASE SET AUTO_UPDATE_STATISTICS ONĪLTER DATABASE SET CURSOR_CLOSE_ON_COMMIT OFFĪLTER DATABASE SET CURSOR_DEFAULT GLOBALĪLTER DATABASE SET CONCAT_NULL_YIELDS_NULL ONĪLTER DATABASE SET NUMERIC_ROUNDABORT OFFĪLTER DATABASE SET QUOTED_IDENTIFIER ONĪLTER DATABASE SET RECURSIVE_TRIGGERS OFFĪLTER DATABASE SET DISABLE_BROKERĪLTER DATABASE SET AUTO_UPDATE_STATISTICS_ASYNC OFFĪLTER DATABASE SET DATE_CORRELATION_OPTIMIZATION OFFĪLTER DATABASE SET TRUSTWORTHY OFFĪLTER DATABASE SET ALLOW_SNAPSHOT_ISOLATION OFFĪLTER DATABASE SET PARAMETERIZATION SIMPLEĪLTER DATABASE SET READ_COMMITTED_SNAPSHOT OFFĪLTER DATABASE SET HONOR_BROKER_PRIORITY OFFĪLTER DATABASE SET RECOVERY SIMPLEĪLTER DATABASE SET MULTI_USERĪLTER DATABASE SET PAGE_VERIFY CHECKSUMĪLTER DATABASE SET DB_CHAINING OFFĪLTER DATABASE SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )ĪLTER DATABASE SET TARGET_RECOVERY_TIME = 0 SECONDSĪLTER DATABASE SET DELAYED_DURABILITY = DISABLEDĪLTER DATABASE SET QUERY_STORE = OFFĪLTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0 ĪLTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET MAXDOP = PRIMARY ĪLTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF ĪLTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET LEGACY_CARDINALITY_ESTIMATION = PRIMARY ĪLTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON ĪLTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET PARAMETER_SNIFFING = PRIMARY ĪLTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF ĪLTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET QUERY_OPTIMIZER_HOTFIXES = PRIMARY ĮXEC. IF (1 = FULLTEXTSERVICEPROPERTY(‘IsFullTextInstalled’))ĮXEC.
![adventureworks2012 queries adventureworks2012 queries](https://tbarari.files.wordpress.com/2016/12/graph.jpg)
( NAME = N’AdventureWorks2012_Log’, FILENAME = N’C:\Users\ YOURUSERNAME\DataBases\AdventureWorks2012_Data_log.ldf’, SIZE = 1536KB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
![adventureworks2012 queries adventureworks2012 queries](https://sqlag.com/wp-content/uploads/2018/08/Query-Store-sql.jpg)
( NAME = N’AdventureWorks2012_Data’, FILENAME = N’C:\Users\ YOURUSERNAME\DataBases\AdventureWorks2012_Data.mdf’, SIZE = 209920KB, MAXSIZE = UNLIMITED, FILEGROWTH = 16384KB )
![adventureworks2012 queries adventureworks2012 queries](http://www.sqlservergeeks.com/wp-content/uploads/kanchanbhattacharyya/sql-server-join-hint-execution-plan/HashJoinQueryPlan.jpg)
We will use one table in AdventureWorks2012 SQL Server Database called .įirst, below is the script to create a SQL Server Database : When screen, on any device is zoomed out, it will look like this: