Viewing 15 posts - 14,701 through 14,715 (of 49,552 total)
I say exactly what I said earlier.
As it stands, it's not going to prevent anything. It just notes that updates aren't permitted and then finishes, thus completing the update.
In...
January 22, 2013 at 1:28 am
Maybe start with this:
http://www.amazon.com/Server-Relational-Database-Implementation-Experts/dp/143020866X/
January 21, 2013 at 3:10 pm
You've got double slashes in your path.
set @OutputFileName = 'C:\\tracefiles\SQL_Performance' + '_' + convert(varchar(20), getdate(),112) + Replace(convert(varchar(20), getdate(),108),':','')
The first error is 'could not create trace file'.
January 21, 2013 at 1:57 pm
Del Lee (1/21/2013)
To me, it sounds like the corruption is still there and can reappear when that page or pages become "reallocated."
No. When a page is reallocated, it's...
January 21, 2013 at 1:53 pm
Fixed, no. Deallocated the corrupt page, yes.
CheckDB only checks allocated pages. If an index rebuild deallocated a corrupt page as part of the rebuild, the corruption would 'vanish', because it's...
January 21, 2013 at 10:14 am
Got an index rebuild after the integrity check?
January 21, 2013 at 9:49 am
Scott Rankin (1/21/2013)
So you are getting way down into the heart of SQL Server internals here.
Not that deep really
But, if I understand it correctly, the difference between logical and physical...
January 21, 2013 at 9:48 am
jfriedl (1/21/2013)
January 21, 2013 at 9:09 am
Lowell (1/21/2013)
as far as I know, the binaries for SQL must be installed on the %systemdrive% (usually the C:\ drive)
The binaries can be anywhere. I have mine installed on the...
January 21, 2013 at 9:07 am
Yes, I know, books online is wrong. I really must get ahold of someone on the docs team and get this fixed.
It's trivial to prove, I'll leave that up to...
January 21, 2013 at 9:01 am
sej2008 (1/21/2013)
are they logged in log file and if yes when?
and can we log those trigger events in auditing...
January 21, 2013 at 7:55 am
As it stands, it's not going to prevent anything. It just notes that updates aren't permitted and then finishes, thus completing the update.
January 21, 2013 at 7:54 am
mjjordan (1/21/2013)
Based on what I had found with my searches I was under the impression that using a backup was a last resort after attempting a repair.
No. The backup...
January 21, 2013 at 7:53 am
Firstly, why did you decide to go for an emergency mode repair (that may very well result in data loss) instead of restoring a backup?
Emergency mode repair is the very...
January 21, 2013 at 7:41 am
Scott Rankin (1/21/2013)
This is what a clustered index does. If physically orders the data within the table.
Logical order. Not physical. The index may be physically ordered by the...
January 21, 2013 at 7:16 am
Viewing 15 posts - 14,701 through 14,715 (of 49,552 total)