A reader, Virendra Chauhan, shared a UDF that removes duplicate chars from one large string. Here is his REMOVE_DUPLICATE_INSTR function and how to call it.
Finding the Right System View for the Question You Have
Choose SQL Server system views by the question they answer, distinguish catalog metadata from runtime counters, and understand reset boundaries.
SQL SERVER – Correct Syntax for Stored Procedure SP
What is the correct syntax for stored procedure code? Anything between BEGIN and END is part of the procedure, and anything after GO is not, as my examples show.
SQL SERVER – 2005 – List All Stored Procedure in Database
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 – 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.
SQL SERVER – Generate Script with Data from Database – Database Publishing Wizard
Need to copy data along with the schema? The Database Publishing Wizard scripts schema, data or both into one SQL file you can run on another server.
SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution
DBCC CHECKDB checks the logical and physical integrity of every object in a database, and it already runs CHECKALLOC, CHECKTABLE and CHECKCATALOG for you.