My SQLPass Schedule [Training]
My SQLPass Schedule
Read moreTag: sql server
Incorrect Bios Settings Can Reduce Database Performance [SQL Server]
It turned out that the issue was not Hyper Threading related, but a Bios misconfiguration instead.
Read moreSummarizing Performance issues and workarounds after migrating from 2005 to 2008 R2 [SQL Server]
We were able to tune the offending processes and go from 85% sustained CPU utilization to almost nil.
Read moreKerberos Double Hop and Delegation between different Active Directory Accounts [SQL Server]
In the past, when I had bare knowledge of Active Directory, I dealt with double hop queries using SQL Server[…]
Read moreSQL Server: Truncating Dates
TRUNC is a function I used a lot when I worked with Oracle and helped me slicing my data in[…]
Read moreSQL 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 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 more