An SSIS package fails with Error 3902: the COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. Two fixes, one is RetainSameConnection set to true.
SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String
A simple UDF, ExtractInteger, to extract only numbers from string input. I test it with a phone number that also has letters in it.
SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling
SQL Server 2005 brings TRY…CATCH for error handling, so you no longer check @@ERROR after every statement. Here is how the TRY and CATCH blocks work.
SQL SERVER – 2005 – Silent Installation – Unattended Installation
Silent installation of SQL Server 2005 in two steps: an .ini file built from template.ini, then setup.exe with /qn or /qb. Plus tips to test it.
SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX
CHARINDEX and PATINDEX both return the start position of a pattern in a text field. PATINDEX allows wildcards, CHARINDEX does not. Examples use AdventureWorks.
SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005
I compared a SQL Server 2005 paging query using ROW_NUMBER() with the SQL 2000 way of paging through temp or derived tables, both run on AdventureWorks.
SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.
TempDB is full and you see Event ID 17052 for the tempdb log? Here is what to check first and how to move TempDB from one drive to another.