Want to see all stored procedure in database at once? Run SELECT * FROM sys.procedures. This simple query works only with SQL Server 2005.
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
What is Third Normal Form and what is its advantage? I ask this in every interview I take. Here are the rules of 3NF and its cost in performance.
SQLite or SQL Server Express for a Small App
SQLite or SQL Server Express depends on write concurrency, deployment, backup, and the growth path your small application really needs.
Multiset Intersection: Keep the Matching Duplicate Occurrences
Multiset intersection keeps the duplicate count shared by both inputs rather than returning each common value once. I pair numbered occurrences to express that requirement. The result should contain the smaller count for each equivalent value.
Binary Conversion Styles: Hex With and Without 0x
Binary conversion styles control hexadecimal prefixes. Pair the output and input styles, preserve empty bytes and verify a complete round trip.
SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2
About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments.
SQL SERVER – Generate Incremented Linear Number Sequence
A reader asked how to generate an incremented linear number sequence in SQL Server, like a sequence in Oracle. A short WHILE loop script does it.