Viewing 15 posts - 20,176 through 20,190 (of 22,202 total)
Piling on.
I've seen that standard before. I don't care for it, but as long as it's applied consistently, it's readable and it won't hurt anything.
June 10, 2008 at 12:15 pm
Usually just the opposite. Not updating stats for ages on end leads to slower & slower running procs and then the stats get updated and everything speeds up.
It could be...
June 10, 2008 at 12:12 pm
Yay!
Damn, I really wish I could have gone to Tech-Ed.
June 10, 2008 at 9:44 am
Is there a question in there that I'm missing?
June 10, 2008 at 6:26 am
Michael's works. Another way to the same window is to drill down on the table in question so that you see the "Constraints" folder. Right click and select "New Constraint..."
June 9, 2008 at 11:29 am
The first time I created the rule, it took a while for it to actually gather the data. I'm assuming that was time spent sending everything out to all the...
June 9, 2008 at 7:54 am
I'm not sure why you'd want to manage by FileGroup, but... What if you set up the same process that I outlined, but used this query to gather the data....
June 9, 2008 at 7:07 am
I'd say the CASE statement (sans variables) or the UDF are your best bets. You'll need to test them both to know for sure which works better with your structures.
June 9, 2008 at 6:32 am
I have to say, that's not a shape for an execution plan that I've seen before. Like the others have said, concentrate on the scans. You're missing JOIN predicates which...
June 9, 2008 at 6:22 am
File groups, I'm working on. Several people have asked the same question. I'll post something as soon as I have a complete story.
Custom reporting, since these properties are collected just...
June 9, 2008 at 5:45 am
As GSquared pointed out above, table variables work in a similar fashion. Statistics aren't maintained on them (except when there is a primary key) so the optimizer always assigns them...
June 9, 2008 at 5:22 am
Of course the next thing you should worry about is stacking all the fixed length, non-nullable fields at the front of the page... There's a lot of things you can...
June 6, 2008 at 1:19 pm
ganatra.neha (6/6/2008)
That was bulls eye. You were rightThank you
I shall try and rewrite the queries and avoid the the multi-statement UDF
Thank you once again
Glad I could...
June 6, 2008 at 12:51 pm
I don't see the attachment.
I'll bet you're working with a table valued function, probably a multi-statement function instead of an inline. Right?
If so, the optimizer doesn't and can't know what...
June 6, 2008 at 11:38 am
Viewing 15 posts - 20,176 through 20,190 (of 22,202 total)