Onion-Knight

345 reputation

bio	website	None.
	location	California
	age	28
visits	member for	1 year, 7 months
	seen	Apr 8 at 20:51
stats	profile views	9

Work as a Software Developer for a small IT Company.

	345 reputation	bio	website	None.	visits	member for	1 year, 7 months
27 badges		location	California		seen	Apr 8 at 20:51

summary answers questions tags badges favorites bounties reputation activity

44 Actions

suggestions reviews revisions comments badges posts accepts all

Feb 28	awarded	Popular Question
Feb 20	awarded	Notable Question
Oct 11	accepted	Save Results of DBCC ShrinkFile
Oct 9	comment	Save Results of DBCC ShrinkFile I am trying to script this, as I don't want to login to the Database Server every time I want to execute this. I'm hoping the scripting can be done in SSMS.
Oct 9	revised	Save Results of DBCC ShrinkFile added 24 characters in body
Oct 9	revised	Save Results of DBCC ShrinkFile added 350 characters in body
Oct 9	asked	Save Results of DBCC ShrinkFile
Oct 5	awarded	Yearling
Oct 5	comment	Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups? @ShawnMelton: We do the Nightly TLog Backup after the DB Backup. We then do TLog backups every 6 hours (until the next Nightly Backups).
Oct 5	awarded	Editor
Oct 5	accepted	Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups?
Oct 5	comment	Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups? @ShawnMelton: There are 2 Transaction Log backups. 1 Nightly and 1 every 6 Hours. I've edited the question to make it more clear.
Oct 5	revised	Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups? added 9 characters in body
Oct 4	asked	Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups?
Jul 31	comment	Unique Contraint/Index Based On Values Luckily, I was able to upgrade to SQL 2008 and use a Filtered Index. However, if that was not an option, this would definitely be the approach I'd use.
Jul 31	accepted	Unique Contraint/Index Based On Values
Jul 30	asked	Unique Contraint/Index Based On Values
Jun 15	accepted	When To Update Statistics?
Jun 12	comment	When To Update Statistics? We Rebuild the indexes once a week.
Jun 12	comment	When To Update Statistics? @JNK We insert ~70,000 rows per day across the entire DB. Update ~100 rows a month.