SQL Server: Truncating Dates
TRUNC is a function I used a lot when I worked with Oracle and helped me slicing my data in[…]
Read moreCategory: Database
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 moreSQL 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 more