Viewing 15 posts - 12,511 through 12,525 (of 49,552 total)
Consistency checks?
Stats updates?
Log backups?
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 2, 2013 at 7:06 am
Please post new questions in a new thread. Thank you.
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 2, 2013 at 6:14 am
CAST(TextData as Varchar(8000))
put that in the insert instead of just the column name.
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 2, 2013 at 3:01 am
Yup.
The order of 1 and 2 and the order of 4 and 5 are irrelevant. Doesn't matter which recovery model you're in when the log backup runs, as long as...
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 2, 2013 at 1:49 am
http://www.sqlservercentral.com/articles/Recovery+Model/89664/
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 1, 2013 at 3:52 pm
How did you 'take care of the problem'? What exactly have you done? What exactly is the situation? What exactly are you trying to do?
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 1, 2013 at 3:51 pm
May I suggest you speak with the senior DBA there, get his help.
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 1, 2013 at 11:27 am
I'd call Customer Support at this point.
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 1, 2013 at 11:02 am
Anything relevant in the SQL error logs?
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 1, 2013 at 10:44 am
Mile Higher Than Sea Level (7/1/2013)
When does rebuilding an index make sense?
When the index fragmentation is above one of the recommended thresholds or the average page usage is...
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 1, 2013 at 10:42 am
I suspect you're going to have to restore from your last good 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
July 1, 2013 at 10:38 am
Stefan Krzywicki (7/1/2013)
GilaMonster (7/1/2013)
Where did I leave my crystal ball?http://www.sqlservercentral.com/Forums/Topic1469066-5-1.aspx
I think the OP doesn't know enough to know they aren't answering your questions.
Take a look at his posting history. Also,...
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 1, 2013 at 9:21 am
Once more with feeling...
Error log entries relating to the database please. SQL will log why the DB was marked suspect. Take a read through the error log and post any...
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 1, 2013 at 9:20 am
Where did I leave my crystal ball?
http://www.sqlservercentral.com/Forums/Topic1469066-5-1.aspx
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 1, 2013 at 9:15 am
If you don't want help, that's fine. If you do, please answer my questions. I can't help you without information.
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 1, 2013 at 8:41 am
Viewing 15 posts - 12,511 through 12,525 (of 49,552 total)