Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brovashift
Starting Member
1 Post |
 Posted - 2012-05-07 : 08:10:58
|
Hi all, simples one for you hereIm a novice at SQL but have been thrown into learning advanced databases when I haven't even done basic db's yet!I just want to know if there is a difference between fragmentation and partitioning a distributed database?Is it ok to say "By fragmenting, also known as partitioning, the data..." does it make sense?Thanks guys!  |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-05-07 : 08:22:14
|
| Umh...NO! These are two completely different concepts. In an obscure way you might be able to justify saying that partitioned data is fragmented (stored in different fragments) but this would be stretching the terms pretty far.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-05-07 : 08:28:48
|
quote:
Originally posted by Lumbago
Umh...NO! These are two completely different concepts. In an obscure way you might be able to justify saying that partitioned data is fragmented (stored in different fragments) but this would be stretching the terms pretty far.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
I agree....You need to do some reading on the both. The following links might help:[url]http://msdn.microsoft.com/en-us/library/ms190787.aspx[/url][url]http://blogs.msdn.com/b/anthonybloesch/archive/2008/12/18/sql-server-fragmentation.aspx[/url]N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
|
|
|
Fragmentation and Partitioning