Viewing 15 posts - 28,351 through 28,365 (of 49,552 total)
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1049894-391-1.aspx
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
January 19, 2011 at 5:53 am
Please read over the article I've referenced (twice). Please post table definitions (as create table statements), som sample data for us to work with and the expected results so we...
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
January 19, 2011 at 5:52 am
Be patient. We're all volunteers with our own jobs, our own problems and we're answering questions in our spare time. Bumping your post after just 4 hours (4 hours where...
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
January 19, 2011 at 5:35 am
The corruption you have is not repairable.
You have two options.
1) Restore from your last clean backup
2) Script all objects, export what data you can (some will almost certainly fail) and...
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
January 19, 2011 at 5:32 am
GilaMonster (1/19/2011)
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
January 19, 2011 at 5:29 am
Either delete in batches or use TRUNCATE TABLE instead of delete if you're wiping the entire table and it has no foreign key constraints referencing it.
Eg of batch delete:
DECLARE @Done...
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
January 19, 2011 at 5:10 am
Please don't post multiple threads for one problem.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1049894-391-1.aspx
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
January 19, 2011 at 5:07 am
Dave Ballantyne (1/19/2011)
Dont look to bad...
Depends. If the row estimation is off that key lookup is going to hurt.
I think that the output from statistics IO would also be useful
SET...
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
January 19, 2011 at 4:43 am
Please post the Actual execution plans, not the estimated execution plans.
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
January 19, 2011 at 4:39 am
Sjeef (1/19/2011)
or you use the statement as i provided WITH the option Recompile
Providing you're on specific builds of 2008. The recompile feature was available in RTM, pulled in a CU...
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
January 19, 2011 at 4:34 am
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
January 19, 2011 at 4:09 am
Sjeef (1/19/2011)
WHERE
(pg.ProductLineID = case when @ProductLine > 0 then @ProductLine else pg.ProductLineID end)
AND
...
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
January 19, 2011 at 3:53 am
There's no way to get estimated execution time from a query plan. Estimated cost != estimated query execution time
I'm not sure there's a way to directly capture this into a...
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
January 19, 2011 at 3:36 am
I'm going to see the whole lot. Though, from the part you posted, it doesn't look like it's repairable.
To get the entire output, open a command window (Start-> Run-> cmd.exe)...
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
January 19, 2011 at 3:24 am
Hugo Kornelis (1/19/2011)
Interesting, that the documentation (or at least the page referenced in this question) never once mentions filegroup restore.
http://msdn.microsoft.com/en-us/library/ms186858%28v=sql.90%29.aspx
About 1/3 of the way down:
SQL Server 2005 supports a variety...
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
January 19, 2011 at 3:06 am
Viewing 15 posts - 28,351 through 28,365 (of 49,552 total)