Reputation
1,765
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 9
Newest
 Yearling
Impact
~130k people reached

Jul
14
revised Query Parallelism
edited tags
Jul
14
awarded  Editor
Jul
14
revised Add DEFAULT to existing column
added 252 characters in body
Jul
14
answered Add DEFAULT to existing column
Jul
9
answered SQLCMD Mode in SSMS and @@variable expansion
Jul
9
answered More Databases Per Sql Server 2005 Instance
Jul
6
comment LDF and MDF file sizes for a dynamically created Database
You could set up SQL Agent alerts, use the performance condition alert, and the Databases object to alert on Data File/Log File size > xGB. But the alert won't stop the database from growing, only setting a max on file size will do that.
Jul
4
awarded  Critic
Jul
4
awarded  Citizen Patrol
Jun
24
answered A query submitted from different applications has differing DOP
Jun
1
answered SQL Server Backup Process Tuning
Apr
4
awarded  Teacher
Apr
3
answered Redgate SQL Compare vs Visual Studio 2010 Premium/Ultimate database project
Mar
29
comment SQL Server 2008 R2 Express for a single website?
One downside of no agent is you'll need some other mechanism to schedule backups, the Windows task scheduler works fine.
Jan
22
awarded  Supporter