Tag Archives: T-SQL

Using conditional COUNT(*)s

Whilst recently working with historic financial data, I ran across a situation that needed an aggregate view of transactional data grouped by a certain set of attributes in order to backfill some missing aggregate data sets. In front of me, I had … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged | 2 Comments

Problem removing files from TempDB

I recently ran into an interesting problem while attempting to remove approximately half of the TempDB data files configured in a testing environment. As you might expect, there are various SQL Server tasks that are performed infrequently by a DBA, and this is … Continue reading

Posted in SQL, SQLServerPedia Syndication, Storage | Tagged , , | 3 Comments

Incrementing SQL Sequences

Sequences were first introduced in SQL Server 2012 and are a way to improve performance in situations that would have traditionally been implemented using the column based identity property. One of the biggest downfalls of the identity property is that new values … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , , , | 1 Comment