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 35    Older >>
 

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 | 53 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 | 320 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,193 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/05/13 | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 8,960 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,333 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 | 10,774 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 | 5,874 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: (not yet rated) |  Discuss |   Briefcase | 2,964 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,809 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,438 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,560 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,735 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,534 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,120 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,251 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,295 reads

SQL Server 2014 Has Been Released

Today is the first day of general availability for SQL Server 2014.  Read more...
By Press Release 2014/04/01 | Source: SQLServerCentral.com | Category: sql server 2014
Rating:  Rate this |   Briefcase | 11,373 reads

Limited Time Offer: Licensing by Scale for SQL Server

With the release of SQL Server 2014, the licensing options have changed slightly. Read on to discover how you might choose to change your licensing in the future.  Read more...
By Steve Jones 2014/04/01 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 5,144 reads

SQL Server 2014 New Defaults

SQL Server 2014 is being released and a change in the defaults will ensure that more instances will run smoother.  Read more...
By Grant Fritchey 2014/04/01 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 2,156 reads

Native C# in Stored Procedures

A new enhancement in SQL Server 2014 allows you to directly enter C# code in your stored procedures.  Read more...
By Steve Jones 2014/04/01 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 4,068 reads
   Items 1 to 20 of 35    Older >>