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 […]
Reblogged from SQL Server Journey with SQL Authority: Just a day ago, I was reading the blog post of Michale J Swart. If you are a regular reader of this blog, I am sure you will be familiar with him. He is a very interesting blogger for sure. He recently wrote an article about Ten […]
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, […]
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 […]
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 […]
This article shows a practical use for dynamic SQL and FOR XML.