Daily SQL Server knowledge direct to your inbox.
Sign up
<a href="//g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
<a href="//g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,868,560 DBAs, developers and SQL Server users
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
|
652 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
|
75,198 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
|
1,013 reads
Show more
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,297 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,364 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,167 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,984 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,016 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,209 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,206 reads
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
|
422 reads
Browse all
Question of the Day
The Christmas CROSS APPLY
By
Steve Jones
2016/09/28
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
542 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...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
rvsc48
524
2111
SSCrazy
2.
GP Van Eron
356
2224
SSCrazy
3.
matthewhodson
254
358
Old Hand
4.
Jeff Moden
194
41436
SSC-Forever
5.
GilaMonster
181
45308
SSC-Forever
Show more
Latest forum posts
The Christmas CROSS APPLY
By
Steve Jones - SSC Editor
|
Sep 28, 2016
Posted to
Discuss Content Posted by Steve Jones
What is the Future of Monitoring?
By
Eric M Russell
|
Sep 28, 2016
Posted to
Editorials
Searching for a value across all columns of a single table
By
drew.allen
|
Sep 28, 2016
Posted to
SQL Server 2008 - General
Deadlock on a "queued DELETE"
By
Lynn Pettis
|
Sep 28, 2016
Posted to
Development - SQL Server 2014
Help with sorting data from two tables
By
John Mitchell-245523
|
Sep 28, 2016
Posted to
SQL Server 2012 - T-SQL
Sign up for daily SQL Server insight.
Sign up
Copyright © 2002-2016 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
