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
906 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
906 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,046 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
290 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
375 reads
The standard way of storing relational database tables on physical media is row based, that is, each row occupies a...
2016-10-18
204 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
263 reads
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What...
2016-10-12
218 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
413 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
344 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
298 reads
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi all, I have a third-party database/application that I'm attempting to augment with functionality...
I am trying to educate myself and understand what are some of the advantages...
i need to configure alert on multiple servers when the t-log reaches or exceeds...