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,818,089 DBAs, developers and SQL Server users

Headlines today   July 31, 2015

Dynamic Grouping in SSRS Reports

This article shows how you can create a dynamic report in SQL Server Reporting Services (SSRS), walking you through the steps needed to create a dynamically-grouped report.  Read more...
By Andy Owl 2015/07/31 (first published: 2012/10/11) | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 11,496 reads

Call for Speakers - SQL Saturday Pittsburgh

SQL Saturday #440 is coming to Pittsburgh on October 3, 2015. Now is the time to submit if you'd like to speak at the event.  Read more...
By Press Release 2015/07/31 | Source: | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 560 reads

SQL 2014 Clustered Columnstore Index Rebuild and Maintenance Considerations

Building (or rebuilding) a Columnstore index can be a resource intensive operation. In this article, Denzil Ribeiro describes the index rebuild process and index maintenance for clustered Columnstore indexes in SQL 2014.  Read more...
By Additional Articles 2015/07/31 | Source: SQLCAT | Category: clustered columnstore index
Rating: (not yet rated)  Rate this |   Briefcase | 678 reads
Previous headlines

Detecting Differences in Files on Servers

Detecting file differences on two different web servers using T-SQL.  Read more...
By Ed Wagner 2015/07/30 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,110 reads

Download tSQLt Today and Start Unit Testing

The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.  Read more...
By Press Release 2015/07/30 | Source: | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 1,206 reads

SQL Server Archive and Data Retention Considerations

Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.  Read more...
By Additional Articles 2015/07/30 | Source: | Category: data retention
Rating: (not yet rated)  Rate this |   Briefcase | 1,391 reads

Stairway to SQL Server Security Level 10: Row-Level Security

Unlike some other industrial-strength database servers, SQL Server lacks a built-in mechanism for protecting individual data records, called row-level security. This stairway level explores why you might want to use such a low-level granularity of data access security and how you can implement row-level security.  Read more...
By Don Kiely 2015/07/29 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,362 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2015/07/29 (first published: 2013/07/24) | Source: Redgate | Category: hardware
Rating:  Rate this |   Briefcase | 47,720 reads

Demystifying Oracle's Clustering Factor

One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, more specifically the distance between 'jumps' for a given index key. Commonly, a 'jump' is the number of blocks between rows containing the given index key starting with the first block found containing that key. If that sounds confusing don't despair, David Fitzjarrell explains in detail.   Read more...
By Additional Articles 2015/07/29 | Source: Database Journal
Rating: (not yet rated)  Rate this |   Briefcase | 2,172 reads

Visualize the timeline of your SQL jobs using Google graph and email

Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail  Read more...
By Theo Ekelmans 2015/07/28 | Source: | Category: jobs
Rating: |  Discuss |   Briefcase | 6,691 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

AdventureworksCI Step 5 Adding tSQLt to the solution

This is part of a series on how to take the Adventureworks database and bring it in line with modern...  Read more...
By Ed Elliott 2015/07/31 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 286 reads

Forgot sa password for your SQL Server?

It may happen so that you don`t know the password of sa user for SQL Server you inherited from somebody....  Read more...
By roman.horolskiy 2015/07/31 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,256 reads
Question of the Day

Global temporary table visibility

By Sergey Gigoyan 2015/07/31 | Category: global temporary table
Rating: (not yet rated) |  Discuss |   Briefcase | 527 reads
We opened 3 different queries(Query1, Query2, Query3) in SSMS on the same instance.¬†Firstly we execute Query1 which creates global temporary table and inserts the data. We execute Query2, ¬†Query2 is...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
Piotr Ryszkowski
644 2458 SSCrazy  
617 617 SSChasing Mays  
Rajan Patel
612 663 SSChasing Mays  
Iwas Bornready
570 4988 SSCarpal Tunnel  
522 525 Mr or Mrs. 500  
Latest forum posts