Skip to main content

Inside DBCC CHECKDB… How does it work?

Paul Randal has been writing an excellent series on how DBCC CHECKDB works within SQL Server. Explaining how SQL Server 2000 and 2005 present a consistent view of the data for checking and why that is important. Paul moves onto what CHECKDB really does and then [story:sqlserver2005-dbcc-for-vldb]. Paul Randal worked as the Lead Developer / […]

Find a SQL Server 2005 MVP

Need an MVP? Or just want to verify someone’s status? Microsoft’s MVP Awardees search can help you out. Here’s the current list of SQL Server MVPs in Australia and the worldwide list. Not all MVPs are on there, quite a few choose to hide from the limelight. Not on there yet? (Me either). Become visible […]

Free SQL Scripts for Managing and Monitoring SQL Server 2005

I came across these scripts on the Microsoft TechNet Script Centre Microsoft SQL Server 2005 Buffer Cache Retrieve Buffer Counts by Object and Index CPU and Optimization Determine CPU Resources Required for Optimization Retrieve Parallel Statements With the Highest Worker Time Retrieve Statements with the Highest Plan Re-Use Counts Retrieve Statements with the Lowest Plan […]

Optimising SQL Server 2005 TempDB

Microsoft’s whitepaper on Optimising TempDB in SQL Server 2005 contains a lot of useful information for anyone trying to push the performance of SQL Server 2005. Along with the internal improvements to tempdb, there are a number of things a database administrator should do as part of any installation: Increase the number of data files […]

Error: SQL Server Replication Requires The Actual Server Name

If while trying to setup a new subscription for SQL Server 2005 Replication using Management Studio you receive this error: TITLE: New Subscription Wizard —————————— Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic […]

How to fix @@SERVERNAME in SQL Server 2005

It seems to happen from time to time: your network engineers decide on a new network topology or naming scheme and they want to rename one or more of your SQL Server machines or worse your desktop machine! Renaming a SQL Server instance is not as simple as renaming the computer in My Computer Properties. […]

Google searches for SQL Server 2005

While tracing through my search history today, I came across the Google Trends tool. Its interesting to see the comparison of searches for SQL Server 2000 verses SQL Server 2005. It will be interesting to see if in the coming months just how many more searches will be for 2005 as there are more installations […]