I’m sure everyone would tweak this a little to suit their needs. I like to see the flow of my position and stay on track; It is easy to get stuck in the details and not step back to reassess…
SQL Server 2008 Reporting Services Matrix Column Group Causes Extra Page
Problem: I recently created a SSRS report with a column group in a Matrix pivot table. I noticed it created an extra page in print preview and on pdf export. Solution: Right Click on blank area below report and click…
Windows Server 2008 64 bit OS and 32 bit ODBC drivers
IIS 7 can use 32 bit ODBC drivers on a 64 bit server. The application pool for the site just has to be set to 32 bit. C:WindowsSysWow64odbcad32.exe is where the 32 bit ODBC settings are configured. Any application that…
Disable All SQL Server 2005/2008 Contraints to fix Database Corruption
I had to repair a SQL Server database from corruption. I needed to clear a good database of all data and reinsert the table data that I could from a corrupted backup. Once all of the data was inserted and…
SQL Server 2005/2008 Reindexing of All Databases
I recently found a better reindexing script. It reindexes and updates statistics only as needed. I was also able to use the scripts to schedule and remotely run scripts for instances of SQL Server that didn’t have the SQL Server…