LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "bug"

My first SQL 2016 bug

A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent hours creating a VM because there were hundreds of Windows updates). It seems I have already found a very small bug while creating a new database: Apparently they forgot to rename the compatibility level 🙂

Read More...

The shaky bug in SSIS

You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012 has had a make-over. Nothing too drastic, but at least the undo button works. However, sometimes when you drag or move tasks/components on the canvas, they start to shake. A lot. And very annoyingly as […]

Read More...

Dealing with the mysterious “True” column in BIML

Recently I ran into the following error when compiling BIML into SSIS packages: The message itself is not very revealing: The data type for input buffer column ‘True’ on the ScriptComponent input buffer ‘Input0’ does not match the mapped output column from the previous transformation. You might have guessed it already; there is no column […]

Read More...

Running sp_helpdb against a snapshot shows wrong files on SQL Server 2008

If you are using snapshots be aware that running sp_helpdb reports wrong files. Let’s take a look by running some code First create a test database T-SQL1 2 3 4 5 6 7 8 9 use master go   CREATE DATABASE [test] ON  PRIMARY ( NAME = N’test’, FILENAME = N’C:test.mdf’  )  LOG ON ( […]

Read More...

Catching a Visual State Completion in Silverlight

Catching the completion of a visual state change in Silverlight 3

Read More...

When Books On Line is not really correct

A question was posted in our SQL Server programming forum today. A person had this stored procedure T-SQL1 2 3 4 5 6 7 CREATE PROCEDURE TestStuff @id INT, @Val1 VARCHAR(20), @Val2 VARCHAR(20) AS   SELECT @id,@Val1,@Val2 CREATE PROCEDURE TestStuff @id INT, @Val1 VARCHAR(20), @Val2 VARCHAR(20) AS SELECT @id,@Val1,@Val2 Executing it like this works T-SQL1 […]

Read More...

FIX for A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key bug

FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key and there is a single row as the update source in SQL Server 2008 In Microsoft SQL Server 2008, a foreign key constraint may not be enforced when […]

Read More...

LINQ to SQL queries involving strings cause SQL Server procedure cache bloat

Adam Machanic created an item on connect explaining how LINQ to SQL queries involving strings cause SQL Server procedure cache bloat If an application is using LINQ to SQL and the queries involve the use of strings that can be highly variable in length, the SQL Server procedure cache will become bloated with one version […]

Read More...

You may receive an error message, or the computer may stop responding, when you host Web applications that use ASP.NET on a computer that is running Windows Server 2003

Got an email from a friend who is suffering from this problem Here are the symptoms When you host Web applications that use Microsoft ASP.NET on a computer that is running Microsoft Windows Server 2003, you may experience decreased performance. This issue may occur when you host the Web applications in multiple application pools on […]

Read More...