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

Content with tag SQL Server 2014 Rss

   Items 1 to 20 of 79    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 | 16 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 | 158 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,132 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,903 reads

Resource Governor 2014

By Steve Jones 2015/05/07 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,274 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,227 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,715 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,832 reads

Columnstore Indexes

By Dawn Strickrott 2015/03/16 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,577 reads

ColumnStore index

By pramod singla 2015/02/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,543 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,944 reads

TDE and In-Memory OLTP

By pramod singla 2015/02/19 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,624 reads

The Identity Limit

By Steve Jones 2015/01/20 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 2,111 reads

Plan Guides

By Steve Jones 2014/10/20 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,465 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,335 reads

Columnstore changes

By Steve Jones 2014/10/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,441 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,806 reads
   Items 1 to 20 of 79    Older >>
 
Tags
administration (13)    
columnstore index (9)    
in-memory oltp (7)    
hekaton (6)    
memory-optimized tables (6)    
indexing (4)    
resource governor (4)    
cardinality estimates (3)    
performance (3)    
sql server 2012 (3)    
azure (2)    
backup (2)    
blogs (2)    
buffer pool extensions (bpe) (2)    
cardinality estimator (2)    
data warehouse (2)    
editorial (2)    
installation (2)    
memory optimized (2)    
oltp (2)    
partitioning (2)    
sql server 2016 (2)    
t-sql (2)    
architecture (1)    
availability (1)    
availability groups (1)    
backup / restore (1)    
buffer pool extension (1)    
build list (1)    
cloud services (1)    
clustered column store indexes (1)    
clustered columnstore index (1)    
compression (1)    
connect any database (1)    
covering indexes (1)    
data warehousing (1)    
database settings (1)    
dmv (1)    
dynamic management view (1)    
ebook (1)    
identity property (1)    
instance settings (1)    
integrity check (1)    
max degree of parallelism (1)    
memory optimization advisor (1)    
memory optimized tables (1)    
memory-optimized table (1)    
monitoring (1)    
native compiled (1)    
olap (1)    
optimize for ad hoc workloads (1)    
permissions (1)    
recovery model (1)    
row store indexes (1)    
security (1)    
server configuration (1)    
service packs (1)    
set options (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server 2008 r2 (1)    
statistics (1)    
stored procedures (1)    
transparent data encryption (tde) (1)    
windows azure (1)