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,858,083 DBAs, developers and SQL Server users

Rss
Headlines today   May 4, 2016

Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining

In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.  Read more...
By Daniel Calbimonte 2016/05/04 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 521 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2016/05/04 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 20,831 reads

STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

Aaron Bertrand follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.  Read more...
By Additional Articles 2016/05/04 | Source: SQLPerformance.com | Category: string_split
Rating: (not yet rated)  Rate this |   Briefcase | 1,815 reads
Previous headlines

GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201

Ability to enable Instant File Initialization during the installation of SQL Server 2016.  Read more...
Rating: |  Discuss |   Briefcase | 868 reads

Execute Dynamic SQL commands in SQL Server

In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL Server stored procedure?  Read more...
By Additional Articles 2016/05/03 | Source: MSSQLTips.com | Category: dynamic sql
Rating:  Rate this |   Briefcase | 3,267 reads

Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout

Your SQL Agent Jobs may be silently failing when using Linked Servers.  Read more...
By Chad Feghali 2016/05/02 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,012 reads

Announcing Bilm Academy

Join Andy Leonard the week of May 9-13 for 5 free days of Biml training.   Read more...
By Press Release 2016/05/02 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 3,604 reads

Getting started with Azure SQL Data Warehouse

Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.  Read more...
By Additional Articles 2016/05/02 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,434 reads

Create stunning visualizations with Power View in 20 minutes or less!

Learn about Microsoft’s latest end-user BI reporting tool, Power View, and create animated graphs that impress your boss!  Read more...
By Amir Charania 2016/04/29 (first published: 2014/12/30) | Source: SQLServerCentral.com | Category: power view
Rating: |  Discuss |   Briefcase | 11,677 reads

Write for SQLServerCentral - Bonus for Azure

We're always looking for articles, but here are a few ones that I'd like to see written up.  Read more...
By Site Owners 2016/04/29 (first published: 2014/09/04) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,882 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Changing the sa Password with SQLCMD

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...  Read more...
By Steve Jones 2016/05/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 879 reads
Question of the Day

Why STUFF

By Steve Jones 2016/05/04 | Category: stuff
Rating: (not yet rated) |  Discuss |   Briefcase | 918 reads

Why is the STUFF command included in this code?


WITH CTE AS
(
SELECT DISTINCT
AccountNumber
FROM #TestData
)
SELECT AccountNumber,
CommaList = stuff((
SELECT ',' + Value
FROM #TestData
WHERE AccountNumber = CTE.AccountNumber
ORDER BY Value
FOR XML...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Wryan138
876 3394 Hall of Fame  
2.
BLOB_EATER
480 1111 Ten Centuries  
3.
BillLudlow
430 3261 Hall of Fame  
4.
Iwas Bornready
408 7084 SSCertifiable  
5.
Amour
394 394 Old Hand  
Latest forum posts