Browsing All Posts filed under »SQL«


December 28, 2012


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. […]

Inserting the results of a stored procedure into a table

October 18, 2012


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 […]

August 15, 2012


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.

SQL Server Test Driven Development with Redgate’s SQL Test

August 13, 2012


I’ll be providing a more detailed post on this shortly, in the meantime please check out 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 […]

SQL Server 2008 Full Text slowness

September 16, 2008


A possible fix to slow performance in SQL 2008 integrated full text search.

Insert into temporary table from Stored Procedure

May 6, 2008


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.

FDHost Account Password Expiry Issue In CTP6

April 30, 2008


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, […]