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
Ramya Makam
TempDB growth due to version store on AlwaysOn secondary server
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
SELECT INTO vs INSERT INTO on Columnstore
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
Mail Fails with SQLCMD Error
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
How does a View work on a Table with a Clustered Columnstore Index ?
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
Clustered Columnstore Index Gives "Unable to find index entry" Error
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
Blogs
Creating an Empty Repo in GitHub–#SQLNewBlogger
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
Product Review: DataVeil
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
The Last Price Bump for the Data Community Summit
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Forums
Transaction log full due to LOG_BACKUP
1 of my production database's transaction log file is full due to some backup...
Calender Error in SSRS with SSAS Tabular Source
I have a report which get a Date Parameter.. I don't want to display...
Calender Error in SSRS with SSAS Tabular Source
I have a report which get a Date Parameter.. I don't want to display...
Ask SSC