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
2,948 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
12,163 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)
18,915 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
7,482 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,289 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,218 reads
Blogs
Converting Types in C#
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
Daily Coping 22 Mar 2023
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
FIRST Robotics Competition 2023 - World Championships!
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Forums
Weird chars at beginning of XML file
Hi, each day we are sent an email with an XML attachment. Recently the...
Query based on sorting based on month
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
SSRS 2017 - SSRS 2019 migration
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
Ask SSC