Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >> Headlines from 2013/03/25 to 2013/04/01


If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.  Read more...
By Andy Warren 2013/04/01 | Source: Other | Category: blogs
Rating:  Rate this |   Briefcase | 3,497 reads

TSQL Pivot Rotations using only REPLACE

Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the job done without GROUP BY or PIVOT, here is a way to do it using only REPLACE.  Read more...
By Additional Articles 2013/04/01 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 6,033 reads

Throttle a Query in Mid-Execution

Resource Governor provides a great mechanism for throttling resources, but it doesn't always allow granular control. Read about this trace flag that allows you to dynamically alter the resource usage of a query.  Read more...
By Steve Jones 2013/04/01 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 5,575 reads

SQL Saturday #197 - Omaha

Join us on April 6th in Omaha for SQL Saturday #197. SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.   Read more...
By Press Release 2013/03/29 | Source: | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 215 reads

Using the SQL Server APP_NAME function to control stored procedure execution

In this tip we will look at one way to achieve control of stored procedures to ensure that reuse is for the intended purpose and changes do not break other applications that may be using this same code.  Read more...
By Additional Articles 2013/03/29 | Source: | Category: stored procedure
Rating: (not yet rated)  Rate this |   Briefcase | 3,974 reads

Adding Rows in Incremental Loads - Level 3 of the Stairway to Integration Services

Learn how to incrementally load new rows into a database from an Integration Services package. MVP and SSIS guru Andy Leonard continues his series on learning SSIS.  Read more...
By Andy Leonard 2013/03/29 (first published: 2011/09/16) | Source: | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 39,069 reads

How to Post Performance Problems

How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw.  Read more...
By Gail Shaw 2014/01/17 (first published: 2009/06/12) | Source: | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 48,110 reads

Re-throw Errors with Logging

This article brings you a technique and framework to use in your stored procedures that can allow you to re-throw and log errors.  Read more...
By Harsha Majety 2013/03/28 | Source: | Category: error handling
Rating: |  Discuss |   Briefcase | 5,470 reads

Ad-Hoc XML File Querying

When you need to shred just part of the data within a large XML file into a SQL Server table, the most efficient way is to just select what you need via XQuery or by using XPath, before shredding it into a table. But precisely how would you do that?  Read more...
By Additional Articles 2013/03/28 | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,937 reads

Steve Jones and Grant Fritchey at SQL Intersection

SQL Server Central’s Steve Jones and Red Gate’s Grant Fritchey will be among a stellar line-up of speakers at SQL Intersection conference in Las Vegas on the 8th to the 11th of April.   Read more...
By Press Release 2013/03/27 | Source: | Category: sql intersection
Rating: (not yet rated) |  Discuss |   Briefcase | 132 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: | Category: best practices
Rating: |  Discuss |   Briefcase | 124,905 reads

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...
By Nakul Vachhrajani 2013/03/27 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,858 reads

SQL Server 2012 Integration Services - PowerShell-Based Project Deployment

You have the option of using PowerShell when automating management of SQL Server 2012 Integration Services. While this functionality is not as straightforward as those accustomed to traditional PowerShell cmdlets might expect, the steps required to accomplish the most common SSIS administrative tasks follow a relatively consistent pattern.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,953 reads

Data Mining SQLIO Results

Learn how to use Analysis Services Data Mining to identify the influence of RAID level and IO Pattern on Latency.  Read more...
By Paul Brewer 2013/03/26 | Source: | Category: sqlio
Rating: |  Discuss |   Briefcase | 3,027 reads

Red Gate brings SQL in the City back to London for the third year running

Data professionals are invited to attend Red Gate’s free SQL in the City event for a day of SQL Server training in London.  Read more...
By Press Release 2013/03/26 (first published: 2013/03/21) | Source: Redgate | Category: redgate software
Rating: (not yet rated) |  Discuss |   Briefcase | 644 reads

SQL Server's Auto Update Statistics Async Option

I have been trying to tune my SQL Server and I noticed a few database settings for statistics. I also read the previous tip on automatic statistics updates. Could you please describe the Auto Create Statistics Async option? How is this configured and when should I use it and when should I avoid using it?  Read more...
By Additional Articles 2013/03/26 | Source: | Category: async
Rating: (not yet rated)  Rate this |   Briefcase | 3,955 reads

Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks

You should be on your way with PowerShell with the previous levels and now the topic shifts to using Functions and Assemblies built in to .NET for use with automation. This topic will be used in your PowerShell adventures throughout your career and this Stairway.  Read more...
By Ben Miller 2013/03/25 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,013 reads

Data Science Laboratory System - Instrumentation

It is sensible to check the performance of different solutions to data analysis in 'lab' conditions. Measurement by instrumentation makes it easier to develop systems that are efficient.  Read more...
By Additional Articles 2013/03/25 | Source: SimpleTalk | Category: data science
Rating: (not yet rated)  Rate this |   Briefcase | 2,472 reads