SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Server 2016 Rss

   Items 1 to 20 of 152    Older >>
 

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4

Continuing his series covering a step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster, Edwin Sarmiento looks at adding a node to an existing SQL Server 2016 failover clustered instance (FCI).  Read more...
By Additional Articles 2017/05/22 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,015 reads

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2017/05/08 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 371 reads

Selecting and Configuring Hardware for SQL Server 2016 Standard Edition

Glenn Berry explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.  Read more...
By 2017/04/25 | Source: SQLPerformance.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,143 reads

Package Parts – First Impressions

This article gives an overview of some good and not-so-good features of SSIS package parts.  Read more...
By Shubhankar Thatte 2017/04/19 | Source: SQLServerCentral.com | Category: package parts
Rating: |  Discuss |   Briefcase | 1,258 reads

SQL Server 2016 Online ALTER COLUMN Operation

Learn about the time savings, blocking scenarios, limitations and more for the SQL Server 2016 online ALTER COLUMN operation.  Read more...
By Additional Articles 2017/04/07 | Source: MSSQLTips.com | Category: alter column
Rating: (not yet rated)  Rate this |   Briefcase | 2,951 reads

It Just Runs Faster - Spatial

By Steve Jones 2017/03/31 | Category: spatial data
Rating: (not yet rated) |  Discuss |   Briefcase | 877 reads

It Just Runs Faster - AlwaysOn Compression

By Steve Jones 2017/03/17 | Category: alwayson
Rating: (not yet rated) |  Discuss |   Briefcase | 869 reads

CPU Limits

By Steve Jones 2017/03/07 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 1,054 reads

New CREATE OR ALTER statement in SQL Server 2016 SP1

Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.  Read more...
By Additional Articles 2017/02/20 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 4,911 reads

SQL Server 2016 Just Runs Faster - DBCC

By Steve Jones 2017/02/10 | Category: dbcc
Rating: (not yet rated) |  Discuss |   Briefcase | 1,041 reads

Simple Row Level Security for SQL Server 2016

Have you ever had a need to place some simple row level security on a SQL Server table? Well now you can do that in SQL Server 2016 by using row level security.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 6,032 reads

The New SQL Server 2016 Edition Limits

There are some changes to memory limits in SQL Server 2016 SP1 Standard Edition.  Read more...
By Steve Jones 2017/01/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 115 reads

SQL Server 2016 Build List

A list of all builds for SQL Server 2016. Updated with CU3 for SP1 and CU6 for RTM.  Read more...
By Site Owners 2017/01/25 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 932 reads

Columnstore Indexes and Computed Columns in SQL Server 2016

You can’t do everything with a columnstore index — but SQL Server’s optimizer can get pretty creative so it can use a columnstore index in ways you might not expect. Kendra Little explains.  Read more...
By Additional Articles 2017/01/25 | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,522 reads

Getting Started with R Services in SQL Server 2016 – Part 2

SQL Server 2016 brings native support for doing advanced analytics, using R Services, in the database itself. Arshad Ali takes a look at a detailed conceptual execution flow, executing R scripts from SQL Server Management Studio and other R client tools.  Read more...
By Additional Articles 2017/01/23 | Source: Database Journal | Category: r services
Rating: (not yet rated)  Rate this |   Briefcase | 3,205 reads

What's New in Reporting Services 2016 Service Pack 1

SQL Server 2016 was been released the first of June 2016, but at the recent Connect event Microsoft announced the first service pack. Aside from numerous fixes, this service pack also comes packed with some notable enhancements for Reporting Services. Koen Verbeeck gives you an overview of these enhancements.  Read more...
By Additional Articles 2017/01/19 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,380 reads

SQL Server 2016 Enterprise Edition Performance Advantages

Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.  Read more...
By Additional Articles 2017/01/10 | Source: SQL Server Performance | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 4,484 reads
   Items 1 to 20 of 152    Older >>
 
Tags
json (10)    
dynamic data masking (8)    
editorial (7)    
polybase (6)    
stretch database (6)    
tempdb (6)    
temporal tables (6)    
ado.net (5)    
always encrypted (5)    
installation (5)    
query store (qs) (5)    
encryption (4)    
ezado (4)    
reporting services (ssrs) (4)    
rest services (4)    
row-level security (rls) (4)    
sql server 2012 (4)    
sql server 2014 (4)    
t-sql (4)    
columnstore index (3)    
r services (3)    
security (3)    
administration (2)    
aps (2)    
availability groups (ag) (2)    
azure sql database (2)    
backup strategy (2)    
dbcc checkdb (2)    
development (2)    
disaster recovery (dr) (2)    
in-memory oltp (2)    
query plans (2)    
reporting (2)    
revolutionr (2)    
sql server 2008 r2 (2)    
sql server parallel data warehouse (2)    
alter column (1)    
alwayson (1)    
analysis services (ssas) (1)    
analytics (1)    
azure (1)    
backup (1)    
backup to azure (1)    
build list (1)    
checkpoint (1)    
ci (1)    
cloud integration (1)    
collation (1)    
columnstore (1)    
columnstore row group merge (1)    
compress (1)    
compress() (1)    
configuration (1)    
continuous delivery (1)    
continuous integration (ci) (1)    
data analysis (1)    
data driven (1)    
data security (1)    
data warehousing (1)    
database design (1)    
database weekly (1)    
database-scoped credential (1)    
date conversion (1)    
dax (1)    
dbcc (1)    
deploy (1)    
deterministic (1)    
dmvs (1)    
execution plans (1)    
failover clustered instance (fci) (1)    
for json (1)    
hardware (1)    
hashbytes() (1)    
high availability (ha) (1)    
indatabase analytics (1)    
indexing (1)    
install (1)    
instant file initialization (ifi) (1)    
integration services (ssis) (1)    
integrity check (1)    
live query statistics (1)    
managed backup (1)    
microsoft (1)    
microsoft azure sql database (1)    
miscellaneous (1)    
number of rows read (1)    
operational analytics (1)    
other (1)    
package parts (1)    
performance (1)    
product reviews (1)    
query store (1)    
random numbers (1)    
redgate (1)    
row level security (rls) (1)    
service packs (1)    
shallow backup (1)    
spatial data (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server integration services (ssis) (1)    
sql server reporting services (1)    
sql toolbelt (1)    
sqlclr (1)    
statistics (data) (1)    
stretch (1)    
stretch database adviser (1)    
string_split (1)    
system-versioned tables (1)    
tabular model (1)    
tempdb performance tuning (1)    
temporal data (1)    
trace flag 1117 (1)    
trace flag 1118 (1)    
transparent data encryption (tde) (1)    
user groups (1)