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,863,826 DBAs, developers and SQL Server users

Rss
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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,785 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: MSSQLTips.com | Category: dbcc shrinkfile
Rating: (not yet rated)  Rate this |   Briefcase | 2,024 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: SQLServerCentral.com | Category: data quality
Rating: |  Discuss |   Briefcase | 833 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,491 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,297 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: SQLServerCentral.com | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 212 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,391 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: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 1,466 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: SQLPerformance.com | Category: seeks
Rating: (not yet rated)  Rate this |   Briefcase | 2,282 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,658 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 | 551 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 | 873 reads
Question of the Day

Complex View Inserts

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

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


CREATE TABLE Schedules
(
PersonID INT
, BuildingID INT
, RoomNumber VARCHAR(20)
, DayNumber tinyint
, StartTime TIME
, EndTime TIME
, Capacity tinyint
)
GO
CREATE TABLE Classes (
Classname INT
...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GP Van Eron
1026 1196 Ten Centuries  
2.
peter.endean
265 275 SSC Veteran  
3.
Clive Roberts
252 1074 Ten Centuries  
4.
RVarn
202 411 SSC-Addicted  
5.
Jeff Moden
201 40993 SSC-Forever  
Latest forum posts