Tag Archives: T-SQL

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

VIEW, Pugh, Barney McGrew…

…Cuthbert, Dibble, Grub. I never ceases to amaze me that there is always that little bit of SQL Server functionality that you didn’t know about. Some of it good and some of it bad, some of it just meh… The … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , , ,