8,457 reputation
1531
bio website
location
age
visits member for 3 years, 7 months
seen 1 hour ago

21h
comment What makes yum difficult with RAID
The vote to close isn't a downvote, it is a vote to close and suggest a better location for the question. "hard to use yum when having a RAID setup" definitely makes this more a SF question than a DBA one IMO even with the connected MySQL reference.
22h
answered What makes yum difficult with RAID
22h
comment What makes yum difficult with RAID
This question appears to be off-topic because it is about sys admin functions in general. It probably belongs on serverfault instead.
1d
answered View vs TableValued Function vs SubQuery
1d
answered What relevance does the table-level ANSI_NULL setting have?
1d
revised How do I prove that the act of removing foreign keys doesn't corrupt existing data?
added 71 characters in body
1d
revised How do I prove that the act of removing foreign keys doesn't corrupt existing data?
Added in proof notes from discussion in the comments so they don't get "lost" from view.
2d
comment How do I prove that the act of removing foreign keys doesn't corrupt existing data?
More specifically about removing the constraints: show that dropping them does not alter existing data at all. Create a copy of the database, drop the keys in the copy, and run a full comparison of the data to show that nothing changed as a result of the constraints being lifted.
2d
comment How do I prove that the act of removing foreign keys doesn't corrupt existing data?
The only proof I can think of is first principals: reasserting what foreign key constraints actually do thereby showing that they would not allow inconsistency to appear, and if there are specific examples of the corruption the person has in mind you could work through trying to create that problem with the keys in place (showing that the key would have caused an error instead of allowing the inconsistency to be created).
2d
answered How do I prove that the act of removing foreign keys doesn't corrupt existing data?
2d
comment CSS layout picture
Or the more specifice web development sites of which there is at least one in the stack exchange family (webmasters.stackexchange.com). Also, your one tag is almost completely irrelevant - you will need to improve your question before you post it elsewhere or it'll just get closed wherever you put it on stack exchange sites.
Aug
12
answered Does column size increase break SELECT *?
Aug
12
comment Script that alters all stored procedure on the database
You can read the definitions a bit more cleanly than using sp_helptext by joining in sys.sql_modules on the object_id columns (though as you'll be cursoring to make the updates anyway in the case the difference is small).
Aug
11
comment How can I correct SQL Server Error 8928?
@user3571601: if the data is corrupt then there may be absolutely no guaranteed way other than restoring from a "known good" backup that was taken recently (but before the corruption started).
Aug
11
revised Insert into select into multiple related tables using INSERT_IDENTITY
added 340 characters in body
Aug
11
comment MySQL auto_increment delivers different primary key in MyISAM and InnoDB
Actually, depending on the transaction/locking options used (assuming mysql can be as flexible as other DBMSs in this regard) there might be times when long running transactions make the IDs look like they are not always guaranteed to be increasing (they are, and will appear so for the standard/default options, but some may not appear in the data as other transactions see it until the long running transaction has completed).
Aug
11
answered Insert into select into multiple related tables using INSERT_IDENTITY
Aug
8
answered SELECT UNION from two views of the same table
Aug
7
comment Database going to Suspect mode
Exactly: wherever possible don't "just recover" without trying to work out what the source of the problem is, that way you risk exacerbating the situation.
Aug
7
comment Database going to Suspect mode
Check the Windows service and application logs - SQL Server may be noting in there what caused the switch to "suspect", or at least may record in there exactly when it happened so you can look for errors from elsewhere around the same time that might indicate a particular hardware/driver/other issue.