logging

External Article

Painless management of a logging table in SQL Server

  • Article

Tables that log a record of what happens in an application can get very large, easpecially if they're growing by half a billion rows a day. You'll very soon need to devise a scheduled routine to remove old records, but the DELETE statement just isn't a realistic option with that volume of data. Hugo Kornelis explains a pain-free technique for SQL Server.

2013-06-25

5,071 reads

SQLServerCentral Article

Logging with SQL Server

  • Article

This article from Ed Swiedler looks at using SQL Server to log activity from various sources. Service Broker and Windows Services are used to create a generic logging service that will build log files for you to examine outside of any application.

3.83 (6)

2010-01-06

3,654 reads

Blogs

Creating TAIL on Windows for Text Files

By

I wrote recently about making a HEAD utility to find the top few lines...

Daily Coping 17 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

The book that made me love goal-setting

By

Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...

Read the latest Blogs

Forums

Select * (Sql query)

By fri

Hi, I have a problem like below one. Give, for each train station, the...

SQL Query

By akhil

Hi, I'm struggling to solve this problem....I hope will get a answer here. count,...

Combine or join 3 tables, 1 for each databases

By pedroccamara

Hello guys, I hope you're all great and healthy I would love to learn...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers