Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/04/19 to 2013/04/26

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 | 2,768 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 | 2,734 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,137 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 Stefan Krzywicki 2013/04/25 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 5,075 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,543 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,609 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 | 5,388 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 | 23,293 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,422 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,694 reads

Stay Backed Up by Monitoring Your Backup Process

Based on a linked server setup, you can check your SQL Server backups on multiple instances.  Read more...
By Willem Gossink 2013/04/22 | Source: SQLServerCentral.com | Category: monitor server
Rating: |  Discuss |   Briefcase | 3,770 reads

Diagnosing Common Database Ails

When a database starts showing signs of an illness, it's up to the DBA to get to the root of the problem, fast. Kat Hicks takes a look at the most common causes of database troubles, free tools that can help, and the misconceptions that get in the way.  Read more...
By Additional Articles 2013/04/22 | Source: SimpleTalk | Category: diagnostic
Rating: (not yet rated)  Rate this |   Briefcase | 3,992 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to CU14 for SP1 and CU12 for SP2 through MS14-044.  Read more...
By Steve Jones 2013/11/05 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 50,883 reads

Comparison of Queries Written in T-SQL and SQL Server MDX

Beginning to learn and comprehend SQL Server Analysis Services (SSAS) MDX queries can be difficult after one has spent years writing queries in T-SQL. When trying to write SQL Server MDX queries, it's worth considering "How would I write this query in T-SQL?"   Read more...
By Additional Articles 2013/04/19 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 3,977 reads

Using Regular Expressions to Convert PL/SQL code to T-SQL

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...
By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions
Rating: |  Discuss |   Briefcase | 9,488 reads