I wrote about issues I ran into setting up SQL Server 2005 cluster on Windows 2008 before; other then install issues I didn’t really have
Category: SQL 2005
Issues with abusing Table Variables
I been thinking about writing about performance tuning issues I been dealing with. Every DBA has their own stories that they have ran into. In
Blocked Process Report in SQL Profiler
One of my servers been giving me grief as of late because the vendor has created process into their application that dumps the full content
VARCHAR or CHAR?
Question: Which column type to use? Answer: It depends …. Explanation: SQL Server stores fixed width and variable length columns different. When storing a VARCHAR,
Microsoft SQL Server 2005 Upgrade Advisor: Unkown Error
I been trying to get the Upgrade Advisor working on Windows 2003 R2 SP2. But every time it keeps erroring out when it is about
Mirroring Scripts
When I setup mirroring between servers on SQL Server 2005 I use following scripts: SQL2K5MirroringScript-MirrorServer.sql SQL2K5MirroringScript-PrincipleServer.sql SQL2K5MirroringScript-WitnessServer.sql These scripts rely are designed and rely on
SQL Canada (SQLCAN) 