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
932 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
932 reads
Note: originally published in our old blog on December 2008.
CodeProjectThis is a simple stored procedure that you can use...
2016-10-31
3,623 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
295 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
533 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
272 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
417 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
390 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
306 reads
By Steve Jones
I have been experimenting a bit with graph databases, trying to learn more about...
By Steve Jones
Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on...
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
I have a table with 489M rows and growing. The reason we had to...
Hi All, This is Naveen Maroju. My previous DBA was created distribution database later...
Hi All, I have the column of data in SQL Server. Here I need...