|
||||||
|
Here’s this week’s weekly challenges…. New release went out last Friday, 4/18/08 – lots and lots of SQL servers Two SQL 2005 Clustered 64 bit I spent most of the week in in the “War” room with a consultant [...] Here’s this week’s challenges: - Installed and configured SQL 2005 Reporting Services on two Servers.- I kept getting an error when installing SQL 2005 on a different server. The source was a network drive that had the install on it. It would get to VSS writer and then bomb every time. [...] We had a report that was using sys.dm_db_index_physical_stats to find partition progress information. It was taking 45 minutes reguardless of the data in the results. We started looking at the data it was reading. The slow down was around two tables with LOB_Data in them. One table had about 14 million [...] This was another fun filled week with new SQL issues I hadn’t experienced in smaller environments. 1. I installed the wrong version of SQL on a server. It was a miscommunication between the network guy and myself as I read the OS column which was supposed to be Enterprise – I assumed it was [...] |
||||||
|
Copyright © 2012 Lohn Solutions - All Rights Reserved |
||||||
