2
votes
1answer
266 views

SQL Server 2000 HIGH CPU Usage with BusinessObjects reports (unsolvable?)

I have one of those weird questions, those ones that are nearly unsolvable (the only way to really solve them is to throw out the technology and buy new ones). I've had a number of experts (about 10 ...
1
vote
2answers
42 views

Store TIME in SQL

What is the correct way to store the TIME of day in SQL? Have a field that cares only when an action took place. Example values will be 2:30 PM or 14:30, it doesn't matter to me which. This ...
0
votes
1answer
66 views

SQL 2008 Performance Reports

Does anybody know of DMV's or reports that will show the historical performance of the stored procedures on the server? Also if that data is stored in a table or tables, what is the retention period ...