Reseeding Identity values
This Script inturn generates Script to Reseed the values of identity column
2007-11-02 (first published: 2007-08-03)
759 reads
Scripts
How to insert and update from remote linked server
Please read the how to use. unfortunately the orignal document i submitted was truncated 🙁
and i dont have time to remember what i said
2007-10-30 (first published: 2007-08-07)
2,670 reads
Create Log tables and Triggers
Usually in business applications it is necessary to maintain the history of the data being modified for auditing purposes or for later analysis. Proven way to achieve this is to create a log table for each datatable with an additional column "Action" to indicate what the user has done on the data (either insert, update […]
2007-10-26 (first published: 2007-08-09)
6,330 reads
Find Table Usage
Creates a printable report of all stored procedures, views, triggers and user-defined functions that reference any of the tables passed into the procedure.Wrote this to easily list items affected by table changes when working in a fast-paced development environment developing a shrink wrapped product undergoing many schema changes.Split function is listed after sp definintion
2007-10-23 (first published: 2005-07-27)
3,353 reads
Find Column Name Usage
This procedure produces a formatted report to list which tables, views and table functions have a column of the specified name. This is particularly useful in systems that do not enforce referential integrity or when schema changes are being evaluated.
2007-10-22 (first published: 2007-07-19)
4,197 reads
2007-10-19 (first published: 2007-07-25)
9,373 reads
MOM 2005 Datawarehousing Catchup
I wrote this script because our MOM Datawarehousing got so damn behind.Every time the windows Scheduled task tried to run to warehouse the dataout of OnePoint, it would puke because the SQL log would fill up. Thisallows you to start so many days out and it will increment it down by the number of days […]
2007-10-18 (first published: 2007-07-26)
1,419 reads
setting full text search using script
This script will help you to understand how to set & use full text search.
2007-10-18
608 reads
MOM SCDWgroom Enhancement
It might not be useful now, but if you ever wanted to downsize the amount of data that you keep in your datawarehouse, good luck. This will help you do that. This job is set to shrink it down to 120 days, but you can adjust it as you like. Runs again in 5 day […]
2007-10-16 (first published: 2007-07-26)
569 reads
How to empty database
Sometimes you need to empty the content of database. Following script can do that for you.
2007-10-15
4,914 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers