SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,896,347 DBAs, developers and SQL Server users

Headlines today   January 24, 2018

Stairway to Database Design Level 7: Triggers

In levels one to four, we built the tables, base and virtual, of a schema. Levels five and six dealt with stored procedures. This level deals with a feature you need to avoid as much as possible; this is article is on Triggers.  Read more...
By Joe Celko 2018/01/24 (first published: 2011/09/30) | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,073 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2018/01/24 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 33,032 reads

How to Change the Default Backup Directory

When you install a SQL Server instance you have the opportunity to identify the default location for your instance database backups. Overtime you might decide you want to change the default location for database backups. This tip shows you two different ways to change the default location for your database backups.  Read more...
By 2018/01/24 | Source: Database Journal | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 511 reads
Previous headlines

Azure DWH part 24: Elastic queries

This article will explain what is an elastic query and show an example.  Read more...
By Daniel Calbimonte 2018/01/23 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 352 reads

Validation, Verification, and Modification

A proper database design is very important, and changes to fix problems after the fact are expensive. In this article, Joe Celko discusses three aspects of database design that are often overlooked: validation, verification, and modification.  Read more...
By 2018/01/23 | Source: SimpleTalk | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 1,535 reads

Automatic Database Seeding

Set up and use the automatic databases seeding feature for Availability Groups.  Read more...
By Evgeny Garaev 2018/01/22 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 685 reads

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.  Read more...
By Steve Jones 2018/01/22 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,792 reads

Do Disabled Indexes Affect Missing Index Recommendations?

Brent Ozar opens up the Stack Overflow database, turns on actual execution plans, and runs a query that will cause SQL Server to beg and plead for an index.  Read more...
By 2018/01/22 | Source: Brent Ozar Unlimited Blog | Category: missing index finder
Rating: (not yet rated)  Rate this |   Briefcase | 1,722 reads

Free webinar: Database DevOps demo

Microsoft MVP Grant Fritchey, and Redgate’s Arneh Eskandari, will show you how Redgate’s Database DevOps solution works to improve your database development and deployment processes. You'll see a demo of tools from Redgate's SQL Toolbelt and see how they plug into GIT, Jenkins and Octopus Deploy. There will also be plenty of time to ask Grant and Arneh questions.  Read more...
By 2018/01/22 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,934 reads

Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes

An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.  Read more...
By Mike McQuillan 2018/01/19 (first published: 2016/06/15) | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 6,612 reads

From the SQLServerCentral Blogs

Linguistics Crisis In Microsoft Technology

With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product...  Read more...
By Jeffrey Yao 2018/01/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 557 reads

How I designed my VMware vSAN based Home Lab

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...  Read more...
By Klaus Aschenbrenner 2018/01/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 736 reads
Question of the Day

Object Slots

By Steve Jones 2018/01/24 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 155 reads

I've got this class (S4) in R. 

> setClass(
+ "NFLTeam",
+ representation(
+ name = "character",
+ City = "character",
+ conference = "character",
+ division = "character"
+ )
+ )

I create an instance with this code:

denver.broncos = new("NFLTeam", name="Broncos", City="Denver", conference="AFC", division="West")... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
40099 556194 SSC Guru  
Jeff Moden
37133 513271 SSC Guru  
Steve Jones - SSC Editor
22520 332804 SSC Guru  
Grant Fritchey
16723 224542 SSC Guru  
Lynn Pettis
16662 226541 SSC Guru  
Latest forum posts