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

Rss
Headlines today   August 4, 2015

Display SSIS package version on the Control Flow design surface

In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we are modifying.  Read more...
Rating: |  Discuss |   Briefcase | 2,156 reads

Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations

There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This document provides insight into considerations and best practices for running SQL Server in Hyper-V Dynamic Memory configurations on Windows Server.  Read more...
By Additional Articles 2015/08/04 | Source: Microsoft MSDN | Category: hyper-v
Rating: (not yet rated)  Rate this |   Briefcase | 1,656 reads
Previous headlines

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: |  Discuss |   Briefcase | 4,020 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 | 1,812 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 | 1,492 reads

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,646 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,188 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,744 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,720 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,469 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Database Stuck in Single-User Mode Due to Botched Restore

Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the...  Read more...
By g00p3 2015/08/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,126 reads

What’s the Size of that Index?

I have previously written about finding what the big space consumers are within the database. I even shared scripts in...  Read more...
By Jason Brimhall 2015/08/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,311 reads
Question of the Day

READPAST vs. NOLOCK

By Sergey Gigoyan 2015/08/04 | Category: table hints
Rating: (not yet rated) |  Discuss |   Briefcase | 774 reads

We created ##tmpTest table and inserted data.We run Transaction. While running the transaction, we opened a new query window in the same database and run Query1 and Query2.


How many rows return...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Piotr Ryszkowski
792 2606 SSCrazy  
2.
sergey.gigoyan
688 688 SSChasing Mays  
3.
Rajan Patel
575 663 SSChasing Mays  
4.
Iwas Bornready
567 4997 SSCarpal Tunnel  
5.
r.preethi
517 527 Mr or Mrs. 500  
Latest forum posts