logging

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

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

Blogs

SQL Clone Works with FILESTREAM

By

SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...

Fun and profit with UTF-8

By

When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...

Data Platform MVP 2020

By

I am humbled to be among so many great professionals and honored at the...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Use a while loop or cursor for querying row by row and insert results into temp

By sathwik.em91

Hi, connectiondetails 1.SELECT * FROM OPENROWSET('MSDASQL','Driver={MySQL ODBC 5.3 ANSI Driver};server=xxxxxxx;userid=xxxxx;pwd=;database=xxxxxx;port=xxxxx;','SELECT col1 from table1') 2.SELECT...

Database Modeling - Relationships

By ukashishgarg

Comments posted to this topic are about the item Database Modeling - Relationships

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers