Tag: query

Pro Members SQL Server Standard Members

SQL Server 2016 Transact-SQL Optimization Tips (Part 1)

by

SQL Server 2016 Transact-SQL Optimization Tips (Part 1) Consider using a new query hint NO_PERFORMANCE_SPOOL. This hint was first introduced in SQL Server 2016 and can prevent a spool operator from being added to query plans. This can improve performance when many concurrent queries are running with spool operations. Try to restrict the queries result set by using the WHERE...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Development Pro Members Standard Members

Gearing up the Business for Data Analytics–Part III

by

Gearing up the Business for Data Analytics — Part III In the Part II of this series we briefly looked at the "Analytical Glossary of Requirements" Matrix. In this article we will try to understand how we construct the "Data availability matrix" for the requirement questions that were articulated in the "Analytical Glossary of Requirements". The term "data availability" is...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 Analysis Services problems

by

Troubleshooting SQL Server 2012 Analysis Services problems If you have problems with SQL Server 2012 Analysis Services, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 Analysis Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2012 Transact-SQL Optimization Tips

by

SQL Server 2012 Transact-SQL Optimization Tips Try to restrict the queries result set by using the WHERE clause. This can results in good performance benefits, because SQL Server will return to client only particular rows, not all rows from the table(s). This can reduce network traffic and boost the overall performance of the query. Avoid using optimizer hints in your...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

XML Support and SQL Server (Part 5)

by

XML Support and SQL Server (Part 5) By Basit A. Farooq Editor’s Note: This article is the fifth part of my XML support and SQL Server article series. In this part, I’ll discuss the basic XML queries and data manipulation. I’ll also give the brief introduction to the XQuery language and the use of query(), value(), exist(), nodes(), and modify()...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2012 Full-Text Search Optimization Tips

by

SQL Server 2012 Full-Text Search Optimization Tips Consider using the new custom NEAR option of the CONTAINS predicate or CONTAINSTABLE function. SQL Server 2012 introduces new custom NEAR option of the CONTAINS predicate or CONTAINSTABLE function. By using the custom NEAR option you can do the following: – optionally specify the maximum number of non-search terms that separate the first...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Query Notifications

by

Troubleshooting problems with SQL Server 2008 R2 Query Notifications If you have problems with SQL Server 2008 R2 query notifications, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 query notifications bugs were fixed in SQL Server service packs, you should install the latest SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting xml problems in SQL Server 2008 R2

by

Troubleshooting xml problems in SQL Server 2008 R2 If you have problems with xml in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 xml bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →