SPs only require the latest SP.

For the security updates between SPs, you will need to apply each of those (i.e. there are two separate security updates to apply for SP3...

Thanks Bob. Having been to PASS in the past, I already knew what I was missing. It really sucks to not be able to go this year -...

That kind of query should return much quicker. As the others said though, post more info and we can help more effiiciently.

Tuning the UDFs will gain you a little. I would look somewhere else in the UDF to try for performance improvement. Maybe an index has been missed or...

Shark Energy (11/5/2009)

---

More questions on this.....

Would a query that sometimes takes 10 minutes, then other times takes 45 minutes actually need tuning? Surely that is pure server performance? Or is...

Definitely find the calling sources for the Functions. I have seen numerous UDFs be outperformed by procs by a factor of 10. Once you find the calling sources,...

Agree with John on this one. You could setup an automated job to dump the info to a table for him and then grant him read permissions to that...

The Idera tool is good.

MS Stance

How to Do it[/url]

Answer seems inaccurate.

Many of those tools also just use queries, views, and information that is already available through sql server and perfmon.

To add to the consideration, the agents that get installed with...

Other things to remember when the RDP session is slow:

Check the user experience settings. Things like desktop background, themes, bitmap caching, etc cause slowness as well.

Also, it might be...

Check the scripts repository.

SSC Security Scripts[/url]

Into a single file or 1 file per stored proc?

Service accounts should only have enough privileges to do the function they were created to do.

Adding them to the Local Admins group is NOT the best practice as you have...

Is it going to be a tradition at PASS now (kilt wednesday)?