Yes I also have fully documented the server, sql, and the database. I have created the execution plans on the major SP and although they all use...
There is an issue with 64 bit execution plans or something. Saw it this week as a matter of fact. Think it is addressed in update no 8 for service...
Yes Table partitioning is available only in the Enterprise version. There are lots of articles on partitioning tables and indexes. For thestandard...
How about partitioning the table by one of the common fields. that will reduce the number of records in each table and allow SQL to query a reduced...
I recently took a position for a web based application company. The app db is SQL 2005 on a quad processor 64 bit 3GHZ system with 8 GB RAM using...
I recently took a new position as the DBA for a web app company. Getting to understand the performance issues that are a major concern for the...
Separate names with a comma.
