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

Welcome to

A Microsoft SQL Server community of 1,791,920 DBAs, developers and SQL Server users

Headlines today   March 30, 2015

Obedience Training For Databases: Cascading Constraints

In which Phil Factor illustrates in TSQL how it is possible to use foreign key constraints to enforce data rules, and illustrates some surprising consequences of using cascading.  Read more...
By Phil Factor 2015/03/30 | Source: | Category: constraints
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads

Identifying and Solving Index Scan Problems

When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you've identified the queries, what next? Dennes Torres gives some preliminary guidelines on how to find out why these index scans are being chosen for these queries and how to make the queries run faster and more efficiently.  Read more...
By Additional Articles 2015/03/30 | Source: SimpleTalk | Category: query plan
Rating: (not yet rated)  Rate this |   Briefcase | 279 reads
Previous headlines

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.  Read more...
By Ben Kubicek 2015/03/27 (first published: 2014/05/08) | Source: | Category: cumulative
Rating: |  Discuss |   Briefcase | 13,426 reads

Azure Blob Storage Part 9: Shared Access Signatures

In this article, Robin Shahan talks about security and how to control access to containers and blobs using shared access signatures (SAS) and stored access policies.   Read more...
By Additional Articles 2015/03/27 | Source: Just Azure | Category: blob storage
Rating: (not yet rated)  Rate this |   Briefcase | 4,950 reads

SQL Saturday #372 - Exeter, UK

SQL Saturday, organized by SQL South West, is coming to Exeter, England on April 25. This is sure to be a special event, and as always, offers a free day of training and networking. Register while space is available.  Read more...
By Press Release 2015/03/26 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,033 reads

Unit Testing with SQL Server

Learn how to begin unit testing with tSQLt and SQL Server.   Read more...
By Alessandro Alpi 2015/03/26 | Source: | Category: unit testing
Rating: |  Discuss |   Briefcase | 4,083 reads

Self-maintaining, Contiguous Effective Dates in Temporal Tables

'Temporal' tables contain facts that are valid for a period of time. When they are used for financial information they have to be very well constrained to prevent errors getting in and causing incorrect reporting. This makes them more difficult to maintain. Is it possible to have both the stringent constraints and simple CRUD operations? Well, yes. Dwain Camps patiently explains the whole process.  Read more...
By Additional Articles 2015/03/26 | Source: SimpleTalk | Category: temporary tables
Rating: (not yet rated)  Rate this |   Briefcase | 5,416 reads

Level 6: Analyse & Deploy an AlwaysOn Availability Group

In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.  Read more...
By Perry Whittle 2015/03/25 | Source: | Category: cluster
Rating: |  Discuss |   Briefcase | 2,049 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/03/25 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 37,050 reads

Exploding the Myths of Big Data

As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.  Read more...
By Additional Articles 2015/03/25 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 7,881 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Creating a large data warehouse in Azure

Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server...  Read more...
By 2015/03/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 427 reads

Outlier Detection with SQL Server, part 4: Peirce’s Criterion

By Steve Bolton …………In the last couple of installments of this amateur series of self-tutorials on outlier identification with SQL Server,...  Read more...
By SQLServerSteve 2015/03/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 327 reads
Question of the Day

CTE Syntax

By Steve Jones 2015/03/30 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

Why do most CTE code samples start with a semi-colon?

Top Members (last 30 days)
# Name Score Level
30 days All-time
559 559 Mr or Mrs. 500  
427 1021 Ten Centuries  
Jeff Moden
299 36870 SSC-Dedicated  
252 2639 SSCrazy  
242 320 Old Hand  
Latest forum posts