SQL Server – Page 3 – LincolnBlog.net

You can view the status of a KILL command used to stop an open transaction by typing the following:

KILL [SPID] WITH STATUSONLY

1	KILL [SPID] WITH STATUSONLY

Views – 2035

Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL…

A good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 2166

I recently was engaged in updating the Compatibility Mode of our production databases to 110 (2012) in preparation for upgrading them all to…

I have had a number of situations where log-shipping broke and I needed to rebuild it but could not drop the log-shipping configuration…

I saw this in the SQL logs today. It looks like some corruption happened in the transaction log of a specific database. I…

I had a SQL Server at work today where I found the msdb database in “Recovery Pending” state. After reading a number of…

Often you will need to add or move the tempDB data files, either to match the core count (up to 8 as best…

A common task for any DBA building new SQL servers is to relocate where SQL Server stores user and system databases. This post…

I recently had to run a query for one of our developers where the script was inserting a number of rows. All went…

LincolnBlog.net