Yep, you've got the answer right there.

SQL Server parse and compile time:

CPU time = 156 ms, elapsed time = 381 ms.

That parse & compile time is pretty long. It's...

Right. That IO is exactly what we should expect to see. Now we need to see the execution times... Actually, especially the compile time for the query.

Are you running...

OK. I'm stupid.

Of course it gets different execution plans. What I said before about the view, that it runs as is, that's flat out wrong. Instead SQL Server unpacks...

I just did some tests on my own. I'm getting the same results you are. I never really tried this before, breaking a view down in this way. I'm seeing...

For the basics on identifying what's happening on a server, I'd recommend this white paper from Microsoft. It's a great read.

You will receive notification. I'm not sure if you can see that it was accepted on your profile or not. If I remember correctly from last year (and since remembering...

The data would be something like

Name, Type

Joe Plumber

Tim Project Manager

Tom Developer

Etc.

Instead of what you're trying which is:

PlumberName, Project Manager...

Sorry about that. The forum drove the answer. Steve's right. Profiler is your best, really your only, option.

OK. Well you have two choices. Stop reloading it every week and use some unique identifiers for the transfer process, or build the unique identifiers off of natural keys. I...

If you're trying to determine if there are slow running queries, you'd be better off running queries against sys.dm_exec_query_stats. That will show you aggregate information about queries that are currently...

Oh yeah. A few details may change, but the basic approach & scope is the same for 2008.

Try this one

http://www.red-gate.com/specials/Grant.htm

I'm not sure it's still valid. Maybe the real book & Kindle are all that's available now.

It sure sounds like blocking, but since you say it's not, I'd step back a bit, not look at that procedure directly and instead examine the waits and queues on...

GilaMonster (4/21/2009)

mithun.gite (4/21/2009)

GilaMonster (4/21/2009)

I can suggest some books.

Inside SQL Server 2005: Query...

I would have to see the code to fully understand the issue. However, no, there's no way to selectively limit the query defined within a view. The query is going...