Bugs - Simon Sabin UK SQL Consultant's Blog

Browse by Tags

All Tags » Bugs (RSS)
19 January 2010 19:05

Error: The type of the value being assigned to variable ?? differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object

If you get the above error and you have no idea why (i.e you haven't changed the data type of a variable) then it is likely due to a data type inference issue with SSIS. You might think that SQL is returning a value of one type when in fact it isn't...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
14 January 2010 19:21

User defined function performance is awful, Micorosft please sort this out

User defined functions looked like something great when they were introduced in SQL 2005. They are a very logical step to make more code reuseable by wrapping common code in functions. It is an approach that is in development 101 and something everyone does and looks to doing.

So what is the problem with SQL Server.

Well the issue is that ......

...
Posted by simonsabin | 5 comment(s)
Filed under: , , , , , , , ,
14 January 2010 17:14

"unable to switch the encoding" when deploying XML Schemas using Database Professional

I've just blogeed about how to use XML Schema Collections in Visual Studio Database Professional Project I mentioned there is one gotcha about. The gotcha is if you have UTF-8 encoded schemas then they fail to be deployed. This is because they get...
Posted by simonsabin | 3 comment(s)
Filed under: , ,
10 March 2009 21:52

A significant part of sql server process memory has been paged out

Do you have the following occuring on your SQL Server system. If so it is likely you are running SQL Server 2005 or SQL Server 2008 Standard edition on x64 hardware. It will be causing you serious performance issues when it occurs, as all your database...
Posted by simonsabin | 1 comment(s)
Filed under: , , , ,
03 November 2008 23:09

Gotchas in Management Studio 2008

If you script objects in management studio 2008 be careful its a bit forgetful. If you are using a case insensitive collation and you have objects that refer to other objects but use different case for the object names then when you try and script objects...
Posted by simonsabin | 1 comment(s)
Filed under: ,
06 November 2007 14:43

What application doesn't have UNDO in today's world

Well the first that is close to my heart is Integration Services and its really annoying. I tried to track down a connect item for this but couldn't find a specific one. So I raised one https://connect.microsoft.com/SQLServer/feedback/ViewFeedback...
Posted by simonsabin | with no comments
Filed under: , , , ,
22 September 2007 23:00

Full text thesaurus files bug in documentation

I don't normally blog about documentation errors generally because they're often not that major however this one is fundamental what is being explained. This is the page online http://msdn2.microsoft.com/en-us/library/7f5424a4-a72c-44dc-b455-786a12767c99...
Posted by simonsabin | with no comments
Filed under: , ,
01 June 2007 16:55

SQL 2005 install hangs on "Setting File Security"

When doing an install of SQL 2005 you may encounter the install hanging on the "setting file security" stage. This is due to th install trying to do some security resolution with domain controllers. The easiest answer is to unplug the network...
Posted by simonsabin | 5 comment(s)
Filed under: , , ,
08 March 2007 07:54

Maintenance plan warning for SP2

Due to a regression bug introduced in SP2 some of the maintenance plan tasks that can operate on multiple databases may not perform as expected. If a maintenance plan component uses TSQL of this nature USE [DBFred] GO DBCC CHECKDB.... GO USE [DBSimon...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , ,
30 November 2006 23:18

SSMS Custom reports - Drill through reports

If you intend using the new custom reports feature of Management Studio and develop a set of reports that you can navigate between then be aware of a feature where by if you refresh a drill through report the some of the parameters are not maintained...
Posted by simonsabin | with no comments
Filed under: ,
04 October 2006 20:58

SQL Server sucks - Stop complaining and do something about it

Further to my last post about the BULK UPDATE suggestion I have made, if you have any suggestions or bugs of your own then please put them into connect. Please also support the bugs and suggestions that others have raised. The list of non-closed bugs...
Posted by simonsabin | with no comments
Filed under: , ,