Viewing 15 posts - 12,796 through 12,810 (of 49,552 total)
No.
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
June 12, 2013 at 4:09 am
m.rajesh.uk (6/12/2013)
Check statement terminated due to unrepairable error.
Not repairable. Restore from backup.
p.s. Why repair in the first place? Repair should be the last resort, not the first thing tried. 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
June 12, 2013 at 4:06 am
SQL Show (6/12/2013)
Gail,Will You advice any workaround to reclaim space?
Patience. 🙂
Why are you shrinking anyway? Has the database been permanently reduced in size? Will the space you're trying to reclaim...
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
June 12, 2013 at 4:01 am
nitin.varshney (6/12/2013)
is it the right thing to add the newfilegroups in the database ?
Depends what you're trying to achieve. Maybe yes, maybe no.
We want to create the partition for 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
June 12, 2013 at 4:00 am
Depends. Why are you partitioning? What's the goal? Are those filegroups on different drives?
Also, you don't need to create partitions that far in advance, usually people have a job that...
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
June 12, 2013 at 1:05 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1462462-361-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
June 12, 2013 at 1:01 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1462462-361-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
June 12, 2013 at 1:00 am
You can't update the LSN anywhere. It's the log sequence number, it describes the order of data modifications.
If you're restoring log backups and one is corrupt then you cannot restore...
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
June 12, 2013 at 12:59 am
LOB data of any form makes for a very, very slow shrink, just because of the way the LOB data is stored.
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
June 12, 2013 at 12:57 am
Is the log reader agent running? Are the replication publications working?
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
June 11, 2013 at 4:37 pm
Yusuf Ali Bhiwandiwala (6/4/2013)
I am thinking of partitioning all these tables on the SetID column, which I am sure would be beneficial for performance and data maintenance.
Maintenance yes, performance probably...
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
June 11, 2013 at 4:14 pm
Inefficient queries + more CPUs = more blocking. Seen that more than once.
Tune the queries, tune the indexes.
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
June 11, 2013 at 4:12 pm
It's actually the lack of parameter sniffing that's the problem here.
http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
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
June 11, 2013 at 11:15 am
Logged as in written to the transaction log? If so, no. It's not a data modification, it has no effect on any existing database, therefore it's not written to 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
June 11, 2013 at 11:07 am
Eugene Elutin (6/11/2013)
I will be very brave to disagree with Gail on this one. But...There are such thing as a "nested transaction" in MS SQL Server.
There are no such...
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
June 11, 2013 at 11:06 am
Viewing 15 posts - 12,796 through 12,810 (of 49,552 total)