I’m just back from New year vacation and had a good news waiting for me. I got renewed third time in a row as SQL Server MVP! I take this oppurtunity to thank all of you who have been following…
Running SSIS packages in 32 bit mode in 64 bit server
The impetus for this blog is recent issue faced by use in running SSIS package from a job created in SQL Server agent. The package was locally developed and tested fine. After deploying package to server and trying to run…
DBIDs are not consistent always…
Today one of fellow developers asked me a question on db_id which prompted me to do some analysis and find out the discovery which I’m sharing here. Database ids will not always point to same database! Before you get fully…
Composable DML continued…
This is a follow up post of http://visakhm.blogspot.com/2011/08/multiple-table-insertion-using-single.html In the above post I’ve illustrated how Composable DML feature can be applied for simultaneous insert to parent child tables. I was trying to use this feature in a similar scenario when…
RECONFIGURE WITH OVERRIDE
I was recently trying to implement a CLR function in one of my dbs. I deployed and was about to test when i got the error that CLR is not enabled in system and its required for running .NET code.…
REPLACE() function – SQL 2008 v/s SQL 2005
This blog is intended for sharing an interesting difference I spotted between the functionality of REPLACE function in SQL 2008 & 2005 versions Consider the following example DECLARE @Test table ( ID int identity(1,1), Val char(10) ) INSERT INTO @Test…
FILESTREAM storage in SQL 2008
Background Of Late, I was involved in a discussion where people asked on methodology to be adopted for storing images as a part of their reporting project using SQL reporting services. One group believed in storing images on file system…
Importance of specifying length in datatypes
This post is just to emphasize on importance in specifying length while declaring fields,variables or parameters. I have seen quite a few occasions where developers have ignored length part. The problem is depicted below select CAST(‘12.34354’ as numeric) ————————————— 12…
Export to excel from SQL report showing cached data
I have recently encountered a problem in SSRS report. I was basically trying to export to excel from my report. First time I rendered report for a set of parameters and export to excel it worked fine. But subsequent rendering…
SELECT .. INTO table with IDENTITY function
Most often I’ve come across scenarios where we need to generate a unique valued column on the fly. From SQL 2005 onwards, we have the window functions like ROW_NUMBER() for doing this however for earlier versions one typical solution I’ve…