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

Free eBook: SQL Server Execution Plans

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.  Read more...
By Press Release 2013/01/17 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated)  Rate this |   Briefcase | 7,146 reads

Fun with ACID

What is ACID and why should we care? A look at the principal that drives all database and DB management software design: A.C.I.D.  Read more...
By Brandie Tarvin 2013/01/17 | Source: SQLServerCentral.com | Category: acid
Rating: |  Discuss |   Briefcase | 4,527 reads

Handling Errors in SQL Server 2012

The error handling of SQL Server has always been somewhat mysterious. Now at last, the THROW statement has been included in SQL Server 2012 that, when combined with the TRY...CATCH block, makes error handling far easier. Robert Sheldon explains all.  Read more...
By Additional Articles 2013/01/17 | Category: error handling
Rating:  Rate this |   Briefcase | 8,494 reads

SQL Server T-SQL Tuning – NOT IN and NOT Exists

Following on from the previous TSQL performance tuning article in this series, we now focus on the important topic of T-SQL “Not IN” And “Not Exists “  Read more...
By Additional Articles 2013/01/16 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 7,086 reads

Stairway to T-SQL DML Level 12: Using the MERGE Statement

The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.  Read more...
By Gregory Larsen 2014/08/20 (first published: 2013/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 19,395 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Redgate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,641 reads

How to write a custom metric

You can extend SQL Monitor to track whatever you need to watch on your own system with custom metrics. Grant Fritchey shows us how.  Read more...
By Grant Fritchey 2013/01/15 | Source: SQLServerCentral.com | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,445 reads

Creating SSIS Package Templates for Reusability

We often need to create similar SSIS packages which contain some common components such as connection managers, data flow components, log providers, event handlers, etc... So do we really need to create a package from scratch each time and add all these commonly used components in each package again and again. Is it possible to create a SSIS package with a basic structure/workflow and common components which can be used as template to create subsequent packages?   Read more...
Rating:  Rate this |   Briefcase | 3,337 reads

SQLServerCentral Runs sp_Blitz - Reliability

The second article that examines the output of the sp_Blitz script&trade; run against SQLServerCentral's database servers.  Read more...
By Steve Jones 2013/01/15 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 5,354 reads

Developing a SQL Server Backup Strategy

Developing a backup procedure that makes sure you can do restores should be one of your top priorities as a DBA. In this article Greg Larsen discusses some of the concepts to consider when developing, building and testing a backup strategy.  Read more...
By Additional Articles 2013/01/14 | Source: Database Journal | Category: backup and restore
Rating:  Rate this |   Briefcase | 3,242 reads

Using a TSQL semaphore in SSIS

This article shows how you can use a TSQL semaphore in SSIS.  Read more...
By Federico Iori 2013/01/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,713 reads

Using MDX to Calculate Both Values and Percentages for Analysis Services

When creating pie charts using data from Analysis Services, having the MDX query calculate and return the percentages along with the counts or sums is extremely efficient. In this tip, we walk through an example of how this can be done.  Read more...
By Additional Articles 2013/01/11 | Source: MSSQLTips.com | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 3,573 reads

Free eBook: SQL Server Tacklebox

Get a free ebook from Rodney Landrum and Red Gate Software that helps you prepare to deal with the various crisis situations you might encounter with SQL Server.  Read more...
By Site Owners 2013/01/11 | Source: SQLServerCentral.com | Category: career
Rating:  Rate this |   Briefcase | 4,669 reads

An Introduction to Database Design

An introduction to database design for those people that might not understand what is involved.  Read more...
By Paul White 2013/01/11 (first published: 2011/01/18) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 25,579 reads

Introducing Boomerang - A Notification Framework

Boomerang is a notification framework for IT professionals providing service oriented infrastructure with a SQL based rapid development interface.   Read more...
By Michael Malmgren 2013/01/10 | Source: SQLServerCentral.com | Category: notification
Rating: |  Discuss |   Briefcase | 2,157 reads

SQL Server T-SQL Tuning -TVF and Scalar Functions

A UDF is very convenient for centralising business logic as we can specify a set of business logic in one UDF which references multiple stored procedures and ad-hoc queries. However, they can lead to significant performance degradation due to their demands on the CPU  Read more...
By Additional Articles 2013/01/10 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 3,964 reads

SQLServerCentral Runs sp_Blitz - Security

A series that looks at the SQLServerCentral database servers using the Brent Ozar Unlimited sp_blitz script. Read about what we learned.  Read more...
By Steve Jones 2013/01/10 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 9,590 reads