Viewing 15 posts - 12,796 through 12,810 (of 49,552 total)
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...
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...
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...
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...
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
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
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...
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.
June 12, 2013 at 12:57 am
Is the log reader agent running? Are the replication publications working?
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...
June 11, 2013 at 4:14 pm
Inefficient queries + more CPUs = more blocking. Seen that more than once.
Tune the queries, tune the indexes.
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/
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...
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...
June 11, 2013 at 11:06 am
Viewing 15 posts - 12,796 through 12,810 (of 49,552 total)