It is always bad news if your SQL queries are having to use the SORT operator. It is worse news if you get a warning that sort operations are spilling onto TempDB. If you have a busy, slow TempDB, then the effect on performance can be awful. You should check your query plans to try to eliminate SORTs and never leave a SORT warning unheeded. Fabiano Amorim shows the range of ways of getting information on what is going on with a query that is doing a SORT and when requests are made for memory.

Five Rules For Successful Conversations With DBAs

by Joshua Feierman

SQLServerCentral.com

As a developer working with SQL Server, you'll need to work with DBAs at one point or another. Here are some easy ways to make those conversations go smoothly.

The Internet of Things: A New World Order?

by Additional Articles

SimpleTalk

Was the marketing hook 'The Internet of Things' conjured up before the technical definition? Are we being persuaded to spend money on fending off yet another fantasy tsunami of data? Already, we have televisions that listen to, and report, your conversations; so are we facing the Science Fiction future of gadgets that report where you go, who you visit and what medications you take? As Robert Sheldon says; "It's big, almost too big to get your arms around".

Cardinality Estimator – What’s new in SQL Server 2014

by Alessandro Mortola

SQLServerCentral.com

Cardinality Estimator

SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are the biggest differences between the new CE and the previous one? Which one works better? Read more to find out.

Creating a multi-option parameter report for SQL Server Reporting Services

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

If you have a reporting requirement where users want to enter report parameters by either selecting values from a dropdown list or entering To and From range values, Ghanesh Prasad explains how to accomplish this in a Reporting Services report?.

Painless Refactoring of SQL Server Database Objects

by Additional Articles

SimpleTalk

Database objects

Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.

Kanban

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about organizing and tracking work with kanban and how that might help you.

What is Database Continuous Integration?

by Steve Jones

SQLServerCentral.com

Continuous Integration (CI)

This is an introductory article to explain what Continuous Integration (CI) is and how it can be used in database development.

Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table

by Additional Articles

MSSQLTips.com

Deleting Data

In this tip, Daniel Farina explains an unconventional way of deleting millions of old records from a table which is accessed by a system 24x7, and without impacting that system.

A Hazard of Using the SQL Update Statement

by Dwain Camps

SQLServerCentral.com

T-SQL

If you've never encountered this quirk of the SQL UPDATE statement, you should take a look and find a simple way around it.

Never Ignore a Sort Warning in SQL Server

Five Rules For Successful Conversations With DBAs

The Internet of Things: A New World Order?

Cardinality Estimator – What’s new in SQL Server 2014

Creating a multi-option parameter report for SQL Server Reporting Services

Painless Refactoring of SQL Server Database Objects

Kanban

What is Database Continuous Integration?

Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table

A Hazard of Using the SQL Update Statement

Blogs

Upgrading SQL Server Containers on the Laptop

How to Find Expensive Queries in Amazon Redshift

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

Forums

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

How Long is a Long I/O?

T-SQL Trigonometric Functions in SQL Server

Question of the Day

How Long is a Long I/O?