Monthly Archives: August 2013

SQL Server Deadlock Detection Script

use master go select cntr_value from sysperfinfo where counter_name = ‘Number of Deadlocks/sec’ order by cntr_value   Related error log messages might show up like that shown below: Source¬†¬†spid29s Message Failure to send an event notification instance of type ‘DEADLOCK_GRAPH’ on conversation handle ‘{E96F2738-83CF-E111-8D19-00237D585B2C}’. Error Code = ‘8429’.

Read More

Microsoft SSIS 2012 Data Import – WA State Corporation Data

Below are screenshots of SSIS – Microsoft SQL Server Integration Services 2012 importing data from Washington State Secretary of State Corporations public data file. Click here for the source link.   Below is the target table creation T-SQL code USE [CorpWA] GO /****** Object: Table [dbo].[Corporations] Script Date: 8/2/2013 12:16:57 AM ******/ SET ANSI_NULLS ON […]

Read More