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/01/02 to 2013/01/09

SQL Server Rounding Functions - Round, Ceiling and Floor

I saw your recent tip on Calculating Mathematical Values in SQL Server and have some related issues as I try to round values in my application. My users and me have a difference of opinion on some of the calculations in our reporting applications. All of the code is in T-SQL, but I think the reporting issues are related to data types and rounding down or rounding up rules. Do you have any insight into these issues? I would like to see some examples with a variety of coding options.  Read more...
By Additional Articles 2013/01/09 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,201 reads

Stairway to XML: Level 1 - Introduction to XML

In this level, Rob Sheldon explains what XML is, and describes the components of an XML document, Elements and Attributes. He explains the basics of tags, entity references, enclosed text, comments and declarations  Read more...
By Rob Sheldon 2014/03/26 (first published: 2012/09/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 28,760 reads

Partitioning in SQL Server - Part 2

Arshad Ali examines the different concepts of partitioning in SQL Server 2012 and provides a step-by-step guide on creating a partition table/index.  Read more...
By Additional Articles 2013/01/08 | Source: Database Journal | Category: paritioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,606 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: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,631 reads

Using the Script Task in SSIS to Process Data Files When They Arrive

Learn how you can process data files with SSIS as soon as they arrive using the Script Task.  Read more...
By Orlando Colamatteo 2013/01/08 (first published: 2012/10/25) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 18,580 reads

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,905 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,429 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,273 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,176 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,482 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,397 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,122 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,040 reads