Interview with Warwick Rudd

  Part of traveling to various events and being a part of the SQL Community means one can meet some pretty awesome professionals. I was fortunate enough to run into Warwick Rudd (B|T) at one of the PASS Summit events held in Seattle, and he definitely lives up to all the hype. Warwick is a …

Continue reading Interview with Warwick Rudd

Why is Count(*) Taking So Long

Phone rings……..I answer…….a DBA from a third party vendor has supplied someone with two scripts. The first script is a simple insert with a where clause: insert into [databasename].[dbo].[tablename] ( column1,column2, column3, column4 ) select column1, column2, column3, column4 from [databasename].[dbo].[tablename] where column1<[integeramount] and column1>[integeramount] First question I ask; how much data is loading into …

Continue reading Why is Count(*) Taking So Long

Microsoft SQL Server 2012 SP1 Release

I'm a little behind in getting this information out; I wish I could say it was because I was in Seattle last week for the PASS Summit 2012; however that was not the case. In any sense Microsoft has released Service Pack 1 for SQL Server 2012. The last list of fixes I saw for what …

Continue reading Microsoft SQL Server 2012 SP1 Release

SQL Server 2012 Best Practices – The Book

 People who I have spoken with over a period of time know that I have dubbed this as "The Book". There are several reasons why I am stoked to get my hands on a copy of this book (should be in transit to me as I type!), but one of the main reasons is I …

Continue reading SQL Server 2012 Best Practices – The Book