Guest Columnist: Solomon Rutzky

Changing the structure of a very large table doesn't need to require a maintenance window.  Read more...

People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.  Read more...

Table partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.  Read more...

SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.  Read more...

Reduce both time and memory utilization when uploading bulk data to SQL Server 2008 by combining Table-Valued Parameters (TVPs) and the .Net IEnumerable interface.  Read more...

Testing DB code is not fun or easy so it usually gets ignored. But now there’s a super-easy way to test using DBFit.  Read more...

The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.  Read more...

When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.  Read more...

A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.  Read more...

The CLR integration in SQL Server 2005 greatly expands on the capabilities of the SQL Server platform. One new area is the ability to build user-defined types and user-defined aggregates. Solomon Rutzky brings us a way to get around some of the limitations in this area with his SQL# toolkit.   Read more...

While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need.   Read more...