Category Archives: 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

Have you submitted to SQL Nexus yet?

If you have not already heard, SQL Nexus (a next generation SQL Server focused event) will be held on May 2nd – 4th 2016 in Copenhagen, Denmark. The “idea” for SQL Nexus (w|t) was first conceived in 2012 more as a … Continue reading

Posted in Community, Events, SQL, SQLServerPedia Syndication | Tagged | Leave a comment

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