SQL Split String Function (STRING_SPLIT in 2016)
* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference
As a SQL Server developer you...
2016-11-01
1,005 reads
* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference
As a SQL Server developer you...
2016-11-01
1,005 reads
Note: originally published in our old blog on December 2008.
CodeProjectThis is a simple stored procedure that you can use...
2016-10-31
4,577 reads
Applies to: xSQL Data Compare v7.0.0 – v9.0.0
Business Need
A very common organization of the data infrastructure for big companies who operate...
2016-10-27
300 reads
Applies to: xSQL Data Compare v7.0.0 - v9.0.0
Nowadays, Quality Assurance (QA) is a very important part of the development process for any...
2016-10-20
606 reads
The standard way of storing relational database tables on physical media is row based, that is, each row occupies a...
2016-10-18
207 reads
As a SQL Server DBA or developer here is what you should know about memory-optimizedtables (in-memory tables):
Introduced in SQL Server 2014Primary...
2016-10-13
284 reads
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What...
2016-10-12
219 reads
If you've ever designed a database you've most certainly run into the need for what we called history tables, those...
2016-10-11
419 reads
Applies to: xSQL Schema Compare v7.0.0 – v 9.0.0, xSQL Data Compare v7.0.0 – v9.0.0
Description: Using xSQL Schema Compare and xSQL Data...
2016-10-06
403 reads
Applies to: xSQL Schema Compare v 7.0.0 to v 9.0.0; xSQL Data Compare v 7.0.0 to v 9.0.0
Summary: When adding...
2016-09-21
315 reads
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
Comments posted to this topic are about the item The Cloud Security Problem, which...
Hi, I have a simple table with 5 columns as follows with about 80,000...
hi everyone I have a SP that is run in SSIS. That particular SP...