Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag SQL Server 2014 Rss

Search for any content tagged sql server 2014

   Items 1 to 20 of 39    Older >>
 

Learning In-Memory OLTP

References and links to help you learn more about In-Memory OLTP tables  Read more...
By Site Owners 2015/08/17 | Source: SQLServerCentral.com | Category: in-memory oltp
Rating: (not yet rated) |  Discuss |   Briefcase | 2,390 reads

Learning Columnstore Indexes

References and links to learn more about columnstore indexes.  Read more...
By Site Owners 2015/08/03 | Source: SQLServerCentral.com | Category: columnstore index
Rating: (not yet rated) |  Discuss |   Briefcase | 2,301 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2015/07/22 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 11,359 reads

MS15-058: Vulnerabilities in SQL Server could allow remote code execution

A vulnerability has been released that can affect SQL Server 2008, 208 R2, 2012, and 2014.  Read more...
By Press Release 2015/07/15 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 5,314 reads

Learning about the Cardinality Estimator

A few links to help you understand the Cardinality Estimator.  Read more...
By Site Owners 2015/06/29 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Learning SQL Server 2014

A list of technologies in SQL Server 2014 that you might want to learn more about.  Read more...
By Site Owners 2015/06/25 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 723 reads

Column Store vs Row Store Indexes

How does a column store index compare to a (traditional)row store index with regards to performance  Read more...
By Brian Ellul 2015/05/14 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 7,434 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2015/07/22 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 11,359 reads

Tips to Optimize Your SQL Statements - Part 2

Read more tips to optimize SQL statements, specifically on a Data warehouse.  Read more...
By Brian Ellul 2015/05/07 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 11,974 reads

Microsoft® SQL Server® 2014 Service Pack 1 (SP1) released

Service Pack 1 for SQL Server 2014 has been released.  Read more...
By 2015/04/16 | Source: Microsoft SQL Home | Category: sql server 2014
Rating:  Rate this |   Briefcase | 11,501 reads

Cardinality Estimator – What’s new in SQL Server 2014

SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are the biggest differences between the new CE and the previous one? Which one works better? Read more to find out.  Read more...
Rating: |  Discuss |   Briefcase | 6,032 reads

SQL Server 2014 Build List

A list of builds for SQL Server 2014, through CU5 for RTM.  Read more...
By Steve Jones 2015/02/23 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 3,292 reads

Clustered Columnstore Index Gives "Unable to find index entry" Error

The Clustered columnstore index generates "unable to find index entry" error and a memory dump after few DMLs on the table  Read more...
Rating: |  Discuss |   Briefcase | 1,819 reads

Implementing Azure Blob Storage (ABS) With SQL Server 2014

With any application organizations face consistent key challenges such as high efficiency and business value, complex configuration, and low total cost of ownership. Extending applications to the cloud in hybrid scenarios addresses many of these challenges, whether distributing SharePoint content across on-premises and Office 365 while leveraging search as a service (hybrid search) or externalizing data, extending it to the cloud with Remote Blob Storage or related technologies.   Read more...
By Additional Articles 2014/09/02 | Source: Microsoft MSDN | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 6,512 reads

Natively Compiled Stored Procedures: What they are all about!

What are natively compiled stored procedures? Why would we want to use them and what are the performance benefits of using them over classic disk-based stored procedures?  Read more...
By Edward Pollack 2014/08/04 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 8,581 reads

New SQL Server 2014 Permissions: CONNECT ANY DATABASE

CONNECT ANY DATABASE is one of three new permissions in SQL Server 2014 that can be granted to server logins. What is this new permission good for and why would we ever want this?  Read more...
By Edward Pollack 2014/07/29 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,824 reads

Columnstore Index Changes in SQL Server 2014

SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL Server 2014?  Read more...
By Edward Pollack 2014/07/24 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 4,600 reads

Dynamic Management Views: Changes in SQL Server 2014

SQL Server 2014 has a number of new DMVs, and some changes from SQL Server 2012. What are the new views and changes, and how can be useful to you?  Read more...
By Edward Pollack 2014/07/08 | Source: SQLServerCentral.com | Category: dynamic management view
Rating: |  Discuss |   Briefcase | 4,144 reads

Creating Memory-Optimized Table in SQL Server 2014

A quick introduction of how to create memory-optimized tables in SQL Server 2014  Read more...
By Louis Li 2014/07/07 | Source: SQLServerCentral.com | Category: memory-optimized table
Rating: |  Discuss |   Briefcase | 2,328 reads

Quick Guide to Installing SQL Server 2014

In this tip, we will demonstrate the installation of SQL Server 2014 on a notebook. While processing large amounts of data on a system like this might not be feasible, one can still learn how to configure and use the features of SQL Server 2014.  Read more...
By Additional Articles 2014/06/09 | Source: MSSQLTips.com | Category: installation
Rating: (not yet rated)  Rate this |   Briefcase | 3,340 reads
   Items 1 to 20 of 39    Older >>