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

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 | 7,781 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,045 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 | 3,882 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 | 3,792 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 | 1,855 reads

Effective Max

By Steve Jones 2014/06/23 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,458 reads

Resource Governor pools

By Steve Jones 2014/06/10 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,249 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,006 reads

Files for memory-optimized tables

By Steve Jones 2014/06/04 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,271 reads

Cardinality Regression

By Steve Jones 2014/06/02 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,242 reads

Resource Governor

By Steve Jones 2014/05/29 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,235 reads

Memory-Optimized Table Filegroups

By Steve Jones 2014/05/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,291 reads

Server Settings

By free mascot 2014/05/19 | Category: server configuration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,484 reads

Upgrading cardinality

By Steve Jones 2014/05/15 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,309 reads

Buffer Pool Extenstion Editions

By Tom Thomson 2014/05/08 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,330 reads

Removing Memory-optimized tables

By Steve Jones 2014/05/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,301 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/04/30 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 42,375 reads

Keeping my cardinality

By Steve Jones 2014/04/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,568 reads

Memory-Optimized Table checkpoint

By Steve Jones 2014/04/28 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,313 reads

Memory-Optimized Table Disk space

By Steve Jones 2014/04/23 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,425 reads
   Items 1 to 20 of 59    Older >>
 
Tags
administration (11)    
memory-optimized tables (6)    
hekaton (5)    
in-memory oltp (4)    
cardinality estimates (3)    
resource governor (3)    
backup (2)    
blogs (2)    
buffer pool extensions (bpe) (2)    
columnstore index (2)    
editorial (2)    
installation (2)    
memory optimized (2)    
oltp (2)    
performance (2)    
architecture (1)    
availability (1)    
availability groups (1)    
azure (1)    
backup / restore (1)    
buffer pool extension (1)    
build list (1)    
cloud services (1)    
columnstore indexes (1)    
connect any database (1)    
data warehouse (1)    
dmv (1)    
dynamic management view (1)    
index maintenance (1)    
indexes (1)    
indexing (1)    
integrity check (1)    
memory optimization advisor (1)    
memory optimized tables (1)    
memory-optimized table (1)    
monitoring (1)    
native compiled (1)    
olap (1)    
permissions (1)    
security (1)    
server configuration (1)    
set options (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
statistics (1)    
stored procedures (1)