Viewing 15 posts - 41,671 through 41,685 (of 49,562 total)
Jeff Moden (1/16/2009)
GilaMonster (1/16/2009)
If the comparison with the outer query is an equality, the subquery won't be processed row by row.I pretty sure it will with an ORDER BY...
Order by...
January 16, 2009 at 8:50 am
As the error says, there's no name for the first column. A view needs all columns named.
ALTER VIEW [dbo].[vwPurchase]
AS
Select
min(pur.InPurchaseId) AS MinPurchaseID,
...
January 16, 2009 at 8:50 am
RSingh (1/16/2009)
Can anyone advise, how long it will take to reindex tables in such a large database?
How long is a piece of string?
It depends on the size of the tables...
January 16, 2009 at 7:43 am
leonp (1/16/2009)
second .. while i admit to being a little lazy, I do not have access to the database itself that this 'representative query' is to process
Got a local...
January 16, 2009 at 7:40 am
Jeff Moden (1/16/2009)
I'm trying to be as nice as pie... I don't understand why people post code and ask which will be faster... that's pretty lazy...
Cause it's easier than...
January 16, 2009 at 7:34 am
They're not processed separately, that's the point. SQL can and does 'de-correlate' the subquery and create an exec plan that processes the inner and outer query together.
Take this example I...
January 16, 2009 at 7:17 am
Ramesh (1/16/2009)
January 16, 2009 at 6:48 am
CrazyMan (1/16/2009)
When i tried to apply the CU that MS mentioned, it said that an advanced version is been installed on the machine 🙂
It's one of the service broker...
January 16, 2009 at 6:46 am
Ramesh (1/16/2009)
Thanks again Gail, but I was thinking about the shrinking the logs. Does it break the log chain of the database?
No. Shrinking logs does not break the log...
January 16, 2009 at 6:45 am
Ramesh (1/16/2009)
January 16, 2009 at 6:18 am
Ramesh (1/16/2009)
You are using correlated sub-queries, which is another form of RBAR...,
The optimiser can handle most correlated subqueries just fine. If the comparison with the outer query is an...
January 16, 2009 at 6:17 am
Ah, those.
You still didn't answer my question. What's the name of the table that you think is causing the error?
Have you considered apply Cumulative update 2 (or higher) as, according...
January 16, 2009 at 6:12 am
cotzan (1/16/2009)
these datas a pieace of my view. see 8,9 coloums. they have same datas. but i cant distinct
8Adomat Matbaa Baski Ltd Sti.Emre Güzeldal11.05.20071
9Adomat Matbaa...
January 16, 2009 at 5:35 am
Try running checkDB with the tablock option. It won't try to create a snapshot.
Can you try and view job information and then, while it's waiting, check sys.dm_exec_requests and see if...
January 16, 2009 at 5:31 am
What version of SQL are you on? (SELECT @@version)
What do you mean by 'internal table'? What's the name of the table that you think is responsible?
January 16, 2009 at 5:25 am
Viewing 15 posts - 41,671 through 41,685 (of 49,562 total)