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
2,450 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)
17,457 reads
I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.
2015-03-19
3,658 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
5,891 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
1,948 reads
Recently I needed to write a PowerShell script that could build a backup set...
By Will Assaf
It was awesome to see a great crowd at the triumphant return of Houston...
When working with SQL Server running containers the Error Log is written to standard...
Comments posted to this topic are about the item Is Data the Future of...
Hi All , In my case we’re Looking the cause why in our Always...
Hi All, Currently we have configured Always on - High Availability in our SQL...
Ask SSC