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

T-SQL Tuesday #040: File and Filegroup Wisdom

It’s that time again for the T-SQL Tuesday party! This party was created by none other than Adam Machanic (Twitter). If you are interested in hosting a party at some point this year give him a shout; you need to have participated in two T-SQL Tuesdays along the way and also maintain your own blog …

Continue reading T-SQL Tuesday #040: File and Filegroup Wisdom

Who Do I Follow? Where Do I Go?

There are many helpful sites within the SQL Community and several more blog sites that I follow. My favorites are noted on this site; however one that keeps drawing me back time and time again is by Brent Ozar's group. For those of you who have not had the opportunity to check the site out …

Continue reading Who Do I Follow? Where Do I Go?

The Microsoft SQL Server MVP

What is an MVP? For myself growing up in the realm of sports through high school and college an MVP is a most valuable player. In general an MVP is recognized in his area or field, an honor bestowed on him or her that distinguishes them as being recognized by their peers. What is a …

Continue reading The Microsoft SQL Server MVP