Viewing 15 posts - 18,421 through 18,435 (of 22,202 total)
If you can, post the structure and the execution plan. Just because the DTA didn't find a good index doesn't mean one shouldn't be created. That tool is spotty at...
February 10, 2009 at 9:34 am
Can you post the actual execution plan?
I'd be surprised if you're getting good index usage since you're running several functions against the columns in the WHERE clause, including ISNULL...
February 10, 2009 at 9:30 am
GilaMonster (2/10/2009)
Grant Fritchey (2/10/2009)
Wait, no I didn't. More coffee, that's the answer.
More coffee is an acceptable answer to many problems. I didn't read your post in detail, so I don't...
February 10, 2009 at 8:45 am
tknight (2/10/2009)
February 10, 2009 at 8:41 am
Grant Fritchey (2/10/2009)
GilaMonster (2/10/2009)
tran008 (2/10/2009)
so if I put the order by in the view...both select statement in general perform the same?
If you put just an order by one a...
February 10, 2009 at 8:26 am
GilaMonster (2/10/2009)
tran008 (2/10/2009)
so if I put the order by in the view...both select statement in general perform the same?
If you put just an order by one a select in...
February 10, 2009 at 8:25 am
Without knowing precisely what's in the view, I couldn't say. But let's take this:
--view definition
CREATE VIEW dbo.View1
AS
SELECT t1.col1
,t1.col2
,t1.col3
FROM dbo.table1 t1;
GO
--select from...
February 10, 2009 at 7:55 am
It's going to be very difficult to answer the questions with any degree of authority without seeing the structures, sample data & queries run against it.
Shailesh Gajare (2/9/2009)
Doubts?
...
February 10, 2009 at 7:43 am
It depends on how much control you have over the inserts. If all calls to your tables are through stored procedures, just add a second insert to the procedure so...
February 10, 2009 at 7:33 am
The two aren't equal. You would need to include the ORDER by in the select from the view.
A view is just a select statement. Nothing magic.
February 10, 2009 at 7:31 am
This won't help you now, but another option available is to collect, and aggregate over time, the procedure calls by running a very lean server-side trace to capture queries run...
February 10, 2009 at 7:27 am
Jeff Moden (2/6/2009)
Grant Fritchey (2/6/2009)
tosscrosby (2/6/2009)
Not the BEST bounty hunter in the galaxy - was it a mutual agreement sort of thing? (now we're really getting wierd)Union.
Heh... ok... now I'm...
February 8, 2009 at 4:13 am
tosscrosby (2/6/2009)
Not the BEST bounty hunter in the galaxy - was it a mutual agreement sort of thing? (now we're really getting wierd)
Union.
February 6, 2009 at 12:58 pm
I've given up Boba Fett, so he's available.... which sounds weird.
February 6, 2009 at 12:30 pm
Viewing 15 posts - 18,421 through 18,435 (of 22,202 total)