311 reputation
18
bio website
location Toronto, Canada
age
visits member for 1 year, 8 months
seen May 15 at 17:49
stats profile views 14

SQL Server 2005/2008/2012


Jan
7
awarded  Critic
Jan
7
comment Moving rows from one table to another
Yes, that is what I meant. Thanks, I see your point.
Jan
4
accepted Moving rows from one table to another
Jan
4
comment Moving rows from one table to another
None of the above. I suppose I could go that route, I like code minimalism. I just do not want to lose records if the insert fails for any reason. (ie: table locking, timeouts, etc) Thank you!
Jan
4
asked Moving rows from one table to another
Dec
21
accepted Size of TempDB Microsoft SQL Server 2005
Dec
20
asked Size of TempDB Microsoft SQL Server 2005
Oct
31
awarded  Yearling
Oct
4
accepted Can I replicate to a pre-existing database?
Oct
4
comment Can I replicate to a pre-existing database?
Agreed, also found instructions from MSDN: msdn.microsoft.com/en-us/library/ms151705.aspx
Oct
1
awarded  Custodian
Oct
1
reviewed Approve suggested edit on Can I replicate to a pre-existing database?
Oct
1
awarded  Commentator
Oct
1
comment Can I replicate to a pre-existing database?
The same thing! But. It's SQL 2012 and the old server is 2005.
Oct
1
asked Can I replicate to a pre-existing database?
Sep
28
comment Should I rely on Database Engine Tuning Advisor for creating indexes?
The reason DMVs are not particularly useful is because I am trying to think of Indexes for brand new tables.
Sep
28
comment Should I rely on Database Engine Tuning Advisor for creating indexes?
Yes SQL Server 2012. Sorry I should have been more specific.
Sep
27
asked Should I rely on Database Engine Tuning Advisor for creating indexes?
Sep
21
asked Consolidating data changes in SQL Server by team
Sep
17
accepted Alternatives to AdeptSQL Diff (for MS SQL Server 2012)