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

Welcome to

A Microsoft SQL Server community of 1,863,815 DBAs, developers and SQL Server users

Headlines today   July 29, 2016

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.  Read more...
By Gregory Larsen 2016/07/29 (first published: 2014/07/23) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,715 reads

Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation

Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.  Read more...
By Additional Articles 2016/07/29 | Source: | Category: dbcc shrinkfile
Rating: (not yet rated)  Rate this |   Briefcase | 1,791 reads
Previous headlines

Data Quality - Addressing non-stated requirements

Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.  Read more...
By David Poole 2016/07/28 | Source: | Category: data quality
Rating: |  Discuss |   Briefcase | 821 reads

A Real-World React.js Setup for ASP.NET Core and MVC5

React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat of a phenomenon, with many active users. In this article, Jon Smith provides multiple examples of how to use React with recently released ASP.NET Core MVC, and the existing ASP.NET MVC5 framework.  Read more...
By Additional Articles 2016/07/28 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 1,432 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2016/07/27 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 75,241 reads

Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.  Read more...
By Mike McQuillan 2016/07/27 | Source: | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 209 reads

Temporal Data Part 2 - Creating and Deleting System-Versioned Tables

Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history temporal table.  Read more...
By Additional Articles 2016/07/27 | Source: Database Journal | Category: temporal data
Rating: (not yet rated)  Rate this |   Briefcase | 1,367 reads

Azure SQL Limitations compared with a SQL Server Enterprise

In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.  Read more...
By Daniel Calbimonte 2016/07/26 | Source: | Category: azure sql database
Rating: |  Discuss |   Briefcase | 1,462 reads

What's "Actually" going on with that Seek?

Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.  Read more...
By Additional Articles 2016/07/26 | Source: | Category: seeks
Rating: (not yet rated)  Rate this |   Briefcase | 2,257 reads

Redgate’s 2016 Roadmap

What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing this year. Find out more.  Read more...
By Additional Articles 2016/07/26 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,624 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Deploying Row Level Security with SQL Compare

Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for...  Read more...
By Steve Jones 2016/07/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 484 reads

SQL Server 2016 FK operator bug?

I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016....  Read more...
By Daniel Janik 2016/07/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 773 reads
Question of the Day

Complex View Inserts

By Steve Jones 2016/07/29
Rating: (not yet rated) |  Discuss |   Briefcase | 536 reads

I've got this DDL for a few tables and views.

PersonID INT
, BuildingID INT
, RoomNumber VARCHAR(20)
, DayNumber tinyint
, StartTime TIME
, EndTime TIME
, Capacity tinyint
Classname INT
... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
GP Van Eron
1026 1196 Ten Centuries  
265 275 SSC Veteran  
Clive Roberts
253 1074 Ten Centuries  
228 3332 Hall of Fame  
224 411 SSC-Addicted  
Latest forum posts