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

Headlines today   May 6, 2015

Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

Using a CURSOR is not normally the best way to process through a set of records. Yet when a seasoned programmer moves to writing TSQL for the first time they frequently look for ways to process a sets of records one row at a time. They do this because they are not used to thinking about processing records as a set. In order to process through a TSQL record set a row at a time you can use a cursor. A cursor is a record set that is defined with the DECLARE CURSOR statement. Cursors can be defined as either read-only or updatable. In this article I will introduce you to using cursors to do record level processing one row at a time.   Read more...
By Gregory Larsen 2015/05/06 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,751 reads

SQL Monitor Custom Metric: Plan Cache; Cache Pages Total

This metric collects the number of 8-kilobyte pages that make up the plan cache to help identify memory pressure or plan cache pollution. A sudden drop in values for this metric may indicate that the instance is under memory pressure and SQL Server had to reclaim part of the plan cache for other use.  Read more...
By Press Release 2015/05/06 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,960 reads

Generating A Password in SQL Server with T-SQL from Random Characters

Dallas Snider explains how to use T-SQL to generate a random password that meets an organization's password requirements.  Read more...
By Additional Articles 2015/05/06 | Source: | Category: password
Rating: (not yet rated)  Rate this |   Briefcase | 2,208 reads
Previous headlines

DDL Auditing using the Default trace

This article explains how default trace can be used for auditing purposes when combined with PowerShell scripts  Read more...
By Nagaraj Venkatesan 2015/05/05 | Source: | Category: audit
Rating: |  Discuss |   Briefcase | 1,975 reads

Time Slots - An Essential Extension to Calendar Tables

After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality.  Read more...
By Additional Articles 2015/05/05 | Source: SimpleTalk | Category: calendar table
Rating: (not yet rated)  Rate this |   Briefcase | 3,485 reads

How do you work with databases?

How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.  Read more...
By Press Release 2015/05/05 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,761 reads

How to FTP a Dynamically Named Flat File

Learn how you can dynamically name a file in SSIS and then send it using the FTP task.  Read more...
Rating: |  Discuss |   Briefcase | 4,451 reads

MongoDB vs. Azure DocumentDB

There’s a new kid on the block in the NoSQL world – Azure DocumentDB. Released in preview back in August 2014 and going Generally Available this month, Azure DocumentDB is Microsoft’s initial foray into the increasingly competitive space of non-relational database management systems. Of course there is no better competitor in this space to measure up against than MongoDB. How close does DocumentDB stack up to MongoDB? Are they even close?  Read more...
By Additional Articles 2015/05/04 | Source: Just Azure | Category: nosql
Rating: (not yet rated)  Rate this |   Briefcase | 5,885 reads

The new Analytic functions in SQL Server 2012

SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.  Read more...
By Wayne Sheffield 2015/05/01 (first published: 2012/01/19) | Source: | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 25,742 reads

CONCAT and STUFF Functions in SQL Server 2012

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.  Read more...
By Additional Articles 2015/05/01 | Source: Database Journal | Category: concat
Rating: (not yet rated)  Rate this |   Briefcase | 6,182 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Moving SQL Server data between filegroups – Part 2 – The implementation

In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups...  Read more...
By aen 2015/05/06 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,977 reads
Question of the Day

Central Management Servers

By Steve Jones 2015/05/06 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 749 reads

I have three instances in my organization. They are named Dev01, QA01, and UAT01. I want to create a Central Management Server (CMS) to be able to execute various administrative...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
446 1437 Ten Centuries  
Eirikur Eiriksson
386 3641 Hall of Fame  
344 1016 Ten Centuries  
Grant Fritchey
300 15164 SSCoach  
Jeff Moden
261 37164 SSC-Dedicated  
Latest forum posts