Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,785,659 DBAs, developers and SQL Server users

Headlines today   March 2, 2015

Are My Problems Caused By Replication?

We frequently need to discover the source of issues with our databases. This article provides information on how to detect replication on a database as a possible source of issues.  Read more...
By Eric Notheisen 2015/03/02 | Source: | Category: replication
Rating: |  Discuss |   Briefcase | 2,440 reads

Checking the Plan Cache Warnings for a SQL Server Database

How often do you check your query plans to see if they contain any warnings? If you're missing them, it means that you're not getting all those hints about missing indexes, join predicates or statistics. Is the query optimiser trying to tell you about implicit conversions? Dennes shows how to view the warnings in plan cache for a particular database using SQL.  Read more...
By Additional Articles 2015/03/02 | Source: SimpleTalk | Category: plan cache
Rating:  Rate this |   Briefcase | 2,701 reads
Previous headlines

Outer Join – What am I missing (SQL Spackle)

This article shows how to find missing rows in a table using a outer join.   Read more...
By Patrick Cahill 2015/02/27 (first published: 2013/11/12) | Source: | Category: outer joins
Rating: |  Discuss |   Briefcase | 19,095 reads

Cloud Storage Replication Is Not Backup

The options that you need to select when setting up an Azure Storage service account allow you to specify the durability and high-availability of your data, but they don't provide for data recovery to a point-in-time. In fact, it means that some of the bad things that can happen to data are more efficiently replicated to all copies. Backup is quite a separate issue.  Read more...
By Additional Articles 2015/02/27 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 5,317 reads

SQL Saturday #381 - Richmond, VA

SQL Saturday is coming to Richmond on March 21, 2015. Join us for a free day of SQL Server training and networking. There are also paid-for pre-con sessions available from Tim Mitchell and Kevin Kline. Register while space is available.  Read more...
By Press Release 2015/02/27 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,761 reads

The Potential of Joins

An article about how we underestimate the power of joins and degrade our query performance by not using proper joins  Read more...
By Ashutosh Pandey 2015/02/26 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,641 reads

Another Look at Tuning Big Data Queries

Most large organizations have implemented one or more big data applications. As more data accumulates internal users and analysts execute more reports and forecasts, which leads to additional queries and analysis, and more reporting. The cycle continues: data growth leads to better analysis, which generates more reporting. Eventually the big data application swells with so much data and querying that performance suffers.   Read more...
By Additional Articles 2015/02/26 | Source: Database Journal | Category: big data
Rating:  Rate this |   Briefcase | 7,501 reads

How do you develop and deploy your database?

Could you spare 3 minutes to do us a quick favor? Redgate’s running this short survey on how our readers develop and deploy databases. It’s just 12 multiple choice questions, so if you’ve got a couple of minutes to spare, we’d love to hear from you.  Read more...
By Press Release 2015/02/26 (first published: 2015/02/05) | Source: Red-Gate | Category: deployment process
Rating: (not yet rated)  Rate this |   Briefcase | 13,654 reads

Stairway To SQL Server Columnstore Indexes Level 1: A First Look At Columnstore Indexes

This level introduces of you to the fundamentals of columnstore indexes, introdused in SQL Server 2012 to manage the indexing of very large tables.  Read more...
By Hugo Kornelis 2015/02/25 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,838 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 2015/02/25 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 52,493 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Triggering a System Center Configuration Manager deployment task

A slightly different topic today. Once you have built up knowledge, you become the person that people ask to solve things....  Read more...
By Rob Sewell 2015/03/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,542 reads

This one enhancement makes AlwaysOn Availability Group better in SQL Server 2014 !

I keep getting questions on what is improved other than the increased number of secondaries(8 now) with AlwaysOn Availability Group(AG) in...  Read more...
By AnupWarrier 2015/03/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,915 reads
Question of the Day

XML Indexes

By Steve Jones 2015/03/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 768 reads

What are the categories of XML indexes that you can create in SQL Server 2014?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Anshul Parmar
412 412 SSC-Addicted  
360 2415 SSCrazy  
317 318 Old Hand  
Dilip D. Kulkarni
302 1038 Ten Centuries  
Jeff Moden
263 36607 SSC-Dedicated  
Latest forum posts