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
3,765 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,673 reads
I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.
2015-03-19
4,507 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,970 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
2,009 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Sometimes in life you have to do things you really don’t like to do....
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
Hi, I need to include a very simple schema in all of my database...
This is my first time dealing with CLR assemblies and we have setup some...
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Ask SSC