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

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,716 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,131 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,300 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,405 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,187 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,941 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,061 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,130 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,298 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,135 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,125 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,032 reads

Microsoft SQL Server 2014 released to manufacturing

, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014, the foundation of Microsoft’s cloud-first data platform, is released to manufacturing and will be generally available on April 1.  Read more...
By Press Release 2014/03/19 | Source: TechNet Blogs | Category: sql server 2014
Rating:  Rate this |   Briefcase | 7,315 reads

SQL Server 2014 Backup Basics

There is nothing mysterious about SQL Server backups. They are essential, however you use your databases. Grant Fritchey explains the basics of database backups and restores with SQL Server 2014.  Read more...
By Additional Articles 2014/01/16 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 2,968 reads

SQL Server 2014 Memory Optimization Advisor

The new SQL Server 2014 “Memory Optimization Advisor” tool helps you quickly analyze tables to see how easy it is to migrate them to In-Memory OLTP tables. Read on to learn more.  Read more...
By Additional Articles 2014/01/15 | Source: Database Journal | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 1,900 reads

SQL Server 2014 In-Memory OLTP Architecture and Data Storage

Microsoft is releasing SQL Server 2014 with a new set of In-Memory OLTP features to significantly improve the OLTP performance and reduce the processing time for servers with a large amount of memory and multi-core processors. Check out this tip to learn more.  Read more...
By Additional Articles 2014/01/02 | Source: MSSQLTips.com | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 2,459 reads

Content in the Cloud

Steve Jones has some concerns over new options in SQL Server 2014 that might lead some customers to experiment in a way that causes them unexpected pain.  Read more...
By Steve Jones 2013/11/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Project Hekaton

Today Steve Jones talks about the Hekaton features that are coming in SQL Server 2014.   Read more...
By Steve Jones 2013/11/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 282 reads

SQL Server 2014 CTP 2 is available

Download the latest preview of the the next SQL Server version for testing.  Read more...
By Press Release 2013/10/18 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 4,627 reads

Introduction to SQL Server 2014 CTP1 Memory-Optimized Tables

There are a number of new features that became available with SQL Server 2014. One of the more exciting features is the new Memory-Optimized tables. In this article Greg Larson explores how to create Memory-Optimized tables, and what he's found during his initial exploration of using this new type of table.  Read more...
By Additional Articles 2013/10/14 | Source: Database Journal | Category: memory optimized
Rating: (not yet rated)  Rate this |   Briefcase | 3,364 reads
   Items 1 to 20 of 28    Older >>