SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/03/26 to 2013/04/02

SQL Saturday #203 - Boston

Join us at SQL Saturday Boston on April 6th. SQL Saturday is a free training event for SQL Server Professionals and those wanting to learn more about SQL Server.  Read more...
By Press Release 2013/04/02 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 289 reads

Low Profile Architecture

The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.   Read more...
By Igor Zaychik 2013/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,779 reads

Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions

n a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it's even worse as the application uses db_owner. We're adding new tables to both databases and we don't want the application to have access to these tables. How can I deal with the use of these three roles?  Read more...
By Additional Articles 2013/04/02 | Source: MSSQLTips.com | Category: db_datareader
Rating: (not yet rated)  Rate this |   Briefcase | 3,605 reads


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,520 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,149 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,616 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: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 216 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: MSSQLTips.com | Category: stored procedure
Rating: (not yet rated)  Rate this |   Briefcase | 4,202 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: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 40,430 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: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 48,850 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: SQLServerCentral.com | Category: error handling
Rating: |  Discuss |   Briefcase | 5,478 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 | 3,134 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: SQLServerCentral.com | Category: sql intersection
Rating: (not yet rated) |  Discuss |   Briefcase | 134 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: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 128,115 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,883 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 | 2,247 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: SQLServerCentral.com | Category: sqlio
Rating: |  Discuss |   Briefcase | 3,035 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: MSSQLTips.com | Category: async
Rating: (not yet rated)  Rate this |   Briefcase | 4,200 reads