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.


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)


3,607 reads


SQL Clone Works with FILESTREAM


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

Fun and profit with UTF-8


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

Data Platform MVP 2020


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers