Replication and VLFs
Every once in a while you run across a problem that shouldn’t be causing people as much problems as it is, yet there it is causing all sorts of problems for long enough that being broken is considered normal. In the case of this one client that I’ve been working with that problem was massive […]
Come See Me At #sqlpass #summit13 Booth 129 and Enter To Win $1000 US
Come visit booth 129 and get your badge scanned for a chance to win a $1000 Amazon gift card. You read that correctly we at the Consultants Corner booth are giving away an Amazon gift card from amazon.com worth $1000 US! The winner will be announced the week after PASS (give or take, depending on […]
Moving the SCCM database
Recently I had to move the SCCM database for a client of mine. I used this walkthrough to go through the process. For the most part everything worked pretty well. There was one thing which was missing from this. The process requires that the SQL Server 2008 R2 SP1 Feature Pack (or the feature pack […]
Seeks Aren’t Always Better Than Scans
So I was doing a little performance tuning of a query for a company recently and we were getting hammered on the IO for the query. The query was in a stored procedure which wasn’t all that complex (ignore the crap code for now). ALTER PROCEDURE [dbo].[iu] ( @p uniqueidentifier, @as int, @t datetime ) […]