-...

APPLY operator appeared in SQL Server 2005 and allows T-SQL to invoke a table value function for each row in an outer record set. However we found the situation when people used this operator correctly or not. What are the situa...

A common pratice to move or transfer database files to change their location or to send it to another team dev per example is to shutdown the SQL Server instance. What is the main cause of this problem and why is it prefered to ...

Thanks Dhivager. When I have time I will prepare a second blog post about this subject....

Thanks Dhivager. When I have time I will prepare a second blog post about this subject....

Sometimes, it is necessary for a database administrator to move database transaction log files. For example, the host partition can run out space or the subsystem disk architecture can change. Move files on a normal situation is pretty straightforward b...

Sometimes, it is necessary for a database administrator to move database transaction log files. For example, the host partition can run out space or the subsystem disk architecture can change. Move...

David Barbarin has created a sandbox for the tricky testing of <a href="/blogs/...

<a href="/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles...

<img style="border-right-width: 0px; float: left; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" src="/resized-im...