Fast parse supports the following string formats for date, YYYYMMDD and YYYY-MM-DD Basic and extended formats for a four-digit year, a two-digit month, and a two-digit day, for the extended format, the date parts are separated by a hyphen (-), also it's...

Fast parse supports the following string formats for date, YYYYMMDD and YYYY-MM-DD Basic and extended formats for a four-digit year, a two-digit month, and a two-digit day, for the extended format, the date parts are separated by a hyphen (-), also it's...

SQL Server 2012 is full rich of new features for SSIS, really many new useful stuff, such as the script task debug and the renovated Flat File Source, that could handle uneven number of columns... Today I am going to demonstrate 4 new SSIS expressio...

At one point, I created a demo script whereby one could retrieve the next value in a SQL Server 2012 sequence and use that value in a UNION ALL clause. That worked up to and including CTP 3. It never worked with plain UNION. I never tested it on RC0,...

I learned about this from Pinal Dave's blog(You can see the original article in references.) In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...

I learned about this from Pinal Dave's blog(You can see the original article in references.) In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...

The challenge idea is taken from a problem discussed in the MSDN TSQL forum. The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report

As we know, automatically created statistics, as can be see with <pre class="brush:sql"> SELECT * FROM sys.Stats WHERE object_id LIKE OBJECT_ID('MyTable') </pre> (only change 'MyTable' for something else), has name starting with _WA_Sy_....

As we know, automatically created statistics, as can be see with <pre class="brush:sql"> SELECT * FROM sys.Stats WHERE object_id LIKE OBJECT_ID('MyTable') </pre> (only change 'MyTable' for something else), has name starting with _WA_Sy_....

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...