Reputation
Next privilege 125 Rep.
Vote down
Badges
3
Newest
 Informed
Impact
0 people reached

  • 0 posts edited
  • 0 helpful flags
  • 13 votes cast
Apr
30
comment Worse performance on a new server
You should mention your disk/array/SAN setup. Swap, Tempdb, etc on which drives with specs, and SQL config.
Apr
30
awarded  Informed
Oct
1
awarded  Supporter
Sep
17
comment Shrinking MDF File
+1, no data lost: "DBCC SHRINKFILE does not shrink a file past the size needed to store the data in the file. For example, if 7 MB of a 10-MB data file is used, a DBCC SHRINKFILE statement with a target_size of 6 shrinks the file to only 7 MB, not 6 MB."
Nov
4
awarded  Autobiographer