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

Welcome to SQLServerCentral.com

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

Rss
Headlines today   March 3, 2015

Data Warehouse to OData to Excel and R

How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.  Read more...
By Benjamin Seidle 2015/03/03 | Source: SQLServerCentral.com | Category: odata
Rating: |  Discuss |   Briefcase | 3,185 reads

Reviewing Logical Hard Drive details using T-SQL and OLE Automation Procedures

One of the most important SQL Server DBA tasks is checking logical hard drive details such as the total capacity, free disk space, and used space by the SQL Server data and log files. In this tip we look at a method to view this information in a faster and simpler way.  Read more...
By Additional Articles 2015/03/03 | Source: MSSQLTips.com | Category: ole automation
Rating: (not yet rated)  Rate this |   Briefcase | 2,064 reads

Silicon Valley - DLM Training Workshop – Database Continuous Integration

Learn how to do SQL Server continuous integration at the first in a new series of Database Lifecycle Management Training Workshops, in Silicon Valley on March 27. To celebrate the launch, places for this workshop are free.   Read more...
By Press Release 2015/03/03 | Source: Red-Gate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 1,495 reads
Previous headlines

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: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,700 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,974 reads

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: SQLServerCentral.com | Category: outer joins
Rating: |  Discuss |   Briefcase | 19,330 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,556 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,937 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,824 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,742 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Learn Methods to Know How to Rebuild SQL Master Database

All the system-level configuration settings and login account information of SQL server are stored in the corresponding SQL Master Database...  Read more...
By zorastalin 2015/03/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,539 reads

T-SQL EXCEPT and INTERSECT

T-SQL EXCEPT and INTERSECT Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...  Read more...
By Derek Wilson 2015/03/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,506 reads
Question of the Day

Creating schemas

By Steve Jones 2015/03/03 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 806 reads

You manage the systems at SQLServerCentral (SQL Server 2008). You have a new DBA, Steve, and you're a little concerned he might cause problems in the development environment. You decide...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Anshul Parmar
415 415 SSC-Addicted  
2.
patricklambin
353 2429 SSCrazy  
3.
rajasekhar.srs
317 318 Old Hand  
4.
Dilip D. Kulkarni
302 1038 Ten Centuries  
5.
blablablablakokos
261 261 SSC Veteran  
Latest forum posts