SQL Server Blog - SQL Server - Toad World

SQL Server Community

SQL Server Blog

Denny Cherry
Follow /26 Apr 2017 at 5:00pm / SQL Server Blog

Partitioned Tables and ColumnStore

ColumnStore indexes are all the rage with data warehouses. They’re fast, they’re new(ish) and they solve all sorts of problems when dealing with massive amounts of data.  However they can cause some issues as well if you aren’t very...
78 0 /
Arun Sirpal
Follow /22 Mar 2017 at 1:00pm / SQL Server Blog

My path from a junior to a senior DBA

A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read. Time … Continue reading →
356 0 /
Pinal Dave
Follow /21 Mar 2017 at 1:30am / SQL Server Blog

SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files

This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the initial size itself was huge and when they tried to shrink...
246 0 /
Arun Sirpal
Follow /20 Mar 2017 at 6:30am / SQL Server Blog

TDE: Looking inside your database and backups

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabling TDE and comparing it to … Continue reading...
202 0 /
Nakul Vachhrajani
Follow /20 Mar 2017 at 3:30am / SQL Server Blog

#0403 – SQL Server – CAST/CONVERT to string – Pad zeroes or spaces to an integer

Padding zeroes to an integer is often required during data migrations and integrations. Here is the approach I use in such data conversions.
224 0 /