Steve Jones

Sweeping Up The Slackers

Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.

5 (1)

2001-05-07

5,068 reads

Blogs

Using WAITFOR to Test Slow Code–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Power BI Monthly Digest – May 2020

By

This month we will likely have two releases of the Power BI Desktop. In...

Three big reasons T-SQL still beats the GUI – a MinionWare snippet

By

We like code better than mouse clicks for three basic reasons: T-SQL lets you...

Read the latest Blogs

Forums

The Basics of Using a Sequence as a Table Default

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Basics of Using a...

Inlining Scalar UDFs

By Greg Larsen

Comments posted to this topic are about the item Inlining Scalar UDFs

Question About Microsoft Data Migration and the MAP

By imani_technology

Hi, has anyone ever transformed the raw output generated by Microsoft Assessment and Planning...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers