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

Rss
Headlines today   September 28, 2016

Stairway to Exploring Database Metadata Level 3: Exploring Indexes

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.  Read more...
By Phil Factor 2016/09/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 428 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2016/09/28 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 74,918 reads

Faster DBCC CHECKDB with SQL Server 2016

DBCC CHECKDB is a built-in SQL Server command that allows you to check database integrity and consistency in one simple command, but running it on large databases can be a nightmare. In this article, Ahmad Yaseen explains how you can enhance the command to run faster in SQL Server 2016.  Read more...
By Additional Articles 2016/09/28 | Source: MSSQLTips.com | Category: dbcc checkdb
Rating: (not yet rated)  Rate this |   Briefcase | 711 reads
Previous headlines

PowerShell Solutions - Several tips for daily tasks

In this tip, we will talk about PowerShell and SQL Server Log and Data Files.  Read more...
By Daniel Calbimonte 2016/09/27 | Source: SQLServerCentral.com | Category: datafile
Rating: |  Discuss |   Briefcase | 1,243 reads

PowerShell Desired State Configuration: DSC Resources

Desired State Configuration (DSC) allows you to automate the way that you manage configuration data for software services as well as the environment in which these services run. DSC uses a set of built-in and custom 'resources' as the building blocks for a configuration. If you have specific requirements you may need to create the relevant resource to make the configuration happen. Nicolas Prigent provides a practical guide to DSC resources.  Read more...
By Additional Articles 2016/09/27 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 1,320 reads

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2016/09/26 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,153 reads

Expanding the uses of DBCC CLONEDATABASE

Erin Stellato goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 : DBCC CLONEDATABASE.  Read more...
By Additional Articles 2016/09/26 | Source: SQLPerformance.com | Category: dbcc clonedatabase
Rating: (not yet rated)  Rate this |   Briefcase | 1,956 reads

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.   Read more...
By Gregory Larsen 2016/09/23 (first published: 2015/05/27) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,003 reads

Querying Multiple MySQL Tables

It’s been said that one of the drawbacks to normalization to the third form (3NF) is more cumbersome data extraction due to the greater number of tables. These require careful linking via JOIN clauses. Improper table joining can easily result in erroneous results or even in the dreaded Cartesian Product. In today’s article, Rob Gravelle explores how table joins are achieved in MySQL.  Read more...
By Additional Articles 2016/09/23 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 2,184 reads

Audit and Compliance Survey

Redgate are trying to understand the broad problem of auditing and compliance from a database perspective. Though it's a wide-ranging topic, they're particularly interested in better understanding pain points in the area. Additional to the survey, they're also offering a $30 Amazon voucher for anyone who would be willing to participate in a short phone call.  Read more...
By 2016/09/23 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,176 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Query Store and Plan Forcing: What Do You Use It For

If you’re working with Azure SQL Database or you’ve moved into SQL Server 2016, one of the biggest new tools...  Read more...
By Grant Fritchey 2016/09/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 291 reads
Question of the Day

The Christmas CROSS APPLY

By Steve Jones 2016/09/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 294 reads

What will be returned by this code?


WITH vTally
AS (SELECT n = ROW_NUMBER() OVER (ORDER BY
(
SELECT NULL
)
)
FROM
(
VALUES
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8),
(9),
(0)
) a (n)
)
SELECT...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
rvsc48
521 2108 SSCrazy  
2.
GP Van Eron
356 2224 SSCrazy  
3.
matthewhodson
253 357 Old Hand  
4.
Jeff Moden
202 41436 SSC-Forever  
5.
GilaMonster
181 45302 SSC-Forever  
Latest forum posts