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,049 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,379 reads
I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.
2015-03-19
3,401 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,877 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,933 reads
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...
This is the first in a series of posts about gatekeeping in Information Technology...
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
Trying to understand why when I search for numerics in full text, contains does...
MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new...
I have a package running in SQL 2016 using Project Deployment. One of the...
Ask SSC