Just to add...Variable's names' are case sensitive too.......

Hi sherry, Enjoyed reading the article. but was concerned about how many rows you were using in your test, also what's your T-SQL code? are you using MERGE or just INTERSECT and EXCEPT ? Thanks...

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"...

Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....

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...

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,...