SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/04/23 to 2013/04/30

Ordered Loading of Databases Tables Using SSIS

Finding the load order for inserting data into a that respects referential integrity is sometimes difficult. If you are using SSIS, the task is made easier.  Read more...
Rating: |  Discuss |   Briefcase | 4,653 reads

Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth

You've just become responsible for a database, only to find that the log file is growing out of control. Why is it happening and what do you do to correct it?  Read more...
By Additional Articles 2013/04/30 | Source: SimpleTalk | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 5,034 reads

SQL Saturday #209 - Rochester

A free day of SQL Server training in upstate New York.  Read more...
By Steve Jones 2013/04/29 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,206 reads

SQL Server 2012 Integration Services - Using PowerShell to Configure Package Execution Parameters

Marcin Policht explores some of PowerShell's SSIS-specific automation capabilities by demonstrating the process of configuring an already deployed package in order to carry out a parameterized package execution.  Read more...
By Additional Articles 2013/04/29 | Source: Database Journal | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 2,210 reads

Parallel Processing Using Jobs

Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.  Read more...
By Peter Sloboda 2013/04/29 | Source: SQLServerCentral.com | Category: agent jobs
Rating: |  Discuss |   Briefcase | 6,510 reads

Unpack an Integer with SQL Server Recursion

Starting with SQL Server 2005, developers have had recursion available as a T-SQL language feature. This article describes recursion and its SQL Server implementations, complete with examples. It also includes SQL Server functions and a stored procedure that unpacks, or parses, an integer into its multiple-of-two components.  Read more...
By Additional Articles 2013/04/26 | Source: Database Journal | Category: integers
Rating: (not yet rated)  Rate this |   Briefcase | 3,105 reads

Registration is open for SQL Relay

SQL Relay is an annual community-run series of SQL Server training events across the UK. SQL Relay will run 8, 1-day conferences over the course of 2 weeks starting June 17th. Speakers from Microsoft, global IT companies, and a host of MVPs, are covering topics on DBA, business intelligence, and development.  Read more...
By Press Release 2013/04/26 | Source: SQLServerCentral.com | Category: sql relay
Rating: (not yet rated)  Rate this |   Briefcase | 3,169 reads

A Check and Foreign Key Constraint Improves Query Performance

Check and foreign key constraint do not degrade performance but actually improve it.  Read more...
By Sarvesh Singh 2013/04/26 (first published: 2010/10/21) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,674 reads

Find the Currently Running Scheduled Job

Ever need to automatically stop a long running job? Ever need to find which named Schedule is the currently running version of your job? There's simple code that'll let you find out.  Read more...
By Sioban Krzywicki 2013/04/25 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 5,142 reads

Solving Complex T-SQL Problems, Step-By-Step

What should you do if your first, most intuitive solution to a problem ends up scanning the data more than is necessary, resulting in poor performance? Have you missed a new SQL Server feature that can remove inefficiency from your technique? Alternatively, do you need a little help, and some lateral thinking, to open the path to a different approach? Sometimes, the answer is "both".  Read more...
By Additional Articles 2013/04/25 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 6,905 reads

Custom Metrics for Monitoring Database Mirroring

SQL Monitor comes with plenty of metrics, but there are always going to be things that you want to measure that can't be done 'out of the box'. Taking database mirroring as an example, Grant shows that custom metrics can be used to monitor and alert whatever aspect of SQL Server or database that you need.  Read more...
By Additional Articles 2013/04/24 | Source: SimpleTalk | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,890 reads

Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log

Our major goal in terms of log maintenance for all databases under our care is to optimize for write performance, in order to support all activities that require SQL Server to write to the log, including data modifications, data loads, index rebuilds, and so on. However, it's also important to keep an eye on possible log fragmentation, which, as described previously, can affect the performance of processes that need to read the log, such as log backups and the crash recovery process.  Read more...
By Tony Davis 2013/04/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,363 reads

SQL Server Trace Flags

A comprehensive list of trace flags for SQL Server that you can use to configure your server instance.  Read more...
By Yusuf Anis 2013/07/05 (first published: 2010/06/03) | Source: SQLServerCentral.com | Category: trace flags
Rating: |  Discuss |   Briefcase | 25,528 reads

SQL Server Central Webinar Series #23: Safeguard your data offsite with SQL Backup Pro

You may already have a great backup and recovery plan. However, if something were to happen to your databases and you needed to restore from your backups, you’d want to be in control, with the ability to access a copy of those backups quickly, restoring them with minimal downtime and minimal fuss. In this session Grant Fritchey, SQL Server MVP, will discuss the key reasons why you need to have offsite backups, and the advantages of hosted storage. He’ll address some of the fears surrounding cloud backups, and show how offsite backup is made quick and easy with the new ‘backup to hosted storage’ features in SQL Backup Pro 7.3.   Read more...
By Press Release 2013/04/23 (first published: 2013/04/16) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,739 reads

Using FULL JOINs to Compare Datasets

This article describes a technique of using FULL JOINs to compare two datasets within a numerical tolerance.  Read more...
By Mark Murphy 2013/04/23 (first published: 2010/09/27) | Source: SQLServerCentral.com | Category: full join
Rating: |  Discuss |   Briefcase | 28,872 reads