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,777,349 DBAs, developers and SQL Server users

Headlines today   January 26, 2015

Selecting from sub-queries as tables

Using sub-queries as tables only requires an alias 
By Ben Kubicek 2015/01/26 | Source: | Category: sub-queries
Rating: |  Discuss |   Briefcase | 7,538 reads

SQL Prompt Tip #7 - Begin End Highlighting

This SQL Prompt tip shows you how code highlighting makes it easier to find which items match up with each other.  Read more...
By Steve Jones 2015/01/26 | Source: | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,431 reads

Discrete and Continuous Data in SQL

Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constraints and the results of queries. Joe Celko explains.  Read more...
By Additional Articles 2015/01/26 | Source: SimpleTalk | Category: data
Rating: (not yet rated)  Rate this |   Briefcase | 4,357 reads
Previous headlines

Removing Duplicates

How to remove identify and remove duplicate data from your tables  Read more...
By Sioban Krzywicki 2015/01/23 (first published: 2013/10/08) | Source: | Category: duplicate data
Rating: |  Discuss |   Briefcase | 25,912 reads

Going to Extremes to Release Bug Fixes and New Features

Extreme Programming (XP) is no general panacea; but for the right team, and for a product that needs to release bug fixes and new features as fast as possible, its benefits are obvious. Working on one of Red Gate's most popular tools, SQL Prompt, Aaron Law and David Priddle use XP. But is their adherence to XP a personal preference or does it bring real benefits?   Read more...
By Additional Articles 2015/01/23 | Source: SimpleTalk | Category: extreme programming
Rating: (not yet rated)  Rate this |   Briefcase | 5,724 reads

Webinar: Oracle Exadata & In-Memory Real-World Performance

On January 28th 3PM GMT, Randolf Geist will present a free, one-hour webinar analyzing different database query profiles based on a real-world customer case. He'll also look at how these different profiles influence the efficiency of Exadata's features and the new Oracle In-Memory column store option. Register now.   Read more...
By Press Release 2015/01/23 | Source: Red-Gate | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 5,535 reads

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...
By David Rueter 2015/01/22 | Source: | Category: version tracking
Rating: |  Discuss |   Briefcase | 4,577 reads

Azure SQL Database Auditing

While a diminished level of control is certainly a factor to consider when contemplating migration of on-premises systems to Microsoft Azure, especially when dealing with PaaS resources such as Azure SQL Database, you have a range of techniques at your disposal that allow you to control and monitor both the status of and access to your Azure-resident services. One of these techniques is SQL Database auditing.  Read more...
By Additional Articles 2015/01/22 | Source: Database Journal | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 6,480 reads

SQL Monitor Custom Metric: Percentage of Fragmented Indexes

This is a general indicator of performance problems. Index fragmentation can affect the rate of return for moderate to large tables. If this value indicates an increased amount of index fragmentation throughout your database, you may need to fine-tune your indexes by redesigning, or rebuilding more frequently.  Read more...
By Press Release 2015/01/22 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,040 reads

A Custom Execution Method – Level 19 of the Stairway to Integration Services

The next level of the Stairway to Integration Services looks at how you can execute your package.  Read more...
Rating: |  Discuss |   Briefcase | 2,409 reads
Ask SQL Server Central

Question of the Day

Replication Filters

By Steve Jones 2015/01/26 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,011 reads

In SQL Server 2014, I want to relicate my sales table, which contains these columns:

If I only want to send sales that took place...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
631 833 SSC Eights!  
512 615 SSChasing Mays  
Jeff Moden
463 36296 SSC-Dedicated  
RK Mandava
372 2327 SSCrazy  
363 1975 SSCommitted  
Latest forum posts