I played around with the server side traces a bit and think that will do what I need. One strange thing is that the events do not get saved into the...
How do I log all access to a specific table with confidential information? The security on the table is relatively tight but I want to know who hits...
All the databases are on the same machine. I'm sure it has to do with the execution plan, but any insight into why it chooses the "slow" plan? I...
Step 2 runs fine (less than 1 second) on each database. I found a very ugly work around that addresses the speed issue, but I do not understand why...
A wrote a stored procedure that performs two task and executes in under 1 second, great. I need to expand this stored procedure to hit any of 5...
I just wanted to follow up and let you all know that I scheduled downtime last night and on the two live problem databases I dropped the problem...
By the way, I ran the DBCC CHECKDB on one of the problem db and it found nothing wrong... CHECKDB found 0 allocation errors and 0 consistency errors...
I compared the scripts and found a few things but nothing that seemed obvious so I decided to use the "bad" database script to build a new database...
I generated SQL from the 2nd largest DB (one that works as expected in all scenarios) and used that to build two test databases. I then inserted the...
Twan, How many rows are there in the big table for: - project = 'C598' **** ZERO, no US records ***** - week_ending between '1-1-2000' and...
Joe, I tried your suggestion and found the following: 1) If I only hit the US db (largest) then it uses the index seek and works instantly as...
Okay, the secondary indexes are now being used as expected. However, as Joe pointed out through analysis of the showplan, there is a large...
Joe, please disregard my last post, I recieved your email.
I figured out how to change the clustered index and did so before I saw your post. The good news is the execution plan does seem to pick the proper...
I am willing to change the clustered index if it will help. Currently, the primary key is on the identity column (server_time_id) and is...
Correction to my above post: Once I add in the smaller database to the view, it no longer uses the "correct" secondary index, instead it reverts to...
Twan,<br /><br />I did as you said and it uses the index and works instantly. I then added in one of the small databases that normally uses the...
I noticed the statistics for the db that does not work looked strange, I rebuilt the index in question, here are the updated stats for the DB that...
Q: are the tables in these database larger than the others A: It is the largest and 3rd largest table, but the 2nd largest works correctly (stats...
This is for the DB that doesn't work: Statistics for INDEX 'SI_PROJECTS_WEEK_ENDING'. Updated Rows Rows Sampled Steps Density...
Separate names with a comma.
