Viewing 15 posts - 41,671 through 41,685 (of 49,571 total)
RAID 6?! I missed that.
That, by itself, is going to give you horrendous write times, especially for a tran log
January 16, 2009 at 11:36 am
TRACEY (1/16/2009)
Once i got the master working, the msdb, model i can do how?
See the link that Steve and I posted. It has sections for all of the system databases...
January 16, 2009 at 11:27 am
RSingh (1/16/2009)
So any thoughts about the time to dbreindex the?
It depends on the performance of the IO system, other activity in SQL, other activity on the server, etc. There's no...
January 16, 2009 at 9:28 am
krypto69 (1/16/2009)
I'm looking at Gails suggestion, but to be honest I don't think I have the skill to implement that correctly (that's embarrassing)
What suggestion? The query bits I posted were...
January 16, 2009 at 9:27 am
A quick google search brings up the following page:
http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx
January 16, 2009 at 9:22 am
That's probably it. Are there other data files from the same db on that disk?
The 'internal' snapshot that checkDB uses is created on the same drives as the data files....
January 16, 2009 at 9:20 am
You don't need the distinct in that, because of the group by.
January 16, 2009 at 9:13 am
Ah, that one.
SELECT productId, productnumber,
(SELECT top 1 LineTotal FROM Sales.SalesOrderDetail sd WHERE sd.productID = p.productid order by sd.ModifiedDate)
FROM Production.Product p
WHERE ProductNumber like...
January 16, 2009 at 9:06 am
dmc (1/16/2009)
January 16, 2009 at 8:57 am
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
Viewing 15 posts - 41,671 through 41,685 (of 49,571 total)