Viewing 15 posts - 37,411 through 37,425 (of 49,552 total)
rsnow (7/27/2009)
Um, no offense, but Buddhists first of all don't use the term Buddhism;
What term do you use?
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
July 27, 2009 at 7:48 am
Untested.
SELECT rowid, lognumber, username, dateraised, logneotedate, log_notes
FROM
(SELECT ProblemNote.rowid, Problem.lognumber, username, dateraised, logneotedate, log_notes,
ROW_NUMBER OVER (Partition By Problem.lognumber ORDER BY ProblemNote.rowid DESC) AS RowNo
FROM Problem Inner Join ProblemNote...
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
July 27, 2009 at 7:14 am
When you check those rows, don't include the text/ntext/image column. If you do, you're more likely to get a severity 24 error than to get any data. Query the table...
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
July 27, 2009 at 6:56 am
Top or max according to which column?
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
July 27, 2009 at 6:42 am
Not really good news. You've still got corruption. Just wanted to be sure that it wasn't worst than what I could see. On SQL 2005, CheckDB includes the checks 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
July 27, 2009 at 6:36 am
allen davidson (7/27/2009)
I think my reply should have been along the lines of...clustered indexes affect placement on disk
Not necessarily true either. Think about fragmented indexes, fragmented file system, striping, etc....
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
July 27, 2009 at 5:44 am
More specifically, it's a parallelism skew. SQL has paralleled the query and parts of it finished faster than other parts.
There's a couple options here.
It could be that the skew has...
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
July 27, 2009 at 5:41 am
Yup, you've got corruption, specifically in the Text/NText/Image column in that table. That's not an index that you can just rebuild.
Do you have a clean (uncorrupt) backup of this database?...
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
July 27, 2009 at 5:29 am
Mani (7/26/2009)
Could you please clarify me that how often the Update statistics job has to run? weekly or daily?
Often enough that your stats don't get out of date to the...
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
July 27, 2009 at 1:59 am
Can you post the table design?
SQL doesn't keep track of the dates or order that data is inserted in. If you want to retrieve the latest row, there has to...
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
July 27, 2009 at 1:47 am
Do the update stats before the reindex. Update stats will update all statistics with a sample, index rebuild will also update the stats on the indexes with full scan. Hence,...
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
July 26, 2009 at 2:31 pm
Ok, so do I have this correct?
You have a source database, with data. You take a backup of this and restore it on the customer's site?
The customer's database has the...
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
July 26, 2009 at 2:21 pm
Laerte POltronieri Junior (7/26/2009)
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
July 26, 2009 at 2:08 pm
Laerte POltronieri Junior (7/26/2009)
But look that...when i restore de full database at the customer, the error goes to. (why ?)
All customers or one?
Is the source DB clean? Have you 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
July 26, 2009 at 1:41 pm
Only those whose windows logins have been granted access to the SQL instance can log in using windows authentication. Make sure no windows accounts have been added and that no...
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
July 26, 2009 at 5:14 am
Viewing 15 posts - 37,411 through 37,425 (of 49,552 total)