Proper configuration of the TempDB system database is crucial for optimal performance of a SQL Server instances during heavy loads. The recommended...
2016-02-04 (first published: 2016-01-31)
8,147 reads
It’s the first day of the year 2016 and I’m thinking about all the SQL events I attended in 2015.
SQL Sat...
2016-01-01
521 reads
My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible...
2015-12-03 (first published: 2015-11-29)
2,796 reads
Row-Level Security (RLS) is a new feature of SQL Server 2016 and Azure SQL Database that enables data access control based...
2015-08-28
3,355 reads
In the on-premises world, when we install a SQL Server on our own servers, we decide on SQL Version (2012, 2014….), Edition (Standard, Enterprise,...
2015-06-10
23,103 reads
There are two flavors of SQL Server in Azure: one is the traditional SQL Server platform hosted in Azure virtual machines,...
2015-05-09
961 reads
The number of Microsoft’s cloud services is growing by month, if not week, so that it’s hard to keep them all...
2015-05-03
648 reads
Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of...
2015-04-29
17,503 reads
Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant...
2015-04-20
2,284 reads
You can easily determine whether existing stored procedures, UDFs and views can work in a higher (or lower, if you wish) compatibility...
2015-04-13
4,851 reads
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Hey all, Just wondering how do you guys / girls set up git repo(s)...
hi everyone I am planning on adding a composite key for my tables. I...
We have a Production/Live version with up-to-date data and a Test version with older...
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOselect STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;