Viewing 15 posts - 19,666 through 19,680 (of 22,213 total)
I agree. It makes sense to offer the columns rather than trying to guess if you're excluding them.
I've found intellisense to work pretty well so far. I'm still more in...
September 2, 2008 at 6:37 am
Late to the game...
Great comments Steve. I agree 100%. I remember a dot com emergency where I spent almost three days with little sleep and I was messing up at...
September 2, 2008 at 5:43 am
I would to research it to verify for sure, but I think you can simply point a monitor at a rule and respond to the data collected there. No extra...
August 31, 2008 at 7:49 am
Then what's on page 2?
Regardless, Page 2 needs some help.
I'd still like to see the code.
August 22, 2008 at 12:00 pm
The painful plan is very large and difficult to read. The one thing that stands out is that it looks like you're performing the same joins over and over again...
August 22, 2008 at 11:14 am
You might also try taking the NOT EXISTS sub-query and making it into a LEFT JOIN and looking for a NULL return. You'd need to test it, but in the...
August 22, 2008 at 7:09 am
Pages is literally the number of pages that make up the index. Smaller numbers just mean fewer pages. If your index is seriously fragmented, that number may be a lot...
August 22, 2008 at 6:44 am
You're comparing apples to oranges. Spotlight is for spot checking performance and Idera's tool is for collecting data long term AND spot checking performance. If you really want to compare...
August 22, 2008 at 6:38 am
Can you post the execution plan?
August 22, 2008 at 6:34 am
And you can turn on line numbers so that they're displayed by going to "Tools," "Options," "Text Editor," "TSQL" and under the Display choice selecting "Line Numbers."
August 22, 2008 at 6:33 am
is it a multi-statement table valued function? They don't have statistics so they resolve as 1 row queries. If you're returning more than one row, then the execution plan is...
August 22, 2008 at 6:27 am
We were going to be dealing with exactly this issue. The plan was for there to be planned integration dates when all the development teams would check in their code...
August 22, 2008 at 5:40 am
Viewing 15 posts - 19,666 through 19,680 (of 22,213 total)