Additional Articles

Returning Sorted Record Sets Using the ORDER BY Clause

by Additional Articles

Database Journal

order by

Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.

2015-01-16

10,316 reads

Data Cleaning in SQL 2012 with Data Quality Services

by Additional Articles

SimpleTalk

data cleansing

Feodor Georgiev provides a thorough walkthrough on setting up SQL Server's Data Quality Services (DQS) and creating the rules it uses to function as a first step towards data cleansing.

2015-01-15

9,692 reads

Options to Improve SQL Server Bulk Load Performance

by Additional Articles

MSSQLTips.com

Bulk Load

In this tip Ben Snaidero looks at how to improve SQL Server Bulk Load performance. He focuses his performance tests on options using the BULK INSERT T-SQL command to judge how the various options affect speed.

2015-01-14

8,200 reads

Exploring Query Plans in SQL

by Additional Articles

SimpleTalk

Query plans

SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?

2015-01-13

9,693 reads

SQL Server PCI DSS Security Patching Checklist

by Additional Articles

MSSQLTips.com

Security

PCI DSS has strict requirements about implementing security updates and using only applications which are supported by the vendors. How do you create a patching policy for SQL Servers?

2015-01-12

5,700 reads

Backing up your SQL Server to Amazon's Cloud in Three Easy Steps

by Additional Articles

MSSQLTips.com

John Grover explains how to set up Amazon S3 storage, install and configure the Amazon PowerShell module, and set up a Maintenance plan using SQL native backups and PowerShell.

2015-01-09

7,435 reads

Archiving Hierarchical, Deleted Transaction Using XML

by Additional Articles

SimpleTalk

When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. In this article, Dwain Camps looks at a tidy means of doing just that.

2015-01-08

12,561 reads

Importance of Statistics and How It Works in SQL Server – Part 1

by Additional Articles

Database Journal

Query Optimizer

SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.

2015-01-07

8,382 reads

Add a linear trendline to a graph in SQL Server Reporting Services

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

In this article, Koen Verbeeck illustrates how to add a linear trendline to a graph in SSRS, similar to the way it would appear if done Excel.

2015-01-06

7,705 reads

Salesforce: A Very Straightforward Cloud Development Platform

by Additional Articles

SimpleTalk

salesforce

Force.com is an enigma; a Platform-as-a-Service that is designed to appeal to a broad church of developers, to make it quick and easy to write simple cloud-based applications. Robert Sheldon explains, as simply as possible, why this unusual data-centric, and metadata-driven platform is attracting so much interest in the industry.

2015-01-05

7,123 reads

All authors

Additional Articles

Returning Sorted Record Sets Using the ORDER BY Clause

Data Cleaning in SQL 2012 with Data Quality Services

Options to Improve SQL Server Bulk Load Performance

Exploring Query Plans in SQL

SQL Server PCI DSS Security Patching Checklist

Backing up your SQL Server to Amazon's Cloud in Three Easy Steps

Archiving Hierarchical, Deleted Transaction Using XML

Importance of Statistics and How It Works in SQL Server – Part 1

Add a linear trendline to a graph in SQL Server Reporting Services

Salesforce: A Very Straightforward Cloud Development Platform

Blogs

The Book of Redgate: Spread across the world

Merry Christmas

Self-Hosting a Photo Server the Whole Family Can Use

Forums

UNISTR Escape

Celebrating Tomorrow

SQL Art: I Made a Christmas Card In SSMS

Question of the Day

UNISTR Escape