By Dejan Nakarada-Kordic, 05/23/2011
File operations that require many lines of T-SQL code can often be handled with a single function call if you use a CLR class, such as FileCLR. This class lets you easily obtain a ...
By Dejan Nakarada-Kordic, 05/23/2011
By Dejan Nakarada-Kordic, 02/08/2011
The size of a database's data files can affect database availability, performance, and support. Here's what you can do to effectively manage their size.
By Dejan Nakarada-Kordic, 02/19/2010
If you move database files using one the methods prescribed in the SQL Server documentation, you have to take your databases offline. You can avoid this situation by using the ...
By Dejan Nakarada-Kordic, 12/08/2009
Prevent data loss and improve performance by using this method to reduce conversation management overhead.
By Dejan Nakarada-Kordic, 11/24/2008
Here's a solution you can use when you need to disable XML validation yet have Service Broker continue processing when it encounters a poison message.