The Challenge Is on: Maintain a Custom Letter-Based Sequence

Apr 01, 2018

If you need to implement a custom sequence solution, and you want it to perform as well as possible, you need to ask yourself which guarantees the solution needs to provide versus which it doesn’t.

Sponsor Content

Accelerate Database Efficiency with SQL Performance Investigator (PI)

Mar 06, 2018

Get a wealth of information at a fraction of the impact of conventional collection methods. Foglight’s SQL Performance Investigator (SQL PI) ensures optimal database performance with comprehensive database, storage and virtualization monitoring...

Hire a PI to solve the mystery behind plan change

Mar 06, 2018

In this session, we’re setting up a coding crime lab to investigate plan change. Because running SQL statements with the right execution plan is crucial for database performance. But in some cases, due to various reasons, such as object changes...

Sponsor Content

Hire a PI to solve blocking locks mysteries

Mar 06, 2018

We’re bringing blocking locks into the interrogation room in this final installment of our webcast series. Blocked SQL statements are a common cause for database performance issues. When an application is poorly written, lock issues can impact the...

The Challenge Is on: Multi-Way Number Partitioning with T-SQL and SQL CLR

Feb 21, 2018

The challenge is known as multi-way number partitioning. Given a set of numbers S, representing quantities or weights, and a number of desired partitions, k, divide the quantities into k partitions such that the quantities are as evenly...

Sponsor Content

Solving SQL Server Performance Issues Caused by Problematic SQL Queries – The Tools You’ll Need

Feb 14, 2018

Available On Demand ...

Sponsor Content

Managing Cross-Platform Database Environments

Feb 01, 2018

In organizations large and small, database administrators (DBAs) are under pressure to adjust to changes in database technology, to adopt new database flavors like open source and NoSQL, and to ensure the best performance and stability for their...

Sponsor Content

SQL Server on Hyperconverged Infrastructure

Jan 05, 2018

Watch the webcast recording

Analyze Your Waits with SQL Dynamic Management View

Dec 23, 2017

You can analyze specific waits related to locking in your various SQL Server instances through a query against the sys.dm_os_wait_stats Dynamic Management View. We walk you through the process.

SQL Server: Avoiding a Sort with Merge Join Concatenation

Dec 18, 2017

There are cases when SQL Server doesn’t normally realize it can rely on index order, but you can make the platform realize it with some extra manipulation and creativity. This article is the first in a two-part series in which I describe such...