Get record count for a specific database
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
2013-10-23 (first published: 2007-12-17)
19,840 reads
James Rea
Transaction Log Growth, do you need it?
One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it.
2010-05-28 (first published: 2009-01-05)
32,742 reads
Introduction to the Transaction Log
The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.
2009-11-06 (first published: 2008-07-02)
40,585 reads
Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
2008-07-28
23,914 reads
Blogs
70 Years of Artificial Intelligence History in 15 Minutes
By Brian Kelley
How long has AI been around in different domains? What was it called before...
What a Summer Camp Kitchen Still Teaches Me
By Rayis Imayev
(2025-Aug-04) Taking my last week of vacation and then volunteering at a children's summer camp...
AI Transformation and Security in Microsoft’s 2025 Announcements
By Chris Yates
Microsoft’s latest wave of announcements in July 2025 offers a compelling snapshot of how...
Forums
Direct Connection running Fast,Linked Server running Slow
Scenario 1 (Direct Connection - Fast): On Server B, when using SQL Server Management...
Direct Connection running Fast,Linked Server running Slow
Scenario 1 (Direct Connection - Fast): On Server B, when using SQL Server Management...
Yet another Date Dimension
Comments posted to this topic are about the item Yet another Date Dimension
Question of the Day
Always On Availability Groups and Capabilities
SQL Server Always On Availability Groups is the go-to HADR solution for the database platform. Which of the following statements about SQL Server Always On Availability Groups are TRUE?
See possible answers