Summary of how to manage FULL TEXT indexing in TSQ
this script describes the steps neccessary to implement full text indexing in TSQL on your SQL SERVER systemCan be used programatically in tsql code
2002-07-10
736 reads
Scripts
Find Duplicated rows
This is a very simple and small stored procedure which will help you identify repeated rows on any given table. This is specially useful for situations when you want to clean up a table and add a primary key on it, but you cannot until all duplication is eliminated. Only two parameter are necessary; table […]
2002-07-08
1,090 reads
Delete Duplicates
Deletes the duplicates from a table based upon any fields in the table leaving a single copy of the record in the table.
2002-07-04
935 reads
Dynamically Alter all your Tables.....
This script allows you to dynamically alter all the tables in your database. In the script i am building up an alter statement that adds a 'TimeStamp' column a table.If anyone knows a better way to do this kind of thing, feel free to drop me a mail (jamie.moffat@infographics.co.uk)
2002-07-04
772 reads
Find Duplicates
Returns the key fields of all duplicate rows in a table based upon any fields in the table.
2002-07-04
755 reads
Generate Column Listing
Returns an ordered column listing for the specified table, stored procedure, or view.
2002-07-04
484 reads
Generate Date Range
Generates a rowset with a datetime values for every day between a start datetime and end datetime.
2002-07-04
646 reads
2002-07-04
693 reads
Index Locking Strategy
This script returns the index locking strategy informationfor all user tables in a database. It also generates the required TSQL statement to alter locking strategies if required. These statements require CTRL-C and CTRL-V individually into query analyser for execution. Results are best viewed in text only. This TSQL can be wrapped in a stored procedure […]
2002-07-04
1,395 reads
VB6/ADO Stored Procedure Call Generator
Generates a VB6/ADO procedure prototype, procedure call, and ADO Command Object Parameters.Append calls. To use, simply set the @spname variable equal to the name of your stored procedure, run, and cut and paste the output into you VB program. The generated code may require some slight modifications, but this should save you a lot of […]
2002-07-04
1,086 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
ALAMAT KANTOR BCA KCP Pondok Bambu Telp:083831618008
WhatsApp:0838-3161-8008 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blk A/5-6, RT.2/RW.2, Wil, Kec. Duren...
Alamat Kontak Bank BCA KCP Sabang Telp:08218154392
WA CS (08218154392) Jl. H. Agus Salim No.57 B, RT.3/RW.1, Kb. Sirih, Kec. Menteng,...
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers