MacGyver

355 reputation

213

bio	website
	location
	age
visits	member for	1 year, 4 months
	seen	May 13 at 6:05
stats	profile views	28

My friends call me "Mac". I'm a master of improvisation. I have vast scientific knowledge and unique abilities to use ordinary objects to get myself and friends out of trouble. I typically carry my Swiss Army knife and a roll of duct tape with me at all times. I dislike guns because of a traumatic childhood incident. I try to avoid violence whenever possible. Because my life was getting too stressful at the Phoenix Foundation, I have picked up programming as a new career. I spend my spare time on Stack Overflow.

	355 reputation	bio	website		visits	member for	1 year, 4 months
213 badges		location			seen	May 13 at 6:05

summary answers questions tags badges favorites bounties reputation activity

92 Actions

suggestions reviews revisions comments badges posts accepts all

May 3	awarded	Popular Question
May 1	asked	Change URL of Erwin data model HTML export hyperlink of www.ca.com to something different
Apr 23	awarded	Notable Question
Apr 5	answered	What can cause statistics to get out of line?
Apr 5	awarded	Popular Question
Mar 28	awarded	Popular Question
Mar 26	comment	Differences Between Two Different Create Index Commands My actual issue wasn't that they were different. It was that in our ETL code, it was trying to drop an index that didn't exist. We renamed a table, and never created the new index based on that name. The T-SQL script in our ETL code couldn't find the index to drop. But thanks for the detail. I learned a lot.
Mar 26	accepted	Differences Between Two Different Create Index Commands
Mar 26	revised	Differences Between Two Different Create Index Commands added 559 characters in body
Mar 26	asked	Differences Between Two Different Create Index Commands
Mar 13	awarded	Popular Question
Feb 28	asked	Open source tools to manage Data Quality
Feb 13	accepted	Restore SQL Server database from backup file of different version of different editions
Feb 11	answered	Data dictionary best practices in SQL Server 2008 r2
Feb 6	accepted	Open source and commercial tools to build dynamic queries of fact tables in star schema
Feb 5	asked	Open source and commercial tools to build dynamic queries of fact tables in star schema
Jan 30	asked	Restore SQL Server database from backup file of different version of different editions
Jan 15	revised	Inserting rows into other table whilst preserving IDENTITY edited tags
Jan 15	accepted	Inserting rows into other table whilst preserving IDENTITY
Jan 14	comment	Inserting rows into other table whilst preserving IDENTITY yes I would like to keep the ids the same. This is a deployment, so I don't like to have discrepancies (if possible)