CUBE was introduced in SQL Server 2005. When you use the CUBE operator it generates a result set of every possible combination from your set of columns; much like a CUBE would be generated if you were using analysis services. the CUBE operator isn’t something I’ve had to use much so I’ll show you an example. […]
Recently, I needed to find out the schema of a resultset returned by a Stored Procedure so I could pass some failing SQL Unit Tests. I needed to know the columns, the column order and exact datatypes. Without access to a client to run the procedure I needed a way to do this with just […]
I think it depends on your requirements, I’ve used a similar flag to indicate “active” records but this also had an automated process to move inactive records into a separate table so those operations could batched.
I’ll be providing a more detailed post on this shortly, in the meantime please check out http://www.red-gate.com/products/sql-development/sql-test/. SQL Test internally uses tSQLt, a popular open source framework, combined with Redgate’s expert knowledge of providing add-ons to management studio means that we now have an integrated toolset for test driven development in the SQL world. Why […]
A possible fix to slow performance in SQL 2008 integrated full text search.
Example of SQL Server 2008's ability to insert data into temporary tables or table variables from an EXEC statement . This includes populating the temporary objects from a stored procedure.
Simon Sabin posted about this a few weeks back but I hit the issue he described today so I wanted to write about it and what I had to do. The issue I am talking about is related to the account Full Text host uses to perform out of process tasks. This account, in CTP6, […]