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

Headlines today   March 31, 2015

Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2

Arshad Ali demonstrates how you can use the command line interface to tune SQL queries and how you can use SQL Server Profiler to capture the workload for tuning with Database Engine Tuning Advisor.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,770 reads

Shredding Unicode Japanese characters using SSIS

This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS  Read more...
By Arun Mishra 2015/03/31 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 313 reads

SQL Monitor Custom Metric: Hash Warnings (Last Hour)

This alert is raised when the number of hash warnings events in the last hour goes above a specified threshold. A hash warning event means that part of the data processed for a hash operation was written to tempdb during query execution, which can degrade SQL Server Performance.  Read more...
By Press Release 2015/03/31 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,105 reads
Previous headlines

Obedience Training For Databases: Cascading Constraints

In which Phil Factor illustrates in TSQL how it is possible to use foreign key constraints to enforce data rules, and illustrates some surprising consequences of using cascading.  Read more...
By Phil Factor 2015/03/30 | Source: | Category: constraints
Rating: |  Discuss |   Briefcase | 2,191 reads

Identifying and Solving Index Scan Problems

When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you've identified the queries, what next? Dennes Torres gives some preliminary guidelines on how to find out why these index scans are being chosen for these queries and how to make the queries run faster and more efficiently.  Read more...
By Additional Articles 2015/03/30 | Source: SimpleTalk | Category: query plan
Rating:  Rate this |   Briefcase | 5,763 reads

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.  Read more...
By Ben Kubicek 2015/03/27 (first published: 2014/05/08) | Source: | Category: cumulative
Rating: |  Discuss |   Briefcase | 13,935 reads

Azure Blob Storage Part 9: Shared Access Signatures

In this article, Robin Shahan talks about security and how to control access to containers and blobs using shared access signatures (SAS) and stored access policies.   Read more...
By Additional Articles 2015/03/27 | Source: Just Azure | Category: blob storage
Rating: (not yet rated)  Rate this |   Briefcase | 5,412 reads

SQL Saturday #372 - Exeter, UK

SQL Saturday, organized by SQL South West, is coming to Exeter, England on April 25. This is sure to be a special event, and as always, offers a free day of training and networking. Register while space is available.  Read more...
By Press Release 2015/03/26 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,453 reads

Unit Testing with SQL Server

Learn how to begin unit testing with tSQLt and SQL Server.   Read more...
By Alessandro Alpi 2015/03/26 | Source: | Category: unit testing
Rating: |  Discuss |   Briefcase | 4,451 reads

Self-maintaining, Contiguous Effective Dates in Temporal Tables

'Temporal' tables contain facts that are valid for a period of time. When they are used for financial information they have to be very well constrained to prevent errors getting in and causing incorrect reporting. This makes them more difficult to maintain. Is it possible to have both the stringent constraints and simple CRUD operations? Well, yes. Dwain Camps patiently explains the whole process.  Read more...
By Additional Articles 2015/03/26 | Source: SimpleTalk | Category: temporary tables
Rating:  Rate this |   Briefcase | 6,101 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Exam Prep 70-463: Logging in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...  Read more...
By Colleen M. Morrow 2015/03/31 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,806 reads

Parsing XML Child Nodes and Converting to DateTime with PowerShell

As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to...  Read more...
By Rob Sewell 2015/03/31 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,083 reads
Question of the Day

Adding database file

By Dathuraj Pasarge 2015/03/31 | Category: files and filegroups
Rating: (not yet rated) |  Discuss |   Briefcase | 859 reads

While taking a database backup, you can add a new log file to the database?

Top Members (last 30 days)
# Name Score Level
30 days All-time
604 604 SSChasing Mays  
432 1036 Ten Centuries  
307 2704 SSCrazy  
Jeff Moden
283 36877 SSC-Dedicated  
241 321 Old Hand  
Latest forum posts