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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,911,343 DBAs, developers and SQL Server users

Headlines today   January 16, 2019

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more...
By David Durant 2019/01/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,218 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2019/01/16 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 81,186 reads

Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers

In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.  Read more...
By Additional Articles 2019/01/16 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,055 reads
Previous headlines

Implementing Stretch Database.

Learn how you can enable the Stretch Database feature in SQL Server 2016.  Read more...
By Deepak Prasad Sahu 2019/01/15 | Source: SQLServerCentral.com | Category: stretch database
Rating: |  Discuss |   Briefcase | 636 reads

New Preview of SQL Server Management Studio Available for Download

On September 24th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Now is the time to download this new preview!  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,913 reads

SQL Server Logical Reads – What do they really tell us?

SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,845 reads

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/14 | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 210 reads

The 2019 State of Database DevOps

All the latest insights on DevOps adoption rates among SQL Server Professionals, with a foreword from Donovan Brown Principal DevOps Manager at Microsoft. Read the report to understand the challenges – and the opportunities – of adopting database DevOps alongside broader DevOps initiatives  Read more...
By 2019/01/14 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 542 reads

Introduction to AWS Elastic Beanstalk

The AWS Elastic Beanstalk feature is a web application provisioning service that allows you to automatically scale as needed. In this article, Gerald Bauer explains how to set up and configure Elastic Beanstalks through the AWS dashboard and Visual Studio.  Read more...
By Additional Articles 2019/01/14 | Source: SimpleTalk | Category: aws
Rating: (not yet rated)  Rate this |   Briefcase | 476 reads

Two Things I Would Change in SSISDB Setup

I suggest these two changes to the SSISDB setup to prevent issues down the road.  Read more...
By Ben Kubicek 2019/01/11 (first published: 2016/03/29) | Source: SQLServerCentral.com | Category: ssisdb
Rating: |  Discuss |   Briefcase | 3,461 reads

From the SQLServerCentral Blogs

Short Circuiting Your Session

It isn’t very often that one would consider a short circuit to be a desired outcome. In SQL Server we...  Read more...
By Jason Brimhall 2019/01/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,464 reads

Data Warehousing Tip #3 – Build thin slice

My third data warehousing tip is to build thin slice.  Deliver iterative releases. Get valuable feedback and buy in, and...  Read more...
By ChrisJenkins 2019/01/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,852 reads
Question of the Day

Finding the Perfect Set

By Steve Jones 2019/01/16 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 290 reads

I have a data set of statistics from the completed 2018 NFL season. The data set looks like:

> head(nfl2018.qb)
Rk Player Tm Age Pos G GS QBrec Cmpâ.. Att CompPrcnt...  Read more...
Latest forum posts