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

Rss
Headlines today   August 3, 2015

Do It Yourself Load Balancing with SSIS

This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database  Read more...
By Adam Aspin 2015/08/03 | Source: SQLServerCentral.com | Category: ssis
Rating: (not yet rated) |  Discuss |   Briefcase | 684 reads

Learning Columnstore Indexes

References and links to learn more about columnstore indexes.  Read more...
By Site Owners 2015/08/03 | Source: SQLServerCentral.com | Category: columnstore index
Rating: (not yet rated) |  Discuss |   Briefcase | 731 reads

Change operating modes for SQL Server Database Mirroring

SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between modes for an existing mirror and in this tip we will look at how this can be done.  Read more...
By Additional Articles 2015/08/03 | Source: MSSQLTips.com | Category: database mirroring
Rating: (not yet rated)  Rate this |   Briefcase | 336 reads
Previous headlines

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: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 13,071 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: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,059 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 | 1,447 reads

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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,429 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: SQLServerCentral.com | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 1,350 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: MSSQLTips.com | Category: data retention
Rating: (not yet rated)  Rate this |   Briefcase | 1,661 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,525 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Indexes on GUIDs – Not Only Fragmentation

A client called us with the following issue: He had a table of a few dozen million rows. The table had...  Read more...
By Matan_Yungman 2015/08/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 395 reads

Community Reactions to Power BI General Availability

Power BI is released to the public on Friday, 07/24. There’re both free and Pro versions. For full details about...  Read more...
By Samuel Vanga 2015/08/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 249 reads
Question of the Day

Logical File Names

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

If I wanted to change the logical names of my AdventureWorks 2012 database files, which of these queries will do this?


-- Query 1
ALTER DATABASE AdventureWorks2012
ADD FILE (NAME=ADW2012 REPLACES Adventureworks2012_data)

-- query...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Piotr Ryszkowski
660 2474 SSCrazy  
2.
sergey.gigoyan
620 620 SSChasing Mays  
3.
Rajan Patel
575 663 SSChasing Mays  
4.
Iwas Bornready
563 4993 SSCarpal Tunnel  
5.
r.preethi
515 525 Mr or Mrs. 500  
Latest forum posts