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 2012/12/31 to 2013/01/07

Double Counting and Sign Reversals

Make the ad-hoc analysis of identifying potentially double-counted or sign-reversed Accounting transactions simple and painless.  Read more...
By Dwain Camps 2013/01/07 | Source: SQLServerCentral.com | Category: bin packing
Rating: |  Discuss |   Briefcase | 3,907 reads

How Come the Hourglass? Why Database Applications Slow Down

It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It could be, but there are other suspects that should be considered. Feodor Georgiev describes where, in the long route, to and fro', that a data request makes before returning, that things can get snarled up.  Read more...
By Additional Articles 2013/01/07 | Source: SimpleTalk | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,431 reads

The SSIS Data Pump - Level 2 of the Stairway to Integration Services

Learn the basics of data flow in SSIS with the data pump in this second installment of our series designed to teach you about Integration Services.  Read more...
By Andy Leonard 2014/06/27 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 46,461 reads

Row Sorting in SQL

It should be easy to model a game of poker in SQL. The problem is, however, that you need to model a permutation from a set of elements. Joe Celko argues that using a group of columns to do this isn't necessarily a violation of 1NF, since a permutation is atomic. Then comes the second problem: how would you sort such a column-base permutation in order? Sorting columns in SQL?  Read more...
By Additional Articles 2013/01/04 | Source: SimpleTalk | Category: row sorting
Rating:  Rate this |   Briefcase | 4,367 reads

Free eBook: Inside the SQL Server Query Optimizer

This free ebook from Red Gate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2013/02/07 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 11,180 reads

Single Quotation Marks in SQL

One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.  Read more...
By Kenneth Fisher 2014/07/11 (first published: 2013/01/03) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,538 reads

Partitioning in SQL Server

Partitioning has improved with each new version of SQL Server. From partitioned views in SQL Server 7.0 through partition table parallelism in SQL Server 2008. With SQL Server 2012, we are now allowed to even create up to a 15K partition on a single table.  Read more...
By Additional Articles 2013/01/03 | Source: Database Journal | Category: partitioning
Rating: (not yet rated)  Rate this |   Briefcase | 4,400 reads

Querying SQL Server Agent Job History Data

Often times we are tasked with having to programmatically come with a list of durations per SQL Server Agent Job to trend the run times and order the results by date. Unfortunately it's not always easy in the way the data is stored in the system tables in the MSDB database. This tip explains how to use the system tables to get the data into the correct format for dates and job durations.  Read more...
By Additional Articles 2013/01/02 | Source: MSSQLCity.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 3,128 reads

Stairway to SQL Server Agent: Level 1: Setup and Overview

SQL Server Agent is a Microsoft Windows service that allows a DBA to automate administrative tasks. SQL Server Agent can run jobs, monitor SQL Server, and process alerts. The SQL Server Agent service must be running before any jobs scheduled to execute automatically can be run  Read more...
By Richard Waymire 2013/01/02 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 16,065 reads

Automatically Generate Stored Procedures

This article will show you how to automatically generate insert, update, and delete procedures for tables in your database  Read more...
By James Skipwith 2013/01/01 (first published: 2011/02/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,966 reads

Free Tools for the DBA: PAL Tool

The Performance Analysis of Logs tool is a general tool for collecting and analysing log data. With the addition of a template, it becomes an effective way of analysing data from performance counters for SQL Server, in order to diagnose performance problems and capture baseline information.  Read more...
By Additional Articles 2013/01/01 | Source: SimpleTalk | Category: pal tool
Rating:  Rate this |   Briefcase | 5,356 reads

Copy SQL Server Analysis Services Dimensions

How can you copy dimensions from one SQL Server Analysis Services (SSAS) Project to another? Are there any options to do so? This tip outlines three approaches for SQL Server BI Professionals who need to copy dimensions from one SSAS project to another.  Read more...
By Additional Articles 2012/12/31 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 2,152 reads

Data Mining Introduction Part 2

This is a continuation of first article about Data Mining. We will talk about decision trees.  Read more...
By Daniel Calbimonte 2014/08/29 (first published: 2012/12/31) | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 13,327 reads