Until now, I always believed the maximum number of partitions a table could have was 1,000. This is correct for 32-bit SQL Server. In 64-bit, however, up to 15,000 are permissable....

This short tip is a result of my quick research in attempt to solve this MSDN thread http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/f02aefbd-09a5-4336-84d2-d67bdf238221 In order to use case sensitive search with PATINDEX we need to...

This short tip is a result of my quick research in attempt to solve this MSDN thread http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/f02aefbd-09a5-4336-84d2-d67bdf238221 In order to use case sensitive search with PATINDEX we need to...

SQL 2005 solution utilising ROW_NUMBER. This is a resubmission as my previous entry included an additional column I was using to debug! Oops. Divide each ID partition by 2 further partitions: one where interval date is defined, the other where it is not.

SQL 2005 solution utilising ROW_NUMBER. Divide each ID partition into 2 further partitions: one where IntervalDate is defined, the other where it is not. Derive the rank of the elements using ROW_NUMBER in Interval order. The rank of the partition contai

Another classic islands algorithm implemented in SQL 2012. This is a correction to the previous submission which contained a bug!

Another classic islands pattern implemented in SQL 2012. Start by determining the islands (aliased GID for 'GroupID'). In this case an island is defined by one or more contiguous rows with common key of ProductID, TotalLines, and LinesOutOfService value

Which version of SSIS are you running? If 2008 or above, I'd be interested to know how much memory has been granted to SSIS and how much the package is consuming. You said that your package originally had 5 Union All transforms. Does it also have 5 Loo...

Hi Divya I haven't come across this before but it's good that you did. There is no need for the UNION ALL executable here so your 'workaround' resulted in a more efficient design. As you alluded to, UNION ALL is a partially blocking transformatio...

I haven't come across this before but it seems like a good solution to warming up the query cache. Very interesting. It's worth pointing out though that if you want to use it to warm up the cache, you must execute SET NOEXEC in its own batch prior to ex...