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

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 | 9,642 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,451 reads

Columnstore Indexes

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

ColumnStore index

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

TDE and In-Memory OLTP

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

The Identity Limit

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

Plan Guides

By Steve Jones 2014/10/20 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,453 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,249 reads

Columnstore changes

By Steve Jones 2014/10/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,422 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,790 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,325 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,504 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,617 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 indexes
Rating: |  Discuss |   Briefcase | 4,403 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,062 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,196 reads

Effective Max

By Steve Jones 2014/06/23 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,572 reads
   Items 1 to 20 of 72    Older >>
 
Tags
administration (13)    
memory-optimized tables (6)    
hekaton (5)    
in-memory oltp (5)    
indexing (4)    
cardinality estimates (3)    
columnstore index (3)    
columnstore indexes (3)    
performance (3)    
resource governor (3)    
azure (2)    
backup (2)    
blogs (2)    
buffer pool extensions (bpe) (2)    
editorial (2)    
installation (2)    
memory optimized (2)    
oltp (2)    
sql server 2012 (2)    
architecture (1)    
availability (1)    
availability groups (1)    
backup / restore (1)    
buffer pool extension (1)    
build list (1)    
cardinality estimator (1)    
cloud services (1)    
clustered columnstore index (1)    
connect any database (1)    
data warehouse (1)    
dmv (1)    
dynamic management view (1)    
identity property (1)    
integrity check (1)    
memory optimization advisor (1)    
memory optimized tables (1)    
memory-optimized table (1)    
monitoring (1)    
native compiled (1)    
olap (1)    
partitioning (1)    
permissions (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)    
tsql (1)    
t-sql (1)