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

Headlines today   August 5, 2015

Stairway to Columnstore Indexes Level 4: Catalog Views

In this level, we will first take a look at how to recognize columnstore indexes in some of the generic catalog views. After that we will investigate the new catalog views that have been added just for columnstore indexes.  Read more...
By Hugo Kornelis 2015/08/05 | Source: | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 525 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2015/08/05 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 60,201 reads

Microsoft and Database Lifecycle Management (DLM): The DacPac

The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. As such, it seems to provide an obvious cost-free start for tackling automated Database Delivery as part of Database Lifecycle Management (DLM). We asked Phil Factor if it is ready for Prime-time.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 763 reads
Previous headlines

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,256 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,789 reads

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: | Category: ssis
Rating: |  Discuss |   Briefcase | 4,082 reads

Learning Columnstore Indexes

References and links to learn more about columnstore indexes.  Read more...
By Site Owners 2015/08/03 | Source: | Category: columnstore index
Rating: (not yet rated) |  Discuss |   Briefcase | 1,836 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: | Category: database mirroring
Rating: (not yet rated)  Rate this |   Briefcase | 1,548 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: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 13,679 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 | 1,221 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Synchronous Processing in the SSIS Script Component

Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component.  This control grants...  Read more...
By Tim Mitchell 2015/08/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 528 reads

Halloween at PASS–Donate for some fun

This year’s PASS Summit will end on Oct 30, which is just before Halloween in the US. I’m sure lots...  Read more...
By Steve Jones 2015/08/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 194 reads
Question of the Day


By Naveen PK 2015/08/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 309 reads
How many times is 'Variable @BitToggle toggled' printed? 

CREATE TABLE #DontPreferCursor (LoopValue TINYINT)

INSERT #DontPreferCursor Values (1),(2),(3),(4),(5),(6),(7),(8)

SELECT LoopValue FROM #DontPreferCursor

DECLARE @BitToggle Bit
DECLARE @LoopCur Tinyint

OPEN LoopCursor
INTO... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
Piotr Ryszkowski
815 2629 SSCrazy  
689 689 SSChasing Mays  
Iwas Bornready
567 4997 SSCarpal Tunnel  
517 527 Mr or Mrs. 500  
Rajan Patel
378 663 SSChasing Mays  
Latest forum posts