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.
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
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...
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
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...
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
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...
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
March 11, 2010 at 1:16 am
No good backup then?
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
March 11, 2010 at 1:05 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...
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
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.
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
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
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
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?
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
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.
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
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...
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
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...
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
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?
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
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
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
March 10, 2010 at 6:48 am
Please read through this - Managing Transaction Logs[/url]
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
March 10, 2010 at 6:45 am
Viewing 15 posts - 33,556 through 33,570 (of 49,552 total)