Viewing 15 posts - 17,626 through 17,640 (of 22,202 total)
I would give that resume the hairy eyeball, but I think I'd still consider them, but only if they looked so great as to be able to drop that sort...
April 22, 2009 at 4:12 am
That is a fantastic document isn't it?
April 21, 2009 at 4:04 pm
To get around most of Seattle you can walk or ride the bus. It's a very metropolitan area (think New York, London) and not all spread out like LA or...
April 21, 2009 at 4:02 pm
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
Viewing 15 posts - 17,626 through 17,640 (of 22,202 total)