Viewing 15 posts - 10,306 through 10,320 (of 49,552 total)
The status is RECOVERING? Not anything else?
Post the error log?
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, 2014 at 9:44 am
Michael Smith-356657 (1/21/2014)
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, 2014 at 8:59 am
LOB_DATA is your varchar(max), nvarchar(max), varbinary(max), XML and a few other data types. They have special storage.
Typically you want to filter for 'in row data' when reindexing because reindexing affects...
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, 2014 at 8:57 am
SQL doesn't track modifications across restarts of the service. If you need to track that, you'll have to put some custom monitoring in place going forward.
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, 2014 at 8:44 am
SQLRNNR (1/21/2014)
GilaMonster (1/21/2014)
praneethydba (1/21/2014)
Still in Recovery. I am Panic.
Be patient.
The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the low...
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, 2014 at 8:39 am
That DMV only tracks data since the last time SQL was started. If a DB has had no data modifications since the last time the server was started, that query...
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, 2014 at 8:38 am
1) Temp tables
2) Temp tables, no, all users have permission to create those
3) Yes, kinda pointless though
4) See Books Online (the SQL help file), the page on the FROM clause
5)...
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, 2014 at 8:21 am
Close enough. Shared locks are released no later than the end of the query (assuming default isolation level), exclusive locks are held til the end of the transaction
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, 2014 at 7:44 am
praneethydba (1/21/2014)
They hired me to do this job. As I am in the beginning of my career. I am not sure, from where to start and what to find.
Do they...
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, 2014 at 7:15 am
Have you considered one of the row-versioning based isolation levels?
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, 2014 at 7:04 am
praneethydba (1/21/2014)
Still in Recovery. I am Panic.
Be patient.
The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the low side
My company...
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, 2014 at 6:04 am
Could you post the queries?
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, 2014 at 5:39 am
I think it's about a minute before SQL declares an IO failure for the log. It's not instant.
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, 2014 at 5:21 am
When running compressed backups, SQL initially allocates a file that may well be larger than the final backup will be. This is so that it doesn't have to grow 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, 2014 at 3:40 am
I would consider myself a reasonably competent writer, English is my first language and I've been writing for years. I still, when I submit something for review, get it back...
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, 2014 at 3:10 am
Viewing 15 posts - 10,306 through 10,320 (of 49,552 total)