Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
3
Newest
 Informed
Impact
~38 people reached

  • 0 posts edited
  • 0 helpful flags
  • 15 votes cast
Mar
15
comment Will an hourly T-Log backup in a Maintenance plan write a file if there are no changes to a DB?
@JonathanFite interesting suggestion, but it would seem that it's not writing to the same file since it picks a new datetime to put in each file name, such as "2016_03_15_145126_4878847"
Mar
15
asked Will an hourly T-Log backup in a Maintenance plan write a file if there are no changes to a DB?
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