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
1,890 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
5,084 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)
17,893 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
4,831 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,019 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,082 reads
Blogs
VMworld 2020 – Top 10 Database Sessions (Part 2)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Daily Coping 25 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
VMworld 2020 – Top 10 Database Sessions (Part 1)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Forums
SQLServer Agent not sending dbmail on job completion
Hi Everyone! I have a problem with a SQL Server 2017 with dbmail. I...
Ignore the entire record if a matching record is found
Hello, Kindly guide me with the following code in T-SQL. I need to only...
New Stuff Can Be Scary
Comments posted to this topic are about the item New Stuff Can Be Scary
Ask SSC