Category: TSQL

Tip: RECOVERY_PENDING is not the same as RECOVERING

Post author By Jen McCown
Post date September 8, 2014
Categories In Admin, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, TSQL
4 Comments on Tip: RECOVERY_PENDING is not the same as RECOVERING

I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating. RECOVERY_PENDING is very different from RECOVERING. Definitions RECOVERING means that things are happening, and all may be well. “Database is being recovered. The recovering process is a transient state; the database will automatically become online if […]

Compare tables to find missing rows

Post author By Jen McCown
Post date November 14, 2013
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL
4 Comments on Compare tables to find missing rows

Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a list of orders to an imported set of data in a staging table. Or, we’re identifying customers in the database that aren’t on the call list. Whatever the application, finding out the difference between one […]

SQL Tip: Get Log Space with DBCC SQLPERF(LOGSPACE)

Post author By Jen McCown
Post date September 19, 2013
Categories In sql server, sqlserverpedia-syndication, SSC, Tech and Learning, Tips, TSQL
1 Comment on SQL Tip: Get Log Space with DBCC SQLPERF(LOGSPACE)

Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be a Microsoft SQL Server DBA 101” before our first gig. So for your perusal, use and enjoyment: here is the easiest way to get a report on log space usage: DBCC SQLPERF(LOGSPACE); Go ahead, type it […]