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

Previous headlines

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,846 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,299 reads

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 | 848 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,636 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,468 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 | 216 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,464 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,478 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,349 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,733 reads
 
Ask SQL Server Central



Question of the Day

Complex View Inserts

By Steve Jones 2016/07/29
Rating: (not yet rated) |  Discuss |   Briefcase | 611 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
224 1074 Ten Centuries  
4.
Jeff Moden
207 40998 SSC-Forever  
5.
RVarn
202 411 SSC-Addicted  
Latest forum posts