Administration

Sweeping Up The Slackers

  • Article

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

Blogs

Use Jupyter Notebooks to Help People on StackOverFlow

By

I am sat in the PowerShell Saturday in Hamburg. You can see me on...

ACM Lecture at SELU

By

Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...

T-SQL Copy & Paste Pattern – Increasing a performance problem

By

Disclaimer: The title is my assumption because I saw it in the past happening...

Read the latest Blogs

Forums

Hyt*https://deontaywildervstysonfury.com/live/

By molintv6

Live Deontay Wilder vs Tyson Fury Tyson Fury vs Deontay Wilder Tyson Fury vs...

Needed to find all possible Dates Overlaps from a single Table

By Hell-1934

Hi, I have the following Episode table example: Where DischDate = "2020-02-20" means - client hasn't...

Optimize Cursor

By GrassHopper

I inherited this script that has a cursor and I know this query can...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Fashion

See possible answers