Rotating Header Image

Posts Tagged ‘tempdb’

Microsoft…. Y U NO FIX??

  I would like…. if I may… it take you on a strange journey…. Consider this: A SQL Server database with ALLOW_SNAPSHOT_ISOLATION set to true A stored procedure that creates a #temp table in tempdb and subsequently drops it Multiple calls of this stored procedure (running in Snapshot Isolation mode) happening at the same time […]

Moving tempdb

Best practice dictates that tempdb should reside on it’s own physical drive(s).  There are many good reasons to do this but the two that normally get brought up and discussed are that tempdb is too big on the current drive and/or the desire to increase performance by having tempdb on different physical drives. In order to […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.