Reputation
23,209
Top tag
Next privilege 25,000 Rep.
Access to site analytics
Badges
2 27 59
Newest
 Yearling
Impact
~1.5m people reached

Jan
3
awarded  Yearling
Dec
29
awarded  Nice Answer
Nov
30
comment What can be done, if anything, to tune a SharePoint database?
SharePoint doesn't handle index rebuilds and stats updates. You have to do that in SQL Server directly. As for splitting the content databases, that has to be done through SharePoint.
Nov
3
answered Non Clustered Index Scan Properties window - Predicate order different than query order
Oct
10
awarded  Revival
Oct
9
awarded  sql
Oct
8
awarded  Revival
Sep
27
answered database corruption
Sep
9
awarded  Nice Answer
Sep
4
comment Can't restore SQL Server db from full backup, log processing fails, database in 'restoring' state
Sounds like the source database is corrupt. Has anyone run DBCC CHRCKDB against the source server?
Aug
31
awarded  Good Answer
Aug
15
comment SQL Server storage limits on Azure
Yep, pretty much.
Aug
15
answered Virtualize SQL High CPU
Jul
31
awarded  Necromancer
Jul
31
awarded  backup
Jul
27
answered Bidirectional Replication Push and Pull with SQL Server
Jun
17
awarded  Enlightened
Jun
17
awarded  Nice Answer
May
26
awarded  Revival
Apr
11
comment Restoring SQL Server 2000 database to SQL Server 2008
Yes you just need to restore the user databases to the new instance and change the compatibility level if you need the higher level compatibility. There's no need to change the collation.