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
ApexSQL Log Tools
Urg! One word to describe an interesting surprise I ran into today. On the Production server the tool created an extended stored procedure that started
Get listing of Databases user has access to …
You can right click on each user to find out what database he or she has access to; which can be very time consuming. I
Surface Area Configuration Manager *R.I.P.*
All who liked the SACM raise your hands … Right that’s what I thought no one heh; okay it wasn’t that bad. But non the
"New Maintenance Plan…" doesn’t work
For some reason Microsoft decided not to enable that function in some editions of RTM in SQL server 2008 (annoying but meh). So looking around
SQL Canada (SQLCAN) 