Hi everyone,

Take a look at the attached file, which has the SQL script in known good formatted state. I'm guessing there may have been an issue with the code...

This is not a Redgate application, nor any SQL Server management software for that matter. This is an application that supports our businesses core operations.

thisisfutile (10/25/2011)

---

I've been coming to these forums long enough to know that Joe Celko was going to respond to this one. I recall Joe discussing the TOP clause in...

This script is for SQL Server 2008, which is when the resource governor was introduced.

For more information, here's an article on the resource governor[/url].

Thanks for the suggestion, I will definitely have to take a look at "LogParser" from Microsoft.

Tim P.

Please don't laugh at me, but in my current environment our Network Admin does not allow the DBA's to view Perfmon on our servers. I know in most cases...

Take a look at this article http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx

This provides some of what you're looking for, while at the same time minimizing overhead. Otherwise, to get the level of detail you...

See if this blog on "Handy Hardware Accessment Tools" will give you the answer you're looking for as far as tools are concerned.

http://sqlserverperformance.wordpress.com/2010/11/15/handy-hardware-assessment-tools-for-sql-server/[/url]

Or you can read this thread that...

I have gotten lucky and been able to retrieve queries from the Plan Cache in the past. Keep in mind these were Ad-Hoc statements that a particular user was...

Lav,

You may need to provide some more information on how you plan to use the subquery or derived table.

Based on what you provided, I would suggest moving the FOR XML...

I believe sp_helplogins is what you're looking for to get your answer.

BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/f9ad3767-5b9f-420d-8922-b637811404f7.htm

That hits the nail on the head. I agree with you 100%.

I personally feel that I get discriminated against because of my time in grade as a SQL Server...

Kettle drums are cool, they can be tuned to pitch.

I hate to use analogies here, but it's like auditioning a musician for a band. We can talk music theory all day, but if you can't play good music,...

Derrick,

That dashboard is actually better than Spotlight because you can see all instances at once. Good job!