Monthly Archives: May 2012

Plan cache in SQL Server 2008R2

I was curious to look at the effect of database options, on the SQL server plan cache. I have restored the Adventure works sample database onto my SQL Server 2008 R2 RTM instance four times as AW1, AW2, AW3 and … Continue reading

Posted in Plan cache, SQL Server | 1 Comment

Quick tip: sp_configure and sys.configurations

In order to query the configuration settings of a server you can run this sproc: exec sp_configure On a default install of sql server this will return 16 rows. In order to see all rows you need to run this: … Continue reading

Posted in SQL Server, T-SQL | 4 Comments

Setting up transactional replication using T-SQL

Replication is one of the more complex of the SQL native “HA/DR” technologies. There are a lot of moving parts. Here are the steps to configure a basic transactional replication topology, with a publisher and distributor on the same instance … Continue reading

Posted in SQL Server, T-SQL | Tagged , , | 2 Comments

Working with bitwise data in SQL Server

I was working with a group of students on a design brief. The brief was to partially implement a database design based on the LinkedIn web site. A discussion came up around the possibility of implementing the contact preferences (essentially … Continue reading

Posted in Database Theory, T-SQL | Leave a comment