SQL Server: Migrating from 2000 EE X86 to 2008 R2 SE X64
Today we had a production migration and brought over one of our legacy applications from a data center located up[…]
Read moreCategory: SQL Server
SQL Server: Can I upgrade to 2008 R2 from 2008, 2005 or 2000? #TSQL2sDay
It is known that you can go up 2 major releases. Let’s consider 2008 R2 as a “half release” as[…]
Read moreParticipate in #TSQL2sDay
Sankar Reddy has blogged about what will be discussed as next topic: Misconceptions in SQL Server. What is SQL Tuesday?[…]
Read moreSQL Trace causing error “The client was unable to reuse a session with SPID XXX”
We will open traces whenever a slow performing process needs to be pinpointed. We never experienced a high overhead until[…]
Read moreDatabase Object Comparison Software OpenDBDiff running on X64 Windows
In the past we used the very reliable RedGate software to compare database schemas and create scripts for production push.[…]
Read moreMicrosoft Says there is nothing wrong with SQL Server 2008 R2
Over 3 weeks ago we solved the issue we were having with one particular cluster node running SQL Server 2008[…]
Read moreQuery Performance Issue in SQL Server 2008 R2
We migrated from SQL Server 2005 X86 to SQL Server 2008 R2 X64 a couple of weeks ago. The new[…]
Read morePlaying with Page Level Compression and Indexes
Row and Page Compression are features added to SQL Server 2008 and there are plenty of articles/blogs that discuss about[…]
Read moreSQL Server 2008 R2 and Nehalem Processors
I want to share a note about our latest experiences with SQL Server 2008 R2 EE X64 and Nehalem Processors.[…]
Read more