Adding a Database with Polybase External Tables to Always On Availability Group
Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.
2020-05-26
3,184 reads
Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.
2020-05-26
3,184 reads
On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.
2016-11-07
13,831 reads
This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.
2016-08-05 (first published: 2015-06-09)
19,053 reads
I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.
2015-03-19
8,168 reads
This article is about how a view works when it is created on a table with clustered columnstore index on it.
2015-02-05
6,360 reads
The Clustered columnstore index generates "unable to find index entry" error and a memory dump after few DMLs on the table
2014-09-02
2,253 reads
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
1 of my production database's transaction log file is full due to some backup...
I have a report which get a Date Parameter.. I don't want to display...
I have a report which get a Date Parameter.. I don't want to display...