Viewing 15 posts - 17,641 through 17,655 (of 22,214 total)
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...
April 21, 2009 at 3:50 pm
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...
April 21, 2009 at 12:49 pm
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...
April 21, 2009 at 12:46 pm
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...
April 21, 2009 at 12:20 pm
For the basics on identifying what's happening on a server, I'd recommend this white paper from Microsoft. It's a great read.
April 21, 2009 at 12:08 pm
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...
April 21, 2009 at 11:37 am
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...
April 21, 2009 at 11:34 am
Sorry about that. The forum drove the answer. Steve's right. Profiler is your best, really your only, option.
April 21, 2009 at 11:32 am
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...
April 21, 2009 at 9:25 am
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...
April 21, 2009 at 9:14 am
Oh yeah. A few details may change, but the basic approach & scope is the same for 2008.
April 21, 2009 at 9:00 am
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.
April 21, 2009 at 8:58 am
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...
April 21, 2009 at 8:48 am
GilaMonster (4/21/2009)
mithun.gite (4/21/2009)
GilaMonster (4/21/2009)
mithun.gite (4/21/2009)
Can any one give me a link for Query Optimization, using that i can start optimizing my queries?
I can suggest some books.
Inside SQL Server 2005: Query...
April 21, 2009 at 8:45 am
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...
April 21, 2009 at 8:41 am
Viewing 15 posts - 17,641 through 17,655 (of 22,214 total)