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,062 reads

Blogs

Did you know we have another SQL Server book coming out?

By

SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...

Batch Scripting SQLCMD–#SQLNewBlogger

By

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

SQLpassion Online Training about Intelligent Query Processing

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Read the latest Blogs

Forums

Is a durable key always necessary in a dim?

By imani_technology

I want to use a Type 2 SCD SSIS transform on a dimension table...

Unable to shrink the log file

By Syed_SQLDBA

I have this on going issue where the log file of one of the...

Generating factsheet for system installation

By shp.shftr

Hello there, I've come to quite a frustrating decision. Up until now used a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers