Category: SQL

Programming, SharePoint, Software, SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Tips, Transact-SQL, tSQL

SharePoint Dealing with the Huge and Growing File Size of SharePoint_Config_Log.ldf

Justin Cooney
SP_Custom_Menu
SP_Custom_Menu

It’s amazing how some SharePoint issues are known problems that don’t get fixed by Microsoft even after many years, and that don’t get mentioned as things one needs to look out for. I found this out recently when I ran up against an error where the entire disk space of my SharePoint SQL Server instance was filled up by a file called SharePoint_Config_Log.ldf . This is ever growing file is apparently a known problem with SharePoint that has existed in many earlier versions and that remains difficult to find a solution for that actually fixes the problem. Continue reading “SharePoint Dealing with the Huge and Growing File Size of SharePoint_Config_Log.ldf” →

Advertisement
Programming, SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Tips, System Objects, Transact-SQL, tSQL

TSQL Query to List Tables in a Database with Row Counts

Justin Cooney
Row Counts
Row Counts

In a previous post I talked about how to find highly populated tables in a database. I’m going to expand on that in this post to show how to catalog a database into data-holding tables and supporting details tables. Continue reading “TSQL Query to List Tables in a Database with Row Counts” →

Database, Programming, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Tips, Transact-SQL, tSQL

TSQL Search for the Last Record in a Group

Justin Cooney

In this article I’ll show how to get the most recent record for a group of records in a SQL Server table. There are a number of ways to do this including CTEs and nested subqueries. Since nested subqueries are the most widely supported across the different versions of SQL Server, I consider them the most robust/straightforward way to get the job done, so in this article I will show you how to solve this problem using a nested subquery in either your WHERE or your FROM clause.

At the end of this article I’ll give the full working example Pet shop table and query that you can copy and paste into a SQL Server Management Studio (SSMS) session to try out the code for yourself.

If you find this article useful, be sure to check out my other SQL Server related articles for more tips.

Continue reading “TSQL Search for the Last Record in a Group” →