How to install SQL Server 2008 32Bit on Windows 2008 X64

How install SQL Server 2008 32Bit on Windows 2008 X64 In a specific case, you have to install SQL Server 2008 32Bit (X86) on Windows 2008 X64. It can be due to the provider of your end application who supports only on a SQL 32Bit his application. If you want to install SQL server 2008…


Determining SQL Server Table Size

Determining SQL Server Table Size There a few days, I had to identify areas of my database that were taking up the most physical storage space.The process that the stored procedure goes through is very simple. I create a temporary table to store the individual data elements for each table.The Script has been tested and…


SQL Server Management Studio spends over 10 seconds to load

Problem descriptionSQL Server Management Studio spends over 10 seconds to load.CauseIn general, this behavior is due to 2 things:1. The host computer not has access. By default “SQL Server Management Studio” is configured to use online help resources. 2. The host computer not has access. SSMS tries to go on internet to check for server…