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. […]
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.
August 13, 2012
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 […]
September 16, 2008
A possible fix to slow performance in SQL 2008 integrated full text search.
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.
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, […]
April 29, 2008
This is direct from MSDN but I was asked about this specifically so I thought I’d post about it. If anyone has used full text search you will know that the default way it ranks results is pretty good. It uses a known method called Jaccard Coefficient. However, there are times when you might want […]
April 23, 2008
This may be only relevant to 2008 but if you find Fulltext index creation taking a long time to complete you may be affected by a potential bug in CTP6. If you are experiencing this problem you can try running the following statement prior to the creation of the index. This will disable the checking […]
April 15, 2008
This article shows a practical use for dynamic SQL and FOR XML.
Barry King 
December 28, 2012
0