Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,878,409 DBAs, developers and SQL Server users

Rss
Headlines today   January 23, 2017

Join Two CSV Files with a Common Column

In this example we will join two CSV files with a common column using SQL Server.  Read more...
By Daniel Calbimonte 2017/01/23 | Source: SQLServerCentral.com | Category: join
Rating: |  Discuss |   Briefcase | 1,067 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012. Updated with CU16 for SP2 and CU7 for SP3.  Read more...
By Steve Jones 2017/01/23 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 17,828 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 | 1,371 reads

Need to run multiple scripts against multiple servers?

Let Chris Yates give you a quick overview of Redgate's SQL Multi Script to learn more about a quick and easy way to solve the problem.  Read more...
By Additional Articles 2017/01/23 | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,095 reads
Previous headlines

Data Mining Introduction

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.  Read more...
By Daniel Calbimonte 2017/01/20 (first published: 2012/11/12) | Source: SQLServerCentral.com | Category: server
Rating: |  Discuss |   Briefcase | 51,488 reads

Development Delusions: That it is Enough to Build a Better Mousetrap

You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.  Read more...
By Additional Articles 2017/01/20 | Source: SimpleTalk | Category: development
Rating:  Rate this |   Briefcase | 1,736 reads

Keeping Fact Tables Online while Loading via Partition Switching

Provides overview of steps that can be used to keep fact tables online during loading process.  Read more...
By Shubhankar Thatte 2017/01/19 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 931 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 | 3,108 reads

Free Webinar: An Introduction to DevOps

Despite its growing popularity, there is still some confusion over what DevOps actually means, how organizations should do it and what the best way is to get started. Redgate have invited James Betteley, Head of Education at the DevOpsGuys, to run through the basics in this free webinar. Register now.  Read more...
By 2017/01/19 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,964 reads

Put your Database under Source Control

This article will walk you through a demostration on linking your DB to SubVersion with RedGate SQL Source Control.  Read more...
By Thomas Liddle 2017/01/18 | Source: SQLServerCentral.com | Category: db source control
Rating: |  Discuss |   Briefcase | 761 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Power BI Subscriptions

Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in...  Read more...
By Devin Knight 2017/01/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 837 reads
Question of the Day

right aligning

By Steve Jones 2017/01/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 581 reads

I have this table and want to right align the output with 2 decimals for each number. What should I replace the xxx with in my query?


DECLARE @t TABLE (mynum...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
2987 45329 SSC-Forever  
2.
Steve Jones - SSC Editor
1834 36310 SSC-Dedicated  
3.
GilaMonster
1659 47388 SSC-Forever  
4.
SQLRNNR
1030 21113 SSC-Insane  
5.
Koen Verbeeck
982 16518 SSCoach  
Latest forum posts