Monthly Archives: August 2011

SSIS export to Excel – Data type issue – “Number Stored as Text”

ISSUE: SQL export to Excel using SSIS We want to export numeric data directly to Excel but the rows come out as “Number Stored as Text” Why is this and how do we get around it so that the numeric … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , , | 3 Comments

SQL Server BUG – May cause loss of data – Changing a column from NULLable in to NOT NULL

There is a bug in SQL Server (2008 R2 fully patched) when you change a column from NULLABLE to NOT NULL which can cause loss of data This bug has been around for ages and I have been caught out … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , | Leave a comment

SQL Server performance (2008)

SQL uses dynamic management views to show loads of very useful information about itself and its performance. One of the more useful dmv’s for performance tuning is sys.dm_os_performance_counters You can query this simply like this SELECT * FROM sys.dm_os_performance_counters but … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , | Leave a comment

Looking for suspicious data

When you get data in large quantities on a regular basis it is easy to miss problems. These problems can occur for numerous reasons. Here are some examples… Data may be imported twice Decimal points in the wrong places Corruption … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , | 1 Comment