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...
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 22, 2013 at 1:28 am
Maybe start with this:
http://www.amazon.com/Server-Relational-Database-Implementation-Experts/dp/143020866X/
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 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'.
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 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...
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 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...
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 21, 2013 at 10:14 am
Got an index rebuild after the integrity check?
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 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...
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 21, 2013 at 9:48 am
jfriedl (1/21/2013)
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 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...
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 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...
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 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...
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 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.
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 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...
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 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...
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 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...
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 21, 2013 at 7:16 am
Viewing 15 posts - 14,701 through 14,715 (of 49,552 total)