Yearly Archive: 2009

Connect digest : 2009-12-31

Connect digest : 2009-12-31

Like Hugo's immensely popular item pushing for SQL Server 2005 Service Pack 3, Steve Jones has created suggestions prompting new service packs for both 2005 and 2008: #522122 : Service Pack 4 for SQL...

Mixing OLTP and reporting using indexed views

Mixing OLTP and reporting using indexed views

I'm not a big fan of denormalizing, nor of repeating redundant redundant information in a database when those facts can already be derived from other information.  A classic example of the latter is when...

Playing with page compression – for real

Playing with page compression – for real

During maintenance windows and against test databases, I have been applying page compression to some largish tables (~200+ million rows, ~50GB).  These tables are heavy write and medium read, but all writes are inserts...

Cumulative Updates for SQL Server 2005 are available

Cumulative Updates for SQL Server 2005 are available

Last week Microsoft snuck in some updates for the SQL Server 2005 product line.  Cumulative Update #7 for Service Pack 3 brings you to build # 9.00.4273, while Cumulative Update #17 for Service Pack...

On software bloat…

On software bloat…

This morning I decided to install Visual Studio 2010 on one of my development VMs.  I have several processes in our production environment where, for convenience, I have SQL Server Agent calling batch files...

Connect Digest : 2009-12-12

Connect Digest : 2009-12-12

Sorry I have been quiet recently; been working very hard for the past two weeks on a migration of an old, tried SQL Server 2005 database to a brand new 2008 cluster with faster...

Connect Digest : 2009-11-25

Connect Digest : 2009-11-25

Can we improve on CHECKSUM()? Mike C# is not happy with the reliability of CHECKSUM() and asks for a better function that has less (or no) chance of collisions. #513376 : A Better Collision-Free...

Connect Digest : 2009-11-20

Connect Digest : 2009-11-20

SSMS needs to support today's (and tomorrow's) number of cores Apparently when you try to get to the server properties page where CPUs are displayed, the UI is not equipped to handle 96 cores. ...

Installing Service Packs / Cumulative Updates on a SQL 2005 cluster

Installing Service Packs / Cumulative Updates on a SQL 2005 cluster

In our environment, we run the task scheduler as a cluster resource, so that scheduled tasks always run on the active node.  (In ancient history, we would have scheduled tasks that weren't cluster aware...

What is so bad about EAV, anyway?

What is so bad about EAV, anyway?

I see a lot of people trash-talking the EAV (entity-attribute-value) model.  If you want the full story on EAV, I recommend you read the Wikipedia entry.  Basically this is the situation where instead of...

New SQL Server 2008 Cumulative Updates are available

New SQL Server 2008 Cumulative Updates are available

For those of you watching over the past couple of weeks, you may have noticed an out-of-band, mid-CU-cycle update to SQL Server 2008 SP1.  The fix to a cluster issue was available only for...

For Analysis Services users, you should be aware of this fix

For Analysis Services users, you should be aware of this fix

If you are using SQL Server 2005 or 2008 Analysis Services, and have been keeping up to date with hotfixes cumulative updates, you may have been adversely affected by a previous round (and your...

Connect digest : 2009-11-13

Connect digest : 2009-11-13

Cart before the horse Last week, a fix for SQL Server 2008 SP1 CU #4 was quietly slipped into the CU4 download page.  CU4 was build 10.0.2734, but you could have easily grabbed 10.0.2740...

Some tips on SSMS Express Edition setup

Some tips on SSMS Express Edition setup

I posted earlier that the Express Edition of Management Studio for SQL Server 2008 R2 (November CTP) is now available for download. During the first few pages in the setup wizard, I was certain...

November CTP of SQL Server 2008 R2 : Download now

November CTP of SQL Server 2008 R2 : Download now

For those of you that have been wanting to try out SQL Server 2008 R2, you can download the November CTP of Express here (posted yesterday) and the full version of the November CTP...

Finding stored procedures containing %string%

Finding stored procedures containing %string%

Having just returned from PASS, I needed to play catch up on a few things in a stored procedure that was being developed before I left.  Being a little frazzled still, I could not...

Some updates to SQL Server 2008 SP1 CU4 you may not have noticed

Some updates to SQL Server 2008 SP1 CU4 you may not have noticed

Back on September 21/22, Microsoft released its most recent cumulative updates for SQL Server 2008.  For RTM, this was Cumulative Update #7 (10.00.1818), and for SP1, this was Cumulative Update #4 (10.00.2734). However, if...

Another PASS has come and gone

Another PASS has come and gone

Wow, what a week!  I am just settling in back home after a week away, most of which I spent at the PASS summit in Seattle.  Whether you were there or not, you might...

Connect Digest : 2009-11-06

Connect Digest : 2009-11-06

This week I've been at PASS, so haven't spent a whole lot of time digging into new Connect issues.  There was one raised today where the new += syntax in SQL Server 2008 can...

Blogging from the PASS Keynote : 2009-11-05

Blogging from the PASS Keynote : 2009-11-05

Bill Graziano took the stage and promised us the shortest keynote yet.  He started by giving thanks to outgoing board members Greg Low, Pat Wright and Kevin Kline.  Wayne Snyder took over and gave...