Viewing 15 posts - 43,756 through 43,770 (of 49,552 total)
michael vessey (10/15/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 8:20 am
That's kinda what I thought it would return.
You have two options at this point
1) Restore a backup of the database or replace it with the copy.
2) Script out the schema,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 8:15 am
billross (10/15/2008)
UPDATE myTable
SET
[my field] = table2.[my field]
and it can't even do this:
UPDATE myTable
SET
[my field] = (select [my...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 8:13 am
So, the index should be (Y,M). Right?
Or (M, Y). It won't make a difference with this query, since it's an equality.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 8:04 am
That's why we ask for the table schema.
Assuming that the relationship between product_id and product_name is a 1-to-1, this should work
SELECT table.uniquekey, table.product_id, table.product_name, sub.last_purchase_date
FROM table INNER JOIN
(Select
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 8:01 am
I would suggest that you rename the corrupt DB, then restore the clean backup along side it. Run CheckDB to make sure there's no corruption. If it's clean, then see...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 2:42 am
Have you done a stats update on all tables after the move to 2005?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:56 am
What do you want to know about them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:54 am
Don't try directly updating/copying the sysindexes table. It;s a system table and if you mess with it you could end up with a worse problem than you currently have.
Please run...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:38 am
May Anne Duran (10/15/2008)
I've been deleting .ldf files whenever it's size is way too big and eterprises manager simply creates a new one. and the issue is not the log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:35 am
I've heard of that. I want to get it, just to see how they've done it. I know a lot of the MVPs are getting it for that reason.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:30 am
CXPacket is wait caused by a parallel skew. What happens is that SQL runs a query in parallel and, for whatever reason, one of more of the threads lags behind....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:24 am
Data cache? Procedure cache?
What do you want to know about it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:20 am
For what it's worth, I saw a massive reduction in blocking going from SQL 2000 to SQL 2005. It may not apply in your specific case.
You'll get other advantages moving...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:15 am
billross (10/14/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:12 am
Viewing 15 posts - 43,756 through 43,770 (of 49,552 total)