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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,897,565 DBAs, developers and SQL Server users

Rss
Headlines today   February 23, 2018

Get Set For Speed

Loops are common in application code, but set-based solutions are the way to go with SQL.  Read more...
By Tom Staab 2018/02/23 (first published: 2015/12/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,219 reads

"But It Worked in Development!" - 3 Hard SQL Server Performance Problems

You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.  Read more...
By Additional Articles 2018/02/23 | Source: Brent Ozar Unlimited Blog | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 537 reads

Avoid T-SQL Technical Debt using SQL Prompt Code Analysis

SQL Prompt’s new Code Analysis feature helps you discover code issues and hidden pitfalls during code development, as you type. In this article, Catherine shows how the Code Analysis feature works, and illustrates how to use the feature to improve the quality of your team’s SQL code.  Read more...
By 2018/02/23 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 288 reads
Previous headlines

Performance Comparison Between SQL Server 2014 and 2016

This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.  Read more...
By Savaram Ravindra 2018/02/22 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 1,022 reads

Introducing a DevOps culture

Your organization’s culture of DevOps will often be the defining factor on whether you have a successful organizational change, or whether the changes that you implement impact pockets of your organization.  Read more...
By 2018/02/22 | Source: Redgate | Category: devops
Rating:  Rate this |   Briefcase | 1,790 reads

Degree of Duplication

Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe Celko reminisces about the history of database design and how it relates to the concept of ‘Degree of Duplication’ in this article.  Read more...
By Additional Articles 2018/02/22 | Source: SimpleTalk | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 1,523 reads

Stairway to Database Design Level 9: Normalization

In the final step of Database Design, Joe Celko gives a simple but effective explanation of the normalization process and why it is important.  Read more...
By Joe Celko 2018/02/21 (first published: 2011/11/11) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,228 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2018/02/21 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 92,286 reads

SQL Server Reporting Services 2017 Tutorial

SQL Server Reporting Services has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, web front end and security make SSRS the tool of choice.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,479 reads

Solve Sudoku with T-SQL - Part 1

A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.  Read more...
By bevan ward 2018/02/20 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 1,607 reads
 

From the SQLServerCentral Blogs

How I Used Pragmatic Works Training to Pass the Power BI 70-778 Certification

Recently I took and passed the Microsoft certification exam 70-778 for Power BI called Analyzing and Visualizing Data with Microsoft...  Read more...
By Devin Knight 2018/02/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 464 reads

Hobbies, stress relief, and meeting management: T-SQL Tuesday #99

It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that...  Read more...
By Kenneth Fisher 2018/02/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 496 reads
Question of the Day

Recursive Queries

By Evgeny Garaev 2018/02/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

What would you get by executing this query:


with cnumbers as
(
select 1 as i
union
select i+1
from cnumbers
where i < 10
)
select i
from cnumbers;
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
36585 592546 SSC Guru  
2.
Jeff Moden
32264 545329 SSC Guru  
3.
Steve Jones - SSC Editor
20140 352800 SSC Guru  
4.
Grant Fritchey
15038 239481 SSC Guru  
5.
Lynn Pettis
14386 240819 SSC Guru  
Latest forum posts