Reputation
9,935
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
17 38
Newest
 Nice Answer
Impact
~444k people reached

Apr
21
answered How to get a surrogate key value in order to put a foreign key in and create relationship?
Apr
15
comment Restoring a backup of a database from SQL Server 2014 into SQL Server 2012
@BuahahaXD: No, even with a "back dated" compatibility level setting the database structures will be those of SQL2014. The compatibility modes only affect certain behaviour, not the underlying structure.
Apr
14
comment conversion failed when converting the varchar value 'JENNIFER FALCONER
... and the definition of the tables (and other structure like views) involved otherwise we have to guess datatypes which is significant in cases like this.
Apr
9
awarded  Nice Answer
Apr
2
comment MySQL Data Synchronisation from different Databases in C#
That's why I used a comment: I've suggested an alternative rather than answering the actual question! If the result wanted is "an updated copy of the DB from <source> to exist at <destination>" then replication will achieve that as efficiently as anything hand-rolled (unless you have some business logic that states not all tables are to be included in which case a hand-rolled routine may transfer much less). You can do log shipping and control when log backups are taken & shipped & restored so you can have a static copy at a particular time rather than having to run fully dynamic replication.
Apr
2
comment MySQL Data Synchronisation from different Databases in C#
That won't be "integrity safe" unless you completely lock all tables in the source database to stop changes while you make the updates in the destination. Rather then reinventing the wheel you could use existing technology to keep databases in sync and try the built-in replication support: dev.mysql.com/doc/refman/5.0/en/replication.html
Apr
1
reviewed Edit The Local Security Authority cannot be contacted
Apr
1
revised The Local Security Authority cannot be contacted
edit text and improved tagging
Mar
25
answered Recommended number of index for a table
Mar
24
revised High Availability using SQL Server 2012 requires how many licenses
added 42 characters in body
Mar
24
answered High Availability using SQL Server 2012 requires how many licenses
Mar
17
revised Out of the box why is a simple query from a 50gb table taking 5x longer in postgres vs sql server--help?
Syntax fix.
Mar
17
answered Out of the box why is a simple query from a 50gb table taking 5x longer in postgres vs sql server--help?
Mar
16
awarded  Revival
Mar
11
revised Getting all descendants of a parent
Added brief notes on other options
Mar
11
answered Getting all descendants of a parent
Mar
9
comment UPDATE statement not consistent when including NULL fields
In standard SQL any operation with a NULL results in NULL (except if you consider applying specific functions like COALESCE), including comparison, arithmetic, and (as in this case) concatenation. You are not wrong, but your statement holds for much more than SQL Server & string concatenation. Regarding COALESCE: you should probably use that rather than ISNULL for portability too (ISNULL is not part of the standard, COALESCE is) unless you are using subqueries inside the function in which case there can be a significant performance difference.
Feb
26
comment Data Warehousing strategy
@ninjabber: So it is possible, though that technique feels rather "dirty" to me. Deliberately circumventing a process intended for maintaining consistency. All the business logic (stored procedures and triggers in the DB and everything in apps outside that modify data in it) will need to make sure that "don't log this" option is set at the right times and only at the right times - that seems to be an open invitation for some interesting bugs!
Feb
25
answered Data Warehousing strategy
Feb
24
answered Store extended properties and apply to another copy of the database