Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,770,914 DBAs, developers and SQL Server users

Headlines today   December 24, 2014

Stairway to PowerPivot and DAX - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/12/24 (first published: 2014/08/27) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,423 reads

SQL Server Data Aggregation for Data with Different Sampling Rates

In the emerging "Internet of Things", there are multitudes of devices collecting data at differing sampling rates. Integrating this data so the data has a common granularity in time is important to not only allow for accurate analysis and mining, but it will also aid in reducing the amount of data to be stored and processed. In this tip, we will demonstrate how to use the T-SQL AVG function and GROUP BY clause to transform data collected from two devices sampling at 100Hz and 40Hz to one row per second.   Read more...
By Additional Articles 2014/12/24 | Source: | Category: aggregate transform
Rating: (not yet rated)  Rate this |   Briefcase | 3,419 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/12/24 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 34,986 reads
Previous headlines

Dealing with the Evil of FMTONLY from SSRS

SSRS continues to use SET FMTONLY ON even though it has many problems. How can we cope?  Read more...
By David Rueter 2014/12/23 | Source: | Category: ssrs
Rating: |  Discuss |   Briefcase | 3,141 reads

Practical PowerShell Unit-Testing: Mock Objects

Pester allows you to automate the testing of PowerShell scripts. It can test the output of a function as you develop it by validating simple data (scalars) and arrays, and allows you to focus on the one function you want to test by using 'mocking' to fake all the other functions and Cmdlets.  Read more...
By Additional Articles 2014/12/23 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 3,859 reads

The Big Database Freeze

When a hospital’s mission-critical database fails at Christmas, disaster for the hospital – and its hapless DBA – seems certain. With less than an hour to spare before catastrophe, can the DBA Team save the day? This is a fictionalized true story.  Read more...
By Additional Articles 2014/12/23 (first published: 2014/12/04) | Source: Red-Gate | Category: verify
Rating: (not yet rated)  Rate this |   Briefcase | 12,511 reads

Linked lists

Learn how you can achieve better performance with linked list instead of a numbering column.  Read more...
By Andreas Bartels 2014/12/22 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,435 reads

Using the MERGE Statement to Perform an UPSERT

The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement. Not only does the MERGE statement support the UPSERT concept, but it also supports deleting records. Greg Larsen discusses how to use the MERGE statement to UPDATE, INSERT and DELETE records from a target table.   Read more...
By Additional Articles 2014/12/22 | Source: Database Journal | Category: merge
Rating:  Rate this |   Briefcase | 7,907 reads

What, when and who? Auditing 101 - Part 3

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.  Read more...
By Roy Ernest 2014/12/19 (first published: 2012/05/31) | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 12,219 reads

SQL Server Analysis Services Attribute Relationships

This tip looks at some of the questions around attribute relationships in SQL Server Analysis Services, including why you need them, how to create them, and the common data sets involved.  Read more...
By Additional Articles 2014/12/19 | Source: | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 5,124 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

WordPress, Project NAMI, and Azure

I’ve been running WordPress for years now and find it to be a solid solution for what I want to...  Read more...
By Andy Warren 2014/12/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,917 reads
Question of the Day

Parallel Plans

By Steve Jones 2014/12/24 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 460 reads

The documentation has these conditions stated for choosing a serial plan instead of a parallel plan.

The serial execution cost of the query is not high enough to consider an...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
512 1175 Ten Centuries  
Shiva N
474 1021 Ten Centuries  
467 1521 SSCommitted  
408 1546 SSCommitted  
320 763 Right there with Babe  
Latest forum posts