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,467 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,351 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)
38,790 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
18,207 reads
Blogs
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...
Forums
Filtering the Dataframe in Python
Comments posted to this topic are about the item Filtering the Dataframe in Python
Desktop or Laptop for Remote Work
Comments posted to this topic are about the item Desktop or Laptop for Remote...
Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics
Comments posted to this topic are about the item Stairway to DAX and Power...
Ask SSC