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 ) […]
SQL PASS 2013 Webcast Recording
The SQL PASS 2013 Webcast Recording which I did today is available for download and viewing. It’ll be viewable in Windows Media Player. You may need to download and install the GoTo Meeting Codec. This video is sponsored by Denny Cherry & Associates Consulting Thanks, Denny