Instant File Initialisation

I have been reading up on instant file initialization and I have read a couple of good blog posts by...

DDL Triggers

We had a request from a developer who wanted to access data from a source database and another database on...

SQL Server 2008 R2 - Release May2010

SQL Server 2008 R2 now has a release date...May 2010.

Check out the microsoft site for more details...link to follow

SQL Server Resource Governor

I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition
 

January Roundup

I have just put together the January newsletter for www.gre-sqlserver-solutions.com and scheduled it to run Sunday night/Monday morning. It is...

Lock configuration setting and preventing locking contention

The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...

Permon Counters Missing Windows 64 Bit SQL Server 32 Bit

For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit...

A Day Off

I'm having a day off tomorrow, got some nice things planned including a trip to the beach with the puppies....

Database Books

Well my theory on posting every week has been tested to the limit somewhat and I didn’t get anything written...

weekly update

Well I said that I would try to post regularly and seeing as its Sunday and I haven’t posted for...