Viewing 15 posts - 18,436 through 18,450 (of 22,214 total)
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
Completely no help to you, this is a great example of how the estimated costs and the actual costs have nothing to do with each other. Jeff would love it.
February 6, 2009 at 11:57 am
Looking at it some more, you're query is joining between tables with this:
JOIN dbo.Citizenships AS C
...
February 6, 2009 at 11:55 am
That's a strange one. The estimated & actual rows are WAY off. You might check the statistics. Let me keep looking.
February 6, 2009 at 11:47 am
Viewing 15 posts - 18,436 through 18,450 (of 22,214 total)