I was speaking at the Southampton SQL UG tonight, and as promised, here are links to the code samples that I used, plus some more in depth articles on the subjects I spoke about. Thanks to everybody for a good night...!
Shrinking Databases
Why not to shrink a database here
The world's worst maintenance plan? here
Using %%physloc%%
How to find what page your data is stored on here
Logical Order NOT Physical Order here
Allocation Units
What Are Allocation Units here
Querying Allocation Units here
Find my book, Pro SQL Server Administration on Amazon -
America
United Kingdom
No comments:
Post a Comment