Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,823,884 DBAs, developers and SQL Server users

Rss
Headlines today   August 31, 2015

JSON Select - Easily query values from JSON

Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+  Read more...
By Joshua Healy 2015/08/31 | Source: SQLServerCentral.com | Category: json
Rating: |  Discuss |   Briefcase | 6,027 reads

Free Webinar: Should your databases be Continuously Delivered?

If you want to learn more about Continuous Delivery, and where your databases fit into the picture, join Dave Farley on September 2nd for a webinar covering why databases are an essential component of CD, and how to start modernizing your software development practices.  Read more...
By Additional Articles 2015/08/31 (first published: 2015/08/13) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 6,910 reads

Learning Managed Backup

References and Links to using the Managed Backup feature in SQL Server 2016  Read more...
By Site Owners 2015/08/31 | Source: SQLServerCentral.com | Category: managed backup
Rating: (not yet rated) |  Discuss |   Briefcase | 432 reads

Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service

Designing databases to use distributed tables effectively will help you to achieve the storage and query processing benefits of the Azure SQL DW Service (SQL DW). In this article, Murshed Zaman explains the various Azure SQL Data Warehouse distributed table types, and offers guidance for choosing the type of distributed table to use and when to use it.  Read more...
By Additional Articles 2015/08/31 | Source: SQLCAT | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 608 reads
Previous headlines

Email Formatted HTML Table with T-SQL

Create a professional looking HTML table from T-SQL, not SSRS.  Read more...
By Steve Moore 2015/08/28 (first published: 2013/06/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 19,869 reads

SQL Server 2016 – Introduction to Stretch Database

Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. Tim Radney introduces Stretch Database by looking at the applications and limitations of the new feature.  Read more...
By Additional Articles 2015/08/28 | Source: SQLPerformance.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,056 reads

Soundex - Experiments with SQLCLR Part 3

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework  Read more...
By David Poole 2015/08/27 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 2,216 reads

An Introduction to Real-Time Communication with SignalR

SignalR, from Microsoft, solves many of the problems that come with developing web applications that need a communication channel with the server that is effective on a variety of server and client configurations. Christos Matskas gives an overview of the library and its potential.  Read more...
By Additional Articles 2015/08/27 | Source: SimpleTalk | Category: signalr
Rating: (not yet rated)  Rate this |   Briefcase | 2,741 reads

Database Documentation Survey

Documentation often gets left behind in software development, perhaps even more so when it comes to developing the database schema. How do you keep yours up-to-date? Do you even think you should?  Read more...
By Additional Articles 2015/08/27 (first published: 2015/08/20) | Source: Redgate | Category: survey
Rating:  Rate this |   Briefcase | 3,458 reads

Strange Filtered Index Problem

What I thought was a strange filtered index problem but turned out to be a DB settings problem  Read more...
By Mike Good 2015/08/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,087 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Tables, Columns and Defaults Oh My!

Picture this if you could. You inherit a new database either through the change of a job, or finding a...  Read more...
By Jason Brimhall 2015/08/31 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 899 reads
Question of the Day

Counting Rows

By Shiva N 2015/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 736 reads

What is the output from this batch?


DECLARE

  @a INT

, @b INT;

DECLARE @tbl TABLE ( id INT NOT NULL );

SELECT

    @b = COUNT(1)

  FROM

    @tbl;

SET @a = @b;

SELECT

    @a;
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Piotr Ryszkowski
841 3303 Hall of Fame  
2.
schaudhary
500 508 Mr or Mrs. 500  
3.
gwarhade
450 505 Mr or Mrs. 500  
4.
postald11
373 373 Old Hand  
5.
dschlobohm
358 382 Old Hand  
Latest forum posts