Rotating Header Image

Posts Tagged ‘Temp Tables’

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 […]

Temp Tables and Primary Keys

Just a quick little post today on a little “gotcha” that may getcha. Let’s say you’re creating a stored procedure that needs to create a #temp table that has a PRIMARY KEY.  You will want to be careful about how you create this #temp table and here is why: Open SQL Server Management Studio and run the […]

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