Articles

SQL Server Transaction Log Management eBook Download

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.

2019-06-26 (first published: )

104,952 reads

SQL Clone on your Laptop

Phil Factor provides a PowerShell script to disconnect your laptop without risking error 21, if you're working with SQL Clone and need to go offline. The same script will then bring the clone database back online smoothly, once you're reconnected.

2019-06-25

Blogs

SQL Server 2008 and 2008 R2 is end of life on 9 July 2019

By

Next month, Microsoft is ending five years of extended support on SQL Server 2008...

Understanding Columnstore Indexes in SQL Server Part 1

By

Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes...

Basic User Functions in R

By

As I’ve been learning more about the data platform, I’ve been exposed to some...

Read the latest Blogs

Forums

Compare Dates

By ssc_san

Hello All, create table #app1 ( custID INT, Seqs INT, eff_dt datetime, term_dt datetime...

StoredProc insert and update multiuser issue

By jason.havelock

Happy to day to all, I am looking into an issue with a stored...

New to SQL - difficulties in SUMing only certain rows of a column, other misc.

By Kai

This is for SQL Server 8.0 and I'm using MySQL Workbench on this.  ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers