SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Popular Content

6 DBA Lessons I Wish Someone Would Have Taught Me Earlier

The name of the Agent job isn't necessarily what it does, and just because your'e not getting failure emails doesn't mean the job is working.  Read more...
By Additional Articles 2018/10/05 | Source: Brent Ozar Unlimited Blog | Category: dba tips
Rating:  Rate this |   Briefcase | 6,059 reads

How Check Constraints MIGHT Improve Your Queries and Missing Index Requests

In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.  Read more...
Rating:  Rate this |   Briefcase | 3,533 reads

Index Tuning Week: How Many Indexes Are Too Many?

When you're not sure, start by aiming for 5 or less indexes per table, with 5 or less fields each.  Read more...
By Additional Articles 2018/11/02 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating:  Rate this |   Briefcase | 3,916 reads

Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters

In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.  Read more...
By Additional Articles 2018/09/17 | Source: MSSQLTips.com | Category: like
Rating:  Rate this |   Briefcase | 3,869 reads

Adaptive Query Processing in SQL Server 2017

As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new in 2017, represents a new direction. This set of features provides some flexibility for varying join types, multi-statement table valued functions, and memory grants. In this article, Robert Sheldon explains the three features that make up Adaptive Query Processing  Read more...
By 2018/10/25 | Source: SimpleTalk | Category: adaptive query processing
Rating:  Rate this |   Briefcase | 3,327 reads

SQL Prompt Code Analysis: Avoid using the ISNUMERIC Function (E1029)

Avoid using the IsNumeric() function, because it can often lead to data type conversion errors, when importing data. SQL Prompt Code Analysis rules include an Execution rule, E1029, which will alert you to use of this function, in your T-SQL. If you’re working on SQL Server 2012 or later, it’s much better to use the Try_Convert()or Try_Cast() function instead. On earlier SQL Server versions, the only way to avoid it is by using LIKE expressions.  Read more...
By 2018/09/11 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 3,869 reads

Avoid use of the MONEY and SMALLMONEY datatypes

One of SQL Prompt's code analysis recommendations is that you avoid using the MONEY and SMALLMONEY datatypes - this article from Phil Factor explains why.  Read more...
By 2018/05/04 | Source: Redgate | Category: code analysis
Rating:  Rate this |   Briefcase | 5,913 reads

Finding code smells using SQL Prompt: Asterisk in SELECT list

In this article Phil Factor explains how to find code smells using SQLPrompt: Asterisk in SELECT list  Read more...
By 2018/06/15 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 4,441 reads

An Easier Way of Pivoting Data in SQL Server

There are several methods to pivot, or transpose, data in T-SQL, but most are difficult to understand and write. Phil Factor demonstrates how to take advantage of JSON support, introduced with SQL Server 2016, to create a function that makes pivoting data simple.  Read more...
By 2018/02/16 | Source: SimpleTalk | Category: pivoting
Rating:  Rate this |   Briefcase | 7,389 reads

SQL Prompt as a Layout Tool: A Survival Guide

Phil Factor's guide to taming SQL Prompt layout options, and getting it to format code just the way you like it.  Read more...
By 2018/11/05 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 2,558 reads

Help Redgate improve Data Masker for SQL Server?

Redgate are looking for people to help them get a deep understanding of compliance and SQL Server data masking requirements in order to ensure they can provide a world class solution. In return for your feedback you’ll have early access to new releases, insights into new features and their ongoing support to get up and running.   Read more...
By 2018/11/08 | Source: Redgate | Category: data masking
Rating:  Rate this |   Briefcase | 2,268 reads

SQL Code Smells

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. There are now around 150 of these smells and SQL Code Guard is committed to cover as many as possible of them.  Read more...
By Additional Articles 2017/11/06 | Source: SimpleTalk | Category: sql
Rating:  Rate this |   Briefcase | 8,770 reads

SQL Clone V3: New features heighten visibility and manageability of clones and images.

With a brand new dashboard, activity feed and search functionality there is a lot happening in the SQL Clone v3 release. Check out the full breakdown of the update and get onto the latest version.   Read more...
By 2018/11/06 | Source: Redgate | Category: sql clone
Rating:  Rate this |   Briefcase | 1,875 reads

Changing Data Types on Large Tables: The INT to BIGINT Conundrum

Changing a data type seems like a simple task unless the table is quite large and downtime must be kept to a minimum. Danny Kruge walks you through the process he created to change an INT to a BIGINT in a large table.  Read more...
By Additional Articles 2018/03/13 | Source: SimpleTalk | Category: database administration
Rating:  Rate this |   Briefcase | 10,354 reads

Introduction to Agile with SQL Server

Working with SQL Server in Agile software development can be difficult. Ben Brumm provides an overview of Agile, specifically Scrum, and what to expect when SQL Server, or really any SQL platform, is involved.  Read more...
By 2018/01/17 | Source: SimpleTalk | Category: agile
Rating:  Rate this |   Briefcase | 5,721 reads

“But I don’t need to back up that database.”

Brent Ozar shares four stories of people who thought they could avoid backups - and got burned.  Read more...
By Additional Articles 2018/05/04 | Source: Brent Ozar Unlimited Blog | Category: backups
Rating:  Rate this |   Briefcase | 5,358 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.  Read more...
By Additional Articles 2018/01/09 | Source: SimpleTalk | Category: in-memory oltp
Rating:  Rate this |   Briefcase | 5,408 reads

Misuse of the scalar user-defined function as a constant

If you use an unverified scalar function, then the query will be grindingly slow because you will be executing it on every row whether it has a parameter or not. This post explains the issue in more depth, and shows how SQL Prompt code analysis rules can help you avoid it altogether.   Read more...
By 2018/03/05 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 4,805 reads

Questions about Data Governance that You Were Too Shy to Ask

A company’s data is one of its most valuable and important resources. Managing and protecting that data are big responsibilities, and a data governance processes must be put into place to avoid misuse and to meet regulations. In this article, William Brewer answers questions you may have about data governance but were too shy to ask.  Read more...
By Additional Articles 2018/02/19 | Source: SimpleTalk | Category: data governance
Rating:  Rate this |   Briefcase | 4,797 reads

Why is My Database Application so Slow?

When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.  Read more...
By Additional Articles 2017/11/02 | Source: SimpleTalk | Category: performance
Rating:  Rate this |   Briefcase | 7,282 reads