In this blog post we will see how we can convert ASCII to Decimal and Decimal to ASCII. In simple words, we will see the decimal and ASCII conversion.
SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples
How trigger recursion and nesting work in SQL Server 2005: triggers nest up to 32 levels, recursive triggers fire themselves, and both can be turned off.
SQL SERVER – Disable Index – Enable Index – ALTER Index
When DTS, BCP or BULK INSERT needs an index out of the way, I prefer to disable index with ALTER INDEX and enable it again with REBUILD. AdventureWorks example.
SQL SERVER – Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction
Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQL SERVER – Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery
Error 130 says you cannot perform an aggregate function on an expression containing an aggregate, like AVG(COUNT()). A derived table gets around it.
SQL SERVER – Binary Sequence Generator – Truth Table Generator
A script that builds a 512 row truth table with its decimal value and binary sequence, using CROSS JOINs on a bit table. Add or remove joins to resize it.
Last Line of a SQL Script: The Joke Every DBA Has Lived
The last line of a SQL script decides whether your work is saved, rolled back, or still holding locks. Here are the classic endings and how to check them.