SQL Server 2014 Standard- Original and Genuine!

The key for 1 PC only and download links (for all languages) will be sent to your email after your purchase within 1 hours (usually in minutes).

Cross-Box Scale LimitsFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressMaximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1Operating System maximumLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 1 Socket or 4 coresLimited to lesser of 1 Socket or 4 coresLimited to lesser of 1 Socket or 4 coresMaximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting Services)1Operating system maximumOperating system maximumLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 1 Socket or 4 coresLimited to lesser of 1 Socket or 4 coresLimited to lesser of 1 Socket or 4 coresMaximum memory utilized (per instance of SQL Server Database Engine)Operating system maximum128 GB128 GB64 GB1 GB1 GB1 GBMaximum memory utilized (per instance of Analysis Services)Operating system maximumOperating system maximum64 GBN/AN/AN/AN/AMaximum memory utilized (per instance of Reporting Services)Operating system maximumOperating system maximum64 GB64 GB4 GBN/AN/AMaximum relational Database size524 PB524 PB524 PB524 PB10 GB10 GB10 GB

1Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per SQL Server instance. There are no limits under the Core-based Server Licensing model. For more information, seeCompute Capacity Limits by Edition of SQL Server.

High AvailabilityFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressServer Core support1YesYesYesYesYesYesYesLog ShippingYesYesYesYesDatabase mirroringYesYes (Safety Full Only)Yes (Safety Full Only)Witness onlyWitness onlyWitness onlyWitness onlyBackup compressionYesYesYesDatabase snapshotYesAlwayson Failover Cluster InstancesYes (Node support: Operating system maximumYes (Node support: 2)Yes (Node support: 2)AlwaysOn Availability GroupsYes (up to 8 secondary replicas, including 2 synchronous secondary replicas)Connection DirectorYesOnline page and file restoreYesOnline indexingYesOnline schema changeYesFast recoveryYesMirrored backupsYesHot Add Memory and CPU2YesDatabase Recovery AdvisorYesYesYesYesYesYesYesEncrypted BackupYesYesYesSmart BackupYesYesYesNo

1For more information on installing SQL Server 2014 on Server Core, seeInstall SQL Server 2014 on Server Core.

2This feature is only available for 64-bit SQL Server.

Scalability and PerformanceFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressMulti-instance support50505050505050Table and index partitioningYesData compressionYesResource GovernorYesPartition Table ParallelismYesMultiple Filestream containersYesNUMA Aware Large Page Memory and Buffer Array AllocationYesBuffer Pool Extension1YesYesYesIO Resource GovernanceYesIn-Memory OLTP1YesDelayed durabilityYesYesYesYesYesYesYes

1This feature is only available for 64-bit SQL Server.

SecurityFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressBasic AuditingYesYesYesYesYesYesYesFine Grained AuditingYesTransparent database encryptionYesExtensible Key ManagementYesUser-Defined RolesYesYesYesYesYesYesYesContained for BackupsYesYesYesReplicationFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressSQL Server change trackingYesYesYesYesYesYesYesMerge replicationYesYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Transactional replicationYesYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Snapshot replicationYesYesYesYes (Subscriber onlyYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Heterogeneous subscribersYesYesYesOracle publishingYesPeer to Peer transactional replicationYesManagement ToolsFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressSQL Management Objects (SMO)YesYesYesYesYesYesYesSQL Configuration ManagerYesYesYesYesYesYesYesSQL CMD (Command Prompt tool)YesYesYesYesYesYesYesSQL Server Management StudioYesYesYesYesYesYesDistributed Replay – Admin ToolYesYesYesYesYesYesDistributed Replay - ClientYesNoYesYesDistributed Replay - ControllerYes (Enterprise supports up to 16 clients, Developer supports only 1 client)NoYes (1 client support only)Yes (1 client support only)SQL ProfilerYesYesYesNo2No2No2No2SQL Server AgentYesYesYesYesMicrosoft System Center Operations Manager Management PackYesYesYesYesDatabase Tuning Advisor (DTA)YesYesYes3Yes3Deploy a SQL Server Database to a Windows Azure VM WizardYesYesYesYesYesYesYesSQL Server Data Files in Windows AzureYesYesYesYesYesYesYes

2SQL Server Web, SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services can be profiled using SQL Server Standard and SQL Server Enterprise editions.

3Tuning enabled only on Standard edition features.

RDBMS ManageabilityFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressUser admin connectionYesYesYesYesYes (under trace flag)Yes (under trace flag)Yes (under trace flag)PowerShell scripting supportYesYesYesYesYesYesYesSysPrep support1YesYesYesYesYesYesYesSupport for Data-tier application component operations – extract, deploy, upgrade, deleteYesYesYesYesYesYesYesPolicy automation (check on schedule and change)YesYesYesYesPerformance data collectorYesYesYesYesAble to enroll as a managed instance in a multi-instance managementYesYesYesYesStandard performance reportsYesYesYesYesPlan guides and plan freezing for plan guidesYesYesYesYesDirect query of indexed views (using NOEXPAND hint)YesYesYesYesAutomatic indexed view maintenanceYesYesYesYesDistributed partitioned viewsYesPartial. Distributed Partitioned Views are not updatablePartial. Distributed Partitioned Views are not updatablePartial. Distributed Partitioned Views are not updatablePartial. Distributed Partitioned Views are not updatablePartial. Distributed Partitioned Views are not updatablePartial. Distributed Partitioned Views are not updatableParallel indexed operationsYesAutomatic use of indexed view by query optimizerYesParallel consistency checkYesSQL Server Utility control pointYesContained DatabasesYesYesYesYesYesYesYesBuffer Pool Extension2YesYesYes

1For more information, seeConsiderations for Installing SQL Server Using SysPrep.

2This feature is only available for 64-bit SQL Server.

Development ToolsFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressMicrosoft Visual Studio (Transact-SQL and MDX)YesYesYesYesYesYesYesSQL Server Data Tools (SSDT)YesYesYesYesYesSQL query edit and design tools1YesYesYesVersion control support1YesYesYesMDX edit, debug, and design tools1YesYesYes

1This feature is not available for 64-bit version of Standard edition.

ProgrammabilityFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressCommon Language Runtime (CLR) IntegrationYesYesYesYesYesYesYesNative XML supportYesYesYesYesYesYesYesXML indexingYesYesYesYesYesYesYesMERGE & UPSERT and Time supportYesYesYesYesYesYesYesFull-text and semantic searchYesYesYesYesYesSpecification of language in queryYesYesYesYesYesService Broker (messaging)YesYesYesNo (Client only)No (Client only)No (Client only)No (Client only)Transact-SQL endpointsYesYesYesYesIntegration ServicesFeatureEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressSQL Server Import and Export WizardYesYesYesYesYesYesYesBuilt-in data source connectorsYesYesYesYesYesYesYesSSIS designer and runtimeYesYesYesBasic TransformsYesYesYesBasic data profiling toolsYesYesYesChange Data Capture Service for Oracle by AttunityYesChange Data Capture Designer for Oracle by AttunityYesIntegration Services - Advanced AdaptersFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressHigh performance Oracle destinationYesHigh performance Teradata destinationYesSAP BW source and destinationYesData mining model training destination adapterYesDimension processing destination adapterYesPartition processing destination adapterYesChange Data Capture components by AttunityYesConnector for Open Database Connectivity (ODBC) by AttunityYesIntegration Services - Advanced TransformsFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressPersistent (high performance) lookupsYesData mining query transformationYesFuzzy grouping and lookup transformationsYesTerm extractions and lookup transformationsYesMaster Data Services

Note

• Master Data Services is available on the 64-bit editions of Business Intelligence and Enterprise IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressMaster Data Services databaseYesYesMaster Data Manager web applicationYesYesData WarehouseFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressCreate cubes without a databaseYesYesYesAuto-generate staging and data warehouse schemaYesYesYesChange data captureYesStar join query optimizationsYesScalable read-only Analysis Services configurationYesParallel query processing on partitioned tables and indicesYesxVelocity memory optimized columnstore indexesYesGlobal Batch AggregationYesAnalysis ServicesFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressScalable Shared Databases (Attach/Detach, Read only databases)YesYesBackup/Restore, Attach/Detach databasesYesYesYesSynchronize databasesYesYesHigh AvailabilityYesYesYesProgrammability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL)YesYesYesBI Semantic Model (Multidimensional)Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressSemi-additive intelligenceYesYesYesTime IntelligenceYesYesYesCustom rollupsYesYesYesWriteback cubeYesYesYesWriteback dimensionsYesYesWriteback hierarchy types (Parent-Child, Ragged Hiearchies)YesYesYesAdvanced dimensions (Reference dimensions, many-to-many dimensionsYesYesYesLinked measures and PartitionsYesYesYes, up to 3Proactive CachingYesYesCustom Assemblies (stored procs)YesYesYesMDX queries and scriptsYesYesYesDAX queriesYesYesRole-based security modelYesYesYesDimension and Cell-level SecurityYesYesYesScalable string storageYesYesYesMOLAP, ROLAP, HOLAP storage modesYesYesYesBinary and compressed XML transportYesYesYesPush-mode processingYesYesDirect WritebackYesYesMeasure ExpressionsYesYes

  1The LastChild semi-additive measure is supported in standard edition, but other semi-additive measures, such as None, FirstChild, FirstNonEmpty, LastNonEmpty, AverageOfChildren, and ByAccount, are not. Additive measures, such as Sum, Count, Min, Max, and non-additive measures (DistinctCount) are supported on all editions.

  BI Semantic Model (Tabular)Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with calculations, DAX queries, MDX queriesYesYesRow-level SecurityYesYesPartitionsYesYesIn-Memory and DirectQuery storage modes (Tabular only)YesYesPowerPivot for SharePointFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressSharePoint farm integration based on shared service architectureYesYesUsage reportingYesYesHealth monitoring rulesYesYesPowerPivot GalleryYesYesPowerPivot Data RefreshYesYesPowerPivot Data FeedsYesYesData MiningFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressStandard AlgorithmsYesYesYesData Mining Tools (Wizards, Editors Query Builders)YesYesYesCross ValidationYesYesModels on Filtered Subsets of Mining Structure DataYesYesTime Series: Custom Blending Between ARTXP and ARIMA MethodsYesYesTime Series: Prediction with New DataYesYesUnlimited Concurrent DM QueriesYesYesAdvanced Configuration & Tuning Options for Data Mining AlgorithmsYesYesSupport for plug-in algorithmsYesYesParallel Model ProcessingYesYesTime Series: Cross-Series PredictionYesYesUnlimited attributes for Association RulesYesYesSequence PredictionYesYesMultiple Prediction Targets for Naïve Bayes, Neural Network and Logistic RegressionYesYesReporting ServicesReporting Services FeaturesFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressSupported catalog DB SQL Server editionStandard or higherStandard or higherStandard or higherWebExpressSupported data source SQL Server editionAll SQL Server editionsAll SQL Server editionsAll SQL Server editionsWebExpressReport serverYesYesYesYesYesReport DesignerYesYesYesYesYesReport ManagerYesYesYesYesYesRole based securityYesYesYesYesYesWord Export and Rich Text SupportYesYesYesYesYesEnhanced gauges and chartingYesYesYesYesYesExport to Excel, PDF, and ImagesYesYesYesYesYesCustom authenticationYesYesYesYesYesReport as data feedsYesYesYesYesYesModel supportYesYesYesYesCreate custom roles for role-based securityYesYesYesModel Item securityYesYesYesInfinite click throughYesYesYesShared component libraryYesYesYesEmail and file share subscriptions and schedulingYesYesYesReport history, execution snapshots and cachingYesYesYesSharePoint IntegrationYesYesYesRemote and non-SQL data source support1YesYesYesData source, delivery and rendering, RDCE extensibilityYesYesYesData driven report subscriptionYesYesScale out deployment (Web farms)YesYesAlerting2YesYesPower View2YesYes

  1For more information on the supported datasources in SQL Server 2014 Reporting Services (SSRS), seeData Sources Supported by Reporting Services (SSRS).

  2Requires Reporting Services in SharePoint mode. For more information, seeReporting Services SharePoint Mode Installation (SharePoint 2010 and SharePoint 2013).

  Report Server Database Server Edition Requirements

  When creating a report server database, not all editions of SQL Server can be used to host the database. The following table shows you which editions of the Database Engine you can use for specific editions of Reporting Services.

  For this edition of SQL Server Reporting ServicesUse this edition of the Database Engine instance to host the databaseEnterpriseStandard, Business Intelligence Enterprise, editions (local or remote)Business IntelligenceStandard, Business Intelligence Enterprise, editions (local or remote)StandardStandard, Enterprise editions (local or remote)WebWeb edition (local only)Express with Advanced ServicesExpress with Advanced Services (local only).EvaluationEvaluationBusiness Intelligence Clients

  The following software client applications are available on the Microsoft Downloads center and are provided to assist you with creating business intelligence documents that run on a SQL Server instance. When you host these documents in a server environment, use an edition of SQL Server that is supported for that document type. The following table identifies which SQL Server edition contains the server features required to host the documents created in these client applications.

  Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressReport BuilderYesYesYesData Mining Addins for Excel and Visio 2010YesYesYesPowerPivot for Excel 2010YesYesMaster Data Services Add-in for ExcelYesYes

  Note

  1. PowerPivot for Excel is an Excel addin and does not depend on SQL Server. However PowerPivot for SharePoint is required for sharing and collaborating with PowerPivot workbooks in SharePoint and this capability is available as part of SQL Server Enterprise and Business Intelligence editions.
     1. The above table identifies the SQL Server editions that are required to enable these client tools; however these features can access data hosted on any edition of SQL Server.
  Spatial and Location ServicesFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressSpatial indexesYesYesYesYesYesYesYesPlanar and Geodetic datatypesYesYesYesYesYesYesYesAdvanced spatial of industry-standard spatial data formatsYesYesYesYesYesYesYesAdditional Database ServicesFeature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressSQL Server Migration AssistantYesYesYesYesYesYesYesDatabase mailYesYesYesYesOther Components
  Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpressData Quality Premium EditionStreamInsight Standard EditionStreamInsight Standard EditionStreamInsight Standard EditionStreamInsight HAStreamInsight Premium Edition

  
  

  *** IMPORTANT **** NOTE TO , THESE PRODUCT KEYS ARE FROM SCRAP PC\'S.
  

  IT IS LEGAL BY EU LAW TO SELL USED LICENSESYOU WILL GET A DEFECTIVE MOTHERBOARD THAT COMES WITH THE KEY AS REQUIRED TO COMPLY WITH \'S POLICY OF OEM SOFTWARE.
  

  FOR SHIPPING DETAILS , PLEASE CONTACT US BEFORE.

  
  Policy States:
  \"OEM, bundled, or recovery software may be listed only if it is included along with the original hardware, such as the motherboard, hard drive, or computer sold with the OEM software.\" - Therefore, this sale includes the original broken beyond economical repair computer and motherboard.