News

Microsoft10y
Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions - Microsoft SQL Server Blog
A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of ...
GitHub3y
wetory/sql-server-maintenance: Standardized database maintenance for SQL Server, built over popular Ola Halengreen's procedures. - GitHub
The model database is used as the template for all databases created on an instance of SQL Server. Because tempdb is created every time SQL Server is started, the model database must always exist on a ...
GitHub8y
sql-docs/docs/relational-databases/in-memory-oltp/create-and-access-tables-in-tempdb-from-stored-procedures.md at live · MicrosoftDocs/sql-docs - GitHub
Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...
Microsoft11y
SQL Server 2014 In Memory OLTP: Memory-Optimized Table Types and Table Variables - Microsoft SQL Server Blog
SQL Server 2014 In-Memory OLTP introduces two new widely advertised kinds of database objects: memory-optimized tables for efficient data access, and natively compiled stored procedures for efficient ...
Visual Studio Magazine12y
More Details on SQL Server 2014 In-Memory Capabilities
More details are emerging about in-memory capabilities in the new SQL Server 2014, announced at the recent TechEd 2013 conference. The first Community Technology Preview is expected to be released ...
InfoWorld12y
Microsoft adding in-memory capabilities to SQL Server
In a move to speed online transaction processing (OLTP), Microsoft is adding in-memory capabilities into its SQL Server relational database management system.