metrics?

Can anyone tell me how I can measure the metrics of
certain activities?
I need to see the difference in I/O between a query and
an index build.
TIA,
AdriaAdria,
possible ways:
1. you can use set statistics io on in query analyzer
2. you can use user profiler
3. you can use perfmon (or system monitor in win2k)
Quentin
"Adria" <a-carbo@.tamu.edu> wrote in message
news:b6ea01c4377b$32bf27f0$a001280a@.phx.gbl...
> Can anyone tell me how I can measure the metrics of
> certain activities?
> I need to see the difference in I/O between a query and
> an index build.
> TIA,
> Adria

Messed up with reporting services

Hi, I'm developing a Web application in which the user, after a certain operation, it will generate a report using reporting services. The doubt is:

How do I generate the report?Is there any report on the web app that I give parameters and then show it, or is there a report on the web server and I send him the parameters?These parameters come from a specific data set or can come from a arraylist ore something from the web app?

Which of the two perspectives is the best?I've looked im Microsoft but this aspect is not very explicit, I'm having serious doubts about how to do this, its kinda complicated one I'm brand new on SSRS!Thanks a lot!!

With reporting services you can access reports 2 ways (thatI know of)

URL access, using this method your eb app will build up a url for eg,http://reportServerName//reportserver/reportdirectory/reportname.rdl

to pass parameters, you can add &Parameter1Name=1&ParameterName2=2 etc

you can also build up your url to hide/show toolbars, select output formats, etc

Web service, basically the above but programatically

If you have them check out Reporting Services BOL looks of good info there

Merging two tables then grouping them

I have two tables, one is named Employee and the other Job_title. I'm trying to combine the two tables so I can group certain columns.

This is what I thought of so far and please correct me if I'm wrong.

SELECT Last_name FROM Employee
UNION
SELECT Job_title_code FROM Job_title
GROUP BY Exempt_non_exempt
FROM Job_title

Now this is just a theory (obviously it doesn't work) but basiclly I'm trying to have columns from two tables and have the grouped.Huh?

Wha?

There is no relationship between these tables?
No foreign keys?
You are selecting a single column and performing GROUP BY without any aggregate functions?

This makes no sense.|||Well, in both tables, they each have a job_title_code column.

Employee table
lastname, firstname, job title code

Job_title Table
job title code, job title, salary, exempt/non exempt|||Is this homework?

It looks like homework.
It sounds like homework.

Are we studying relational databases?|||So why aren't you using a join?

SELECT Last_name,
Job_title_code,
Exemp_non_exempt
FROM Employee
INNER JOIN Job_title on Employee.Job_title_code = Job_title.Job_title_code

I don't think this is homework. If it was homework his question would be more clearly phrased!|||sorry for the mix up, yes it is homework. that's for suggesting the INNER JOIN command. i found a variation of what you did and it worked out for my db. by the way, how did you put your code in a window like that?

SELECT Employee.Last_Name, Job_title.Exempt_non_exempt_status
FROM Employee
INNER JOIN Job_title
ON Employee.Job_title_code=Job_title.Job_title_code|||Enclose your code in CODE tagsL

[XCode]
Your code here
[X/Code]

Remove the X characters...

Your code here