I recently got many emails requesting to write a simple article. I also got a request to explain different ways to insert the values from a stored procedure into a table. Let us quickly look at the conventional way of doing the same with Table Valued Function.
SQLAuthority News – Article 1100 and Community Service
This is 1100 the post of on my blog post on this blog. Just looking at the last 100 post of my blog, I have realized besides writing blog posts there are lots of other community events, I have been involved with. Let me quickly list few of the important…
Read MoreSQL SERVER – Introduction to Service Broker and Sample Script
Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation.” Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered…
Read MoreSQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location
I was reading the blog of Ward Pond, and I came across another note of Microsoft. I really found it very interesting. The given explanation was very simple; however, I would like to rewrite it again. Let us execute the following script. This script inserts two values ‘A’ and ‘B’…
Read MoreSQLAuthority News – SQL Server Accelerator for Business Intelligence (BI)
I have wonderful experience at my recent Business Intelligence tour. I will write down in detail about my experience at different location. However, today I would like to talk about one particular question which was asked at all the locations. It was about SQL Server Accelerator for Business Intelligence (BI).…
Read MoreSQL SERVER – Converting Stored Procedure into Table Valued Function
In one of my recent articles, I mentioned the use of Table Valued Function (TVF) instead of Stored Procedure (SP). I received a follow up email asking what type of SP can be converted into a TVF. This is indeed a very interesting question! In fact, not all the SPs…
Read MoreSQLAuthority News – Download Microsoft SQL Server StreamInsight CTP2
Note: Download Microsoft SQL Server StreamInsight CTP2 by Microsoft Microsoft SQL Server StreamInsight is a platform for the continuous and incremental processing of unending sequences of events (event streams) from multiple sources with near-zero latency. These requirements, shared by vertical markets such as manufacturing, oil and gas, utilities, financial services,…
Read More