This post is intended to be used as a hack for Developers to release some disk space. Please do not use on actual production environments.…
This post is intended to be used as a hack for Developers to release some disk space. Please do not use on actual production environments.…
Ever faced a situation when you are stuck with a SQL Server when you don’t have access even though if you are the Local Administrator.…
I came through one of the many interesting SQL questions on one of the forums yesterday. The original poster of the question wanted to get…
Introduction I had these similar databases on my dev environment which I had to delete multiple times during development. As this process was becoming more…
Ever wondered that how to get a comma (pipe or whatever) separated result for a column in a table in SQL Server? The following statement…
I ran into this strange situation where I wanted to get Trigger Definition(the SQL content) of a specific trigger from a database. The following SQL…