Viewing 15 posts - 20,671 through 20,685 (of 21,968 total)
You can run the query and capture the actual execution plan. There's a button on the default tool bar, look for the tool tip that says "Include Actual Execution Plan"...
March 6, 2008 at 12:09 pm
Well, back in the day... 6.5, 7.0, that was true, to a degree. But it hasn't been true at all for years & years now. Here's an introduction to performance...
March 6, 2008 at 11:20 am
Yeah, sorry about that.
I sent an email to the group this morning. Did you get it?
March 6, 2008 at 10:47 am
Profiler and Perfmon are your bestest friends. There are also a number of dynamic management views available in 2005 that list missing indexes, etc.
March 6, 2008 at 10:41 am
That's called RBAR (reebar) processing and means Row-By-Agonizing-Row. It's definately not the way to go in most cases.
Instead, you need to focus on the results that you want as a...
March 6, 2008 at 10:28 am
ODAA caught by the coworkers, still not noticed by the boss or any one else in management.
March 6, 2008 at 9:18 am
Oh great, I'm not schizophrenic enough. Now I have to figure out the order in which to read posts.
:w00t::w00t::w00t::crazy::sick:
March 6, 2008 at 9:15 am
It's behaving pretty strangely over all. I'm seeing multiple alerts for discussions that don't appear to have any new posts at all.
March 6, 2008 at 9:09 am
First, NOT IN usually doesn't perform as well as an OUTER JOIN, so I'd change that right away. Second, you can check to see that values are a number by...
March 6, 2008 at 9:06 am
Only because he wanted to return the values and lock them down from other users. So I did the SELECT with the update lock first, then udpate the table to...
March 6, 2008 at 6:22 am
Also, on the SELECT...INTO vs. CREATE TABLE & SELECT question. That one depends too. It depends on whether or not you are going to create indexes or in any other...
March 6, 2008 at 6:11 am
Matt Miller (3/5/2008)
Jack Corbett (3/5/2008)
Matt Miller (3/5/2008)
It looked something like:
Matthew Miller
Senior Software Architect, O.D.A.A.
After I had been using it...
March 5, 2008 at 11:31 am
Viewing 15 posts - 20,671 through 20,685 (of 21,968 total)