Monthly Archives: October 2010

Referential integrity improves performance

I have been told many times by people who dont’ know better (but think they do) that using referential integrity degrades performance as SQL needs to check the constraints when running the queries. I constantly argue the converse but thankfully … Continue reading

Posted in SQL Stuff | Tagged , | Leave a comment

Amazon Kindle – is it any good?

Is the Amazon Kindle any good. Should you buy one of the relatively cheap items or should you buy a Sony reader or an iPad or just use your computer? Continue reading

Posted in Hardware stuff, Other stuff, Uncategorized | 1 Comment

Sq server 2008 partition versus partitioned view performance comparison

Partitioned View versus 2005/2008 partitioning performance comparison. Which method is better? Is it worth upgrading. Enterprise only! Continue reading

Posted in SQL Stuff | Tagged | Leave a comment

Copying / archiving data

Copy large amounts of data in the background without locks Continue reading

Posted in SQL Stuff, Uncategorized | Tagged , | Leave a comment

SQL Server partitioning (2008)

How to find out the number of rows in each file group in a sql server partitioned database Continue reading

Posted in SQL Stuff, Uncategorized | Tagged , | Leave a comment

SQL Server compressed backups

Backup compression is now available in all versions of SQL Server 2008 and was only in enterprise in 2005 but is it any good? Continue reading

Posted in SQL Stuff, Uncategorized | Tagged , , , | Leave a comment

Who owns the DB?

Database owner has total rights on a database. Who owns your databases and do they work for you? Continue reading

Posted in SQL Stuff, Uncategorized | Tagged , , | Leave a comment