Viewing 15 posts - 37,426 through 37,440 (of 49,566 total)
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...
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...
July 27, 2009 at 6:56 am
Top or max according to which column?
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...
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....
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...
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?...
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...
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...
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,...
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...
July 26, 2009 at 2:21 pm
Laerte POltronieri Junior (7/26/2009)
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...
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...
July 26, 2009 at 5:14 am
Interestingly enough, here the shorter the reg plate, the more you pay. So if I wanted "I GP" (Gauteng Province), I'd be paying R3800. If I wanted "I WP" (Western...
July 26, 2009 at 4:33 am
Viewing 15 posts - 37,426 through 37,440 (of 49,566 total)