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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,891,044 DBAs, developers and SQL Server users

Headlines today   September 19, 2017

Moving beyond principal components analysis

Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.  Read more...
By Nick Burns 2017/09/19 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 287 reads

Searching and finding a string value in all columns in a SQL Server table

Sometimes there is a need to find if a string value exists in any column in your table. Although there are system stored procedures that do a "for each database" or a "for each table", there is not a system stored procedure that does a "for each column".  Read more...
By Additional Articles 2017/09/19 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 1,990 reads

Benchmark your Database DevOps maturity level

Whether you’re only just starting to explore the advantages of DevOps or you’re already fully immersed in the journey, including the database brings additional advantages. Take a few minutes to complete our Database DevOps Maturity Assessment and you’ll better understand how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers.  Read more...
By 2017/09/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 761 reads
Previous headlines

The Instance ID MSSQLSERVER Is Already In Use

This article will explain how to fix "The Instance ID 'MSSQLSERVER' Is Already In Use By SQL Server Instance 'MSSQLSERVER.INACTIVE' Error.   Read more...
By Nisarg Upadhyay 2017/09/18 | Source: SQLServerCentral.com | Category: mssqlserver
Rating: (not yet rated) |  Discuss |   Briefcase | 569 reads

How to Drop All Your Indexes – Fast

You probably shouldn't be doing this, but if you need to, Brent Ozar has a script for that.  Read more...
By Additional Articles 2017/09/18 | Source: Brent Ozar Unlimited Blog | Category: drop indexes
Rating: (not yet rated)  Rate this |   Briefcase | 2,717 reads

Redgate wants your opinion

Have you tried or used SQL Prompt? Redgate is running some research on SQL Prompt pricing. Please help by filling in their short survey for the chance to win one of three licenses of SQL Prompt or a Redgate point-tool if your choice.  Read more...
By 2017/09/18 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,120 reads

A Pattern for Email Address storage and retrieval

Email addresses are very prevalent in IT systems and often used as a natural primary key. The repetitive storage of email addresses in multiple tables is a bad design choice. Following is a design pattern to store email addresses in a single table and to retrieve them efficiently.  Read more...
By Jeff Reinhard 2017/09/15 (first published: 2015/09/24) | Source: SQLServerCentral.com | Category: email address
Rating: |  Discuss |   Briefcase | 6,896 reads

SQL Server R Services: Digging into the R Language

It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots.  Read more...
By Additional Articles 2017/09/15 | Source: SimpleTalk | Category: sql server r services
Rating:  Rate this |   Briefcase | 3,088 reads

Automate MSBI deployments Using PowerShell

There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.  Read more...
By Kunal Rathi 2017/09/14 | Source: SQLServerCentral.com | Category: msbi
Rating: |  Discuss |   Briefcase | 416 reads

sp_AllNightLog: Creating Jobs Like I’m The President

Erik Darling explains why sp_AllNightLog creates so many jobs by default.  Read more...
Rating:  Rate this |   Briefcase | 2,968 reads

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 67 – Impact Bubble Chart)

In this module you will learn how to use the Impact Bubble Chart Custom Visual.  The Impact Bubble Chart is...  Read more...
By Devin Knight 2017/09/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,266 reads

Dynamic Threshold for Statistic Update - SQL Server 2016

By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the...  Read more...
By 2017/09/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 751 reads
Question of the Day

Real Maths

By Mike Tanner 2017/09/19 | Category: operator precedence
Rating: (not yet rated) |  Discuss |   Briefcase | 530 reads

In mathematics, multiplication and division are said to be commutative, meaning that it doesn't matter which order the operation is performed in. 

The way SQL Server performs numeric calculations follows... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
74459 365010 SSC Guru  
Jeff Moden
64730 334699 SSC Guru  
Steve Jones - SSC Editor
40443 221123 SSC Guru  
Lynn Pettis
28654 148444 SSC Guru  
25736 121437 SSC Guru  
Latest forum posts