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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,892,583 DBAs, developers and SQL Server users

Rss
Headlines today   October 18, 2017

Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.  Read more...
By David Durant 2017/10/18 (first published: 2014/11/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 27,448 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2017/10/18 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 87,738 reads

SQL Server AlwaysOn Availability Groups Using an Azure Template

There is already a template on the Azure marketplace for setting up an AlwaysOn Availability Group. In just a few easy steps you can get a working AlwaysOn Availability Group setup, configured and running - this post describes the steps to quickly set it up.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 254 reads
Previous headlines

Introduction to Statistics

This article will give a brief overview of how statistics are generated, stored, and used in SQL Server.  Read more...
By Johnny Bieber 2017/10/17 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,037 reads

A Freecon Halloween at the PASS Summit

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend.  Read more...
By Press Release 2017/10/17 (first published: 2017/10/13) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 257 reads

Key Lookups and ColumnStore Indexes

Erik figures out why SQL Server really doesn't like combining these two things in a query plan.  Read more...
By Additional Articles 2017/10/17 | Source: Brent Ozar Unlimited Blog | Category: key lookup
Rating: (not yet rated)  Rate this |   Briefcase | 1,629 reads

Loading Data using R and PowerBI

I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.  Read more...
By Nick Burns 2017/10/16 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 563 reads

Webinar: how to cut time & disk space for database provisioning by 99%

If you’ve ever worked in a team that uses a single, shared database for development, you know how time-consuming and frustrating it is to provision copies of production databases for development work. In this webinar on October 17, you’ll see how SQL Clone cuts out the pain of provisioning development databases.  Read more...
By 2017/10/16 (first published: 2017/10/11) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,383 reads

The Power of Python and SQL Server 2017

Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL Server, but it can be used for far more than this, with any Python libraries or Frameworks. To provide an example of what is possible, Hitendra shows how to use the feature securely to provide intelligent application caching, where SQL Server can automatically indicate when data changes to trigger a cache refresh.  Read more...
By Additional Articles 2017/10/16 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,807 reads

A Lightweight, Self-adjusting, Baseline-less Data Monitor

Can data alert us that something is going on, without baselines and thresholds?  Read more...
By Alex Chamchourine 2017/10/13 (first published: 2016/02/23) | Source: SQLServerCentral.com | Category: data monitoring
Rating: |  Discuss |   Briefcase | 3,445 reads
 

From the SQLServerCentral Blogs

SQL Server 2017 Encrypted Backups And Compression

Let’s work through some code to do an encrypted backup. This feature is available to you if you are using...  Read more...
By Arun Sirpal 2017/10/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 327 reads

SpeedPASS Download Naming Convention

This was the first time in a long time that I managed the check-in process of SQLSaturday Orlando and was...  Read more...
By Andy Warren 2017/10/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 219 reads
Question of the Day

Loading CSVs

By Steve Jones 2017/10/18 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

I have the movies.csv file from the MovieLens project. I want to load this in R Studio for some analysis. What should I do in order to build a variable...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
51789 412376 SSC Guru  
2.
Jeff Moden
47118 378033 SSC Guru  
3.
Steve Jones - SSC Editor
29233 247997 SSC Guru  
4.
Lynn Pettis
20191 166882 SSC Guru  
5.
Grant Fritchey
19422 161761 SSC Guru  
Latest forum posts