Archive | Microsoft SQL Server

Use F5 To Execute A Query In Visual Studio

If you’re coming to Visual Studio 2010 from SQL Server Management Studio you’re probably getting annoyed by the fact that pressing the F5 does not execute your SQL when using the T-SQL Editor window. Do not fear! Like the $6 Million Dollar Man, “we have the technology… Better… Stronger… Faster.” Instead of the three buttons […]

SSIS: No column information was returned by the SQL command

Are you trying to use a stored procedure as the source of a SQL Server Integration Services (SSIS) data flow task?  If your stored procedure contains a temp table you may run into the message “No column information was returned by the SQL command” (complete error message below).  Although there are a number of solutions […]

Clearing the SQL Server Analysis Services Cache

Preparing to do some MDX performance testing?  Step one for each and every test should be to clear the cache.  This will ensure you are seeing the performance results without the benefit of having data already loaded up in memory.  How do you empty the MS SQL Analysis Services cache prior to running your query?