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

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,628 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

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,721 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,592 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,158 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 | 4,003 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,594 reads

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,600 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 | 32,384 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,712 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 2014/09/01 (first published: 2012/10/25) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 29,030 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,930 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,692 reads