Hi it’s very important to identify the following things as sql server developer. Like-
how large your database is, how full the files are, which tables and indexes use the most space, which tables might be dormant, etc…
Here is the link for excellent script from Glen Berry.
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!1619.entry
No comments:
Post a Comment