If you have widely disparate spread of data you will often wind up with a bad execution plan in cache. Say you have a million rows and all but...

"idle cpu" job wouldn't work here because it is a long running query. No matter what you defined 'idle' as the query would run long enough to encroach on...

In 2005 Microsoft took a LOT of the Oracle playbook to heart (that it already hadn't done or done better on), especially from a manageability standpoint (think DMVs).  They are...

Are your auto-parameterizations failing??  There are some perf-mon counters you can check to validate this.  In my experience and training, forced parameterization is useful only in limited scenarios and can...

In sql server 2005 you have only ONE option for resource control over a query's execution:  the degree of parallelization.  If you have a multi-cpu box this may be sufficient...

I heartily concur with the Solid Quality comment. 

You can also search the web for Microsoft learning providers near you.  You want to attend classes 2784 and 2790, which combined...

1) You only need to create an index once. 

2) You can do this via a query (create index..) or using the GUI (i.e. sql server management studio)

3) All subsequent...

It should be easy to find the answer about whether a rebuild is required in the documentation for the controller. 

For heavy OLTP systems a 100 write/0 read configuration can...

I have not, although I HAVE used force parameterization on other non-system databases.  Given the typical activities that go on in tempdb it is difficult to construct a scenario where...

It is my understanding that other than the additional security verifications (which aren't too onerous) there would be no difference in the query performance.  The optimizer will still be able...

You left out a very important piece of information here: the average number of rows per idaccount. If it is large then sql server may not use a...

Hmm, it would seem that all of the string-based builtin functions called by the user defined function you have are deterministic. You can verify against the list in BOL....

igor, the answer to your question is "it depends". How much money do you have to spend on the project? What is your allowable downtime? Do you...

This does indeed seem to be a case where a CLR function could be appropriate. There aren't many such situations, IMHO.

I have seen numerous circumstances where sql server will request and be given too much memory, causing horrible performance on the server due to excessive paging. Setting an appropriate...