tag:blogger.com,1999:blog-37092901981970586502012-02-16T00:31:06.454-08:00On Update CascadeSQL Server musings, scripts, software.Merrill Aldrichhttp://www.blogger.com/profile/02611064766698741840noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-3709290198197058650.post-54813720297742884022011-03-09T12:54:00.000-08:002011-03-09T12:58:01.516-08:00Moved!Thanks for visiting - my blog is now hosted by the kind people at sqlblog.com. Please check me out at http://sqlblog.com/blogs/merrill_aldrich/default.aspx.Merrill Aldrichhttp://www.blogger.com/profile/02611064766698741840noreply@blogger.com0tag:blogger.com,1999:blog-3709290198197058650.post-6494520787110929652009-07-16T22:13:00.000-07:002009-07-17T08:13:59.958-07:00SQL Server "locks" MDF and LDF files upon detachI have seen this question on forums and experienced the joy myself: you want to move / copy / delete the physical files for a database, so you detach the DB using SQL Server, only to find that you can't manipulate the files in Windows afterward because you get a message that the files are locked or in use. Tools like Process Explorer don't show any open file handles, though, so the Windows Merrill Aldrichhttp://www.blogger.com/profile/02611064766698741840noreply@blogger.com0tag:blogger.com,1999:blog-3709290198197058650.post-83078358084628503832009-07-07T21:11:00.000-07:002009-07-24T09:23:30.857-07:00GO, RETURN, RAISERROR: Flow control in T-SQL ScriptsThis post has been moved over to my new blog at SQLBLOG.com
Flow Control @ SQLBlogMerrill Aldrichhttp://www.blogger.com/profile/02611064766698741840noreply@blogger.com0tag:blogger.com,1999:blog-3709290198197058650.post-90604723544071455032009-07-07T07:51:00.000-07:002009-07-26T16:29:13.949-07:00SAN Disk Array Performance: Beware LUN ConcatenationRelocated to sqlblog.comMerrill Aldrichhttp://www.blogger.com/profile/02611064766698741840noreply@blogger.com0