That is a 2008 exam, which have expired...

Awesome questions, thanks.

Seems obvious...

Why is there SSMS running on the production server?

Oblivion (4/9/2014)

---

Koen Verbeeck (4/9/2014)

---

Another side effect from SSMS is that it has to display all the rows in the result set. It might do it not so efficiently as SSRS.

(just...

You cannot just have less columns on a row then on another row.

Formatting output is better done with a front-end application, like SSRS.

Another side effect from SSMS is that it has to display all the rows in the result set. It might do it not so efficiently as SSRS.

(just a wild guess...

Sorry for the late reply, I have been busy.

Here is how I would solve it using TSQL:

-- create temp table

CREATE TABLE #viewReportMonitorCounterLog

([Machine] VARCHAR(10) NOT NULL

,[Counter Instance] VARCHAR(10) NOT NULL

,[Counter Object]...

Interesting question.

Always nice to see how Microsoft differs from other vendors (or how other vendors differ from Microsoft :-D) when it comes to terminating a simple line.

Always nice when you...

rocky_498 (4/4/2014)

---

Hi Guys,

Need Help,I want to know what is the best way to deal this kinda Problem or approach.

I am creating almost 30 SSIS Packages, some of them...

You could make create a link to the SSRS webserive wherein you supply the parameters and ask for the report in Excel format.

I was rereading your original question, and I need some more info.

You said first you would like to have a count of how many machines have a value over 80%....

If you want to calculate aggregates in your query, you need to use a GROUP BY clause.

Nice question, thanks.

I'm not sure what you mean?

When you open up the package using VS 2012, you can see the different tasks. Some of them can contain SQL code.