Viewing 15 posts - 33,556 through 33,570 (of 49,552 total)
When you say 'rebuilding and reindexing', what commands are you specifically referring to.
In general, rebuild means ALTER INDEX ... REBUILD, but reindexing can mean just about anything.
March 11, 2010 at 1:43 am
That's kinda the last resort to fixing corruption.
If you have clean backups you should, now that you can remove replication, restore the clean backups so that you haven't lost...
March 11, 2010 at 1:32 am
As always, it depends.
26 bytes isn't that big, it's not as if we're talking a 400 byte index key. Also, if it's a vendor app that you can't change, then...
March 11, 2010 at 1:17 am
Define 'fails'.
What exactly did you do and what exactly was the result?
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in...
March 11, 2010 at 1:16 am
Tushar-355587 (3/10/2010)
Also according to me, its not a good idea to create a snapshot on a database whose whole data is being changed.
Depends on the reason for using the...
March 10, 2010 at 9:06 am
I doubt there will be any resources or best practice yet. R2 hasn't even been released yet.
March 10, 2010 at 8:06 am
Paul White (3/10/2010)
GilaMonster (3/10/2010)
A database snapshot is not a backup.The confusion probably arose because you can RESTORE to a snapshot.
Or a mix-up with SAN snapshots
March 10, 2010 at 7:31 am
I missed one.
http://www.sqlservercentral.com/Forums/Topic880142-146-1.aspx
Copy only backup. No, I mean snapshot backup. Huh?
March 10, 2010 at 7:19 am
A database snapshot is not a backup.
I know a fair amount about snapshots and sparse files, but I can't tell what the problem is.
Details please, the more the better.
March 10, 2010 at 7:18 am
RJ-476420 (3/10/2010)
Moreover, count(*) uses the table scan but a primary key is indexed & will never have a NULL value.
No it won't.
Count(*) scans the smallest index on the table to...
March 10, 2010 at 7:05 am
Roy Ernest (3/10/2010)
GilaMonster (3/10/2010)
Google might be a good bet for him. Seems like he has lots of questionshttp://www.sqlservercentral.com/Forums/Topic880137-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic880152-146-1.aspx
It is the same guy asking about the replication issue as well.. Interview...
March 10, 2010 at 6:53 am
Can you be specific please?
What do you want to use it for? What's the scenario? Why are you concerned about it?
March 10, 2010 at 6:51 am
A contender for the 'vague question of the week' award
http://www.sqlservercentral.com/Forums/Topic880119-391-1.aspx
March 10, 2010 at 6:48 am
March 10, 2010 at 6:45 am
Viewing 15 posts - 33,556 through 33,570 (of 49,552 total)